SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `mst_sorting_index` AS `mst_sorting_index_1` ON mst_sorting_index_1.product_id = e.entity_id AND mst_sorting_index_1.store_id = 1
LEFT JOIN `mst_sorting_index` AS `mst_sorting_index_0` ON mst_sorting_index_0.product_id = e.entity_id AND mst_sorting_index_0.store_id = 0
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
INNER JOIN `catalog_product_entity` AS `product` ON product.entity_id = e.entity_id
LEFT JOIN `inventory_stock_2` AS `stock_status_index` ON product.sku = stock_status_index.sku WHERE (e.entity_id IN (7280, 7334, 7640, 12829, 12830, 13794, 13795, 4198, 4199, 4201, 4202, 4203, 4232, 2289, 2291, 2292, 2296, 2299, 3319, 10703, 370876, 380775, 383866, 385049, 385224, 385251, 385263, 386799, 458122, 461925)) ORDER BY IFNULL(mst_sorting_index_1.factor_2_score, IFNULL(mst_sorting_index_0.factor_2_score, 0)) * 50 desc, FIELD(e.entity_id,7280,7334,7640,12829,12830,13794,13795,4198,4199,4201,4202,4203,4232,2289,2291,2292,2296,2299,3319,10703,370876,380775,383866,385049,385224,385251,385263,386799,458122,461925)
-
SKU: LEI-50130
Model: 18720
Condition: New-In-Box
-
SKU: LEI-30242
Model: 11663
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30274
Model: 11884
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30258
Model: 11891
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-60140
Model: Unavailable
Condition: New-In-Box
-
SKU: LEI-40116
Model: 18450
Condition: New-In-Box
-
SKU: LEI-40118
Model: 18452
Condition: New-In-Box
-
SKU: LEI-30278
Model: 11-646
Condition: New-In-Box
-
SKU: LEI-20214
Model: 11050
Condition: New-In-Box
-
SKU: LEI-20230
Model: 11070
Condition: New-In-Box
-
SKU: LEI-20244
Model: 11053
Condition: New-In-Box
-
SKU: LEI-80116
Model: 10252
Condition: New-In-Box
-
SKU: LEI-40136
Model: 18706
Condition: New-In-Box
-
SKU: LEI-30246
Model: 11879
Condition: New-In-Box
-
SKU: LEI-20224
Model: 11051
Condition: New-In-Box
-
SKU: LEI-20234
Model: 11052
Condition: New-In-Box
-
SKU: LEI-60610
Model: 14444
Condition: New-In-Box
-
SKU: LEI-50530
Model: Unavailable
Condition: New-In-Box
-
SKU: PAN-00328
Model: H-ES045
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: LEI-30224
Model: 11145
Condition: New-In-Box
Mount Type: Leica M
-
[Black, Silver]
SKU: LEI-M10-R BODY
Model: 20002, 20003
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-11189
Model: 11189
Condition: New-In-Box
Mount Type: L Mount
-
[Black, Silver]
SKU: LEI-M SUMMARIT 90MM 24
Model: 11684, 11685
Condition: New-In-Box
Mount Type: Leica M
-
[Black, Silver]
SKU: LEI-M SUMMARIT 75MM 24
Model: 11682, 11683
Condition: New-In-Box
Mount Type: Leica M
-
[Black, Silver]
SKU: LEI-M SUMMARIT 50MM 24
Model: 11680, 11681
Condition: New-In-Box
Mount Type: Leica M
-
[Black, Silver]
SKU: LEI-APO-SUMMICRON-M-50-2
Model: 11186, 11187
Condition: New-In-Box
Mount Type: Leica M
-
[Black, Silver]
SKU: LEI-ELMARIT-TL 18 2.8 ASPH
Model: 11088, 11089
Condition: New-In-Box
Mount Type: L Mount
-
[Black, Silver]
SKU: LEI-T 60 28
Model: 11086, 11087
Condition: New-In-Box
Mount Type: L Mount
-
[Black, Silver]
SKU: LEI-BP-SCL7
Model: 24026, 24029
Condition: New-In-Box
-
SKU: LEI-10881
Model: 10886
Condition: New-In-Box
Mount Type: L Mount