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 (602923, 602922, 17156, 5499, 18493, 20864, 33936, 64235, 79633, 124405, 45783, 476969, 367854, 225416, 16515, 16516, 17559, 14370, 14371, 14372, 14657, 10874, 11876, 11877, 7293, 7294, 7296, 3320, 20865, 23665)) 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,602923,602922,17156,5499,18493,20864,33936,64235,79633,124405,45783,476969,367854,225416,16515,16516,17559,14370,14371,14372,14657,10874,11876,11877,7293,7294,7296,3320,20865,23665)
-
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-00327S
Model: H-NS043
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00325
Model: H-F007014
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
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-00327H
Model: H-H025K
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00328R1
Model: H-FS45150AK
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00158
Model: DMC-FZ2500
Condition: New-In-Box
-
SKU: PAN-00321RL
Model: DC-GH5LK
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00298K
Model: DMC-ZS100K
Condition: New-In-Box
-
SKU: PAN-00905
Model: DC-G95DMK
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-003221
Model: DC-G100KK
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00201
Model: DC-FZ1000M2
Condition: New-In-Box
-
SKU: PAN-00327A
Model: H-H020AK
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00327B
Model: H-H020AS
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00326G
Model: H-X015
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
-
SKU: PAN-00327G
Model: H-X025
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
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-00325C
Model: H-FT012
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00325B
Model: H-F008
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-00330
Model: H-FS045200
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00327P
Model: H-HS043K
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00321TN
Model: DMC-G7KK
Condition: New-In-Box
Mount Type: Micro Four-Thirds
