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, 476969, 367854, 225416, 45783, 29364, 79633, 124405, 14370, 14371, 14372, 13824, 8316, 8317, 366508, 256423, 257534, 61526, 17818, 18267, 15762, 23665, 78750, 79635, 129754, 159433)) 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,476969,367854,225416,45783,29364,79633,124405,14370,14371,14372,13824,8316,8317,366508,256423,257534,61526,17818,18267,15762,23665,78750,79635,129754,159433)
-
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-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-00298K
Model: DMC-ZS100K
Condition: New-In-Box
-
SKU: PAN-00155
Model: DMC-FZ300K
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-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-02080
Model: HC-X900MK
Condition: New-In-Box
-
SKU: PAN-00017B
Model: RP-SDN04GU1A
Condition: New-In-Box
-
SKU: PAN-00017
Model: RP-SDN08GU1A
Condition: New-In-Box
-
SKU: PAN-02096
Model: HC-VX1K
Condition: New-In-Box
-
SKU: PAN-00984
Model: DC-S1HBODY
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-00321KIT
Model: DMC-G7WK
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-02095
Model: HC-VX981K
Condition: New-In-Box
-
SKU: PAN-00024
Model: RP-SDUC64GAK
Condition: New-In-Box
-
SKU: PAN-02100
Model: HC-X1000K
Condition: New-In-Box
-
SKU: PAN-02090
Model: HC-X920K
Condition: New-In-Box
-
SKU: PAN-00321TN
Model: DMC-G7KK
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00175
Model: DMC-LX10K
Condition: New-In-Box
-
SKU: PAN-00902
Model: DMC-G85MK
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-02020
Model: HC-V180K
Condition: New-In-Box
-
SKU: PAN-00299S
Model: DC-ZS200DS
Condition: New-In-Box