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, 45782, 45783, 55918, 59261, 64235, 17806, 18292, 18493, 20864, 29364, 33936, 79633, 95930, 223792, 225416, 228061, 124405, 140866, 142719, 142722)) 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,45782,45783,55918,59261,64235,17806,18292,18493,20864,29364,33936,79633,95930,223792,225416,228061,124405,140866,142719,142722)
-
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-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
-
SKU: PAN-00328R1
Model: H-FS45150AK
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-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-00352M
Model: DMW-BLJ31
Condition: New-In-Box
-
SKU: PAN-00201
Model: DC-FZ1000M2
Condition: New-In-Box
-
SKU: PAN-003531
Model: DMW-BGS1
Condition: New-In-Box
-
SKU: PAN-00321RL
Model: DC-GH5LK
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PRO-33558
Model: 8847
Condition: New-In-Box
-
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
