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, 577919, 577918, 577917, 577868, 383565, 225416, 142719, 159433, 45782, 45783, 18493, 20864, 29364, 79633, 95930, 124405, 17156, 476969, 508820, 511249, 11876, 11877, 7296, 14370, 14371, 14372, 14657)) 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,577919,577918,577917,577868,383565,225416,142719,159433,45782,45783,18493,20864,29364,79633,95930,124405,17156,476969,508820,511249,11876,11877,7296,14370,14371,14372,14657)
-
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-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-00360
Model: DC-GH5M2BODY
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00201
Model: DC-FZ1000M2
Condition: New-In-Box
-
SKU: PAN-00341
Model: H-ES200
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00299S
Model: DC-ZS200DS
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-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-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-00321RL
Model: DC-GH5LK
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-00905
Model: DC-G95DMK
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-20099
Model: H-ES12035
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00184
Model: DC-S5M2XBODY
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-00325DAE
Model: H-PS14042K
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00325DAF
Model: H-PS14042S
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00325DA
Model: H-FS014042
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00321J
Model: DMC-G5KBODY
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00321K
Model: DMC-G5SBODY
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00321L
Model: DMC-G5WBODY
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00328S
Model: H-FS45150S
Condition: New-In-Box
Mount Type: Micro Four-Thirds