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 (183980, 191727, 46828, 46830, 46832, 47460, 61518, 61519, 17832, 18025, 18362, 18508, 18509, 18510, 20592, 21308, 21309, 21310, 21744, 21752, 21754, 21780, 21781, 21782, 21784, 21789, 21956, 23902, 24568, 25639)) 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,183980,191727,46828,46830,46832,47460,61518,61519,17832,18025,18362,18508,18509,18510,20592,21308,21309,21310,21744,21752,21754,21780,21781,21782,21784,21789,21956,23902,24568,25639)
-
SKU: LEI-80005
Model: 40342
Condition: New-In-Box
-
SKU: LEI-20205
Model: 11177
Condition: New-In-Box
Mount Type: L Mount
-
SKU: LEI-11672
Model: 11672
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-11674
Model: 11674
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-11677
Model: 11677
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-40030-CP
Model: 18435
Condition: New-In-Box
-
SKU: LEI-30717
Model: 19505
Condition: New-In-Box
-
SKU: LEI-30718
Model: 19501
Condition: New-In-Box
-
SKU: LEI-30259
Model: 11141
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-20226
Model: 11056
Condition: New-In-Box
Mount Type: Leica S
-
SKU: LEI-30318
Model: 14470
Condition: New-In-Box
-
SKU: LEI-20108
Model: 10804
Condition: New-In-Box
Mount Type: Leica S
-
SKU: LEI-40050N
Model: 18440
Condition: New-In-Box
-
SKU: LEI-40050S
Model: 18441
Condition: New-In-Box
-
SKU: LEI-30164
Model: 10302
Condition: New-In-Box
-
SKU: LEI-30402
Model: 14549
Condition: New-In-Box
-
SKU: LEI-30404
Model: 14550
Condition: New-In-Box
-
SKU: LEI-30406
Model: 14495
Condition: New-In-Box
-
SKU: LEI-30162
Model: 10772
Condition: New-In-Box
-
SKU: LEI-30163
Model: 10773
Condition: New-In-Box
-
SKU: LEI-80129
Model: 40093
Condition: New-In-Box
-
SKU: LEI-30240
Model: 11675
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30247N
Model: 11671
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30247S
Model: 11679
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30255
Model: 11667
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30260
Model: 11826
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-29990
Model: 14872
Condition: New-In-Box
-
SKU: LEI-30322
Model: 14499
Condition: New-In-Box
-
SKU: LEI-30233
Model: 11668
Condition: New-In-Box
Mount Type: Leica M
-
SKU: LEI-30802
Model: 18767
Condition: New-In-Box