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, 577917, 577868, 45783, 79633, 124405, 383565, 476969, 367854, 225416, 511249, 511250, 78750, 142720, 159433, 182027, 383564, 330305, 330306, 420713, 438275, 438277, 256423, 220935, 220936, 511251, 511252)) 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,577917,577868,45783,79633,124405,383565,476969,367854,225416,511249,511250,78750,142720,159433,182027,383564,330305,330306,420713,438275,438277,256423,220935,220936,511251,511252)
-
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-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-00298K
Model: DMC-ZS100K
Condition: New-In-Box
-
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-00360
Model: DC-GH5M2BODY
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-00201
Model: DC-FZ1000M2
Condition: New-In-Box
-
SKU: PAN-00184
Model: DC-S5M2XBODY
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-00184K
Model: DC-S5M2XKK
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-00175
Model: DMC-LX10K
Condition: New-In-Box
-
SKU: PAN-00950
Model: DC-G9KBODY
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00299S
Model: DC-ZS200DS
Condition: New-In-Box
-
SKU: PAN-00952
Model: DC-G9LK
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00360LK
Model: DC-GH5M2LK
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00183
Model: DC-S5BODY
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-00183K
Model: DC-S5KK
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-00953
Model: DMC-G9MK
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00450
Model: DC-GH6BODY
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00451
Model: DC-GH6LK
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00984
Model: DC-S1HBODY
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-00980
Model: DC-S1BODY
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-00981
Model: DC-S1MK
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-00189
Model: DC-S5M2BODY
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-00189K
Model: DC-S5M2KK
Condition: New-In-Box
Mount Type: L Mount
