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 (613775, 602923, 602922, 602833, 602666, 577920, 577919, 577918, 577917, 577868, 15174, 7614, 7769, 5499, 17806, 18292, 18493, 17156, 17346, 20864, 29364, 33936, 79633, 95930, 142719, 142722, 45782, 45783, 55918, 59261)) 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,613775,602923,602922,602833,602666,577920,577919,577918,577917,577868,15174,7614,7769,5499,17806,18292,18493,17156,17346,20864,29364,33936,79633,95930,142719,142722,45782,45783,55918,59261)
-
SKU: PRE-PAN-20060
Model: S-R28200
Condition: Preorder
Mount Type: L Mount
-
SKU: PAN-003224
Model: DC-G100DVK
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-003223
Model: DC-G100DKK
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00398
Model: DMW-SHGR2
Condition: New-In-Box
-
SKU: PAN-20153
Model: S-E100
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-00349
Model: DMW-BG1
Condition: New-In-Box
-
SKU: PAN-00338
Model: H-RSA100400
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00327N2
Model: H-ES35100
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00957
Model: DC-G9M2LK
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00955
Model: DC-G9M2BODY
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00357L
Model: DMW-BLF19
Condition: New-In-Box
-
SKU: PAN-00359
Model: DMW-BMB9
Condition: New-In-Box
-
SKU: PAN-00355
Model: DMW-BLC12
Condition: New-In-Box
-
SKU: PAN-00325
Model: H-F007014
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PRO-33556
Model: 1982
Condition: New-In-Box
-
SKU: PAT-00079
Model: PTP341
Condition: New-In-Box
-
SKU: PAN-00327M
Model: H-FS35100K
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00327S
Model: H-NS043
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00357P
Model: DMW-BLH7
Condition: New-In-Box
-
SKU: PAN-00327J
Model: H-HS030
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00155
Model: DMC-FZ300K
Condition: New-In-Box
-
SKU: PAN-00327H
Model: H-H025K
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00158
Model: DMC-FZ2500
Condition: New-In-Box
-
SKU: PAN-00336
Model: H-FSA100300
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00341
Model: H-ES200
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00352K
Model: DMW-BGG9
Condition: New-In-Box
-
SKU: PAN-00339
Model: H-RS100400
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00298K
Model: DMC-ZS100K
Condition: New-In-Box
-
SKU: PAN-00357N
Model: DMW-BLG10
Condition: New-In-Box
-
SKU: PAN-00357Z
Model: DMW-ZSTRV
Condition: New-In-Box
