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 (602666, 577919, 577918, 5499, 345329, 142719, 45782, 18493, 20864, 33936, 95930, 416881, 508820, 3320, 11876, 11877, 7294, 7296, 365454, 256443, 270013, 270014, 309985, 161826, 220939, 220941, 230931, 231360, 51348, 64233)) 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,602666,577919,577918,5499,345329,142719,45782,18493,20864,33936,95930,416881,508820,3320,11876,11877,7294,7296,365454,256443,270013,270014,309985,161826,220939,220941,230931,231360,51348,64233)
-
SKU: PAN-20153
Model: S-E100
Condition: New-In-Box
Mount Type: L Mount
-
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-00325
Model: H-F007014
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-20098
Model: S-S85
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-00341
Model: H-ES200
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-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-00550
Model: S-S35
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-20099
Model: H-ES12035
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-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-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-20091A
Model: S-R70300
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-20040
Model: S-E2470
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-20030
Model: S-R1635
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-20088
Model: S-E70200
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-20035
Model: S-R2060
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-00340
Model: H-ES50200
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-20050
Model: S-R24105
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-20090
Model: S-R70200
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-003261
Model: H-FSA14140
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00325D2
Model: H-H014AK
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00325CH
Model: H-FS12060
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00325DA2
Model: H-FS1442AKA
Condition: New-In-Box
Mount Type: Micro Four-Thirds