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, 577919, 577918, 577917, 577868, 5499, 383565, 460126, 476969, 367854, 45782, 64235, 18493, 20864, 33936, 95930, 17156, 124405, 142719, 508820, 7293, 7294, 7296, 10874, 11876, 11877, 14370, 14371, 14372)) 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,577919,577918,577917,577868,5499,383565,460126,476969,367854,45782,64235,18493,20864,33936,95930,17156,124405,142719,508820,7293,7294,7296,10874,11876,11877,14370,14371,14372)
-
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-00325
Model: H-F007014
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-00452
Model: H-X09
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-003221
Model: DC-G100KK
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-00328R1
Model: H-FS45150AK
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-00336
Model: H-FSA100300
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-00321RL
Model: DC-GH5LK
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-20099
Model: H-ES12035
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-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-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
