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 (65278, 66707, 77889, 77890, 17818, 18267, 18761, 19378, 20464, 20465, 14370, 14371, 14372, 14657, 15172, 15173, 20865, 23665, 23666, 23668, 78750, 79635, 83034, 95927, 95936, 95937, 95975, 95976, 125093, 125094)) 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,65278,66707,77889,77890,17818,18267,18761,19378,20464,20465,14370,14371,14372,14657,15172,15173,20865,23665,23666,23668,78750,79635,83034,95927,95936,95937,95975,95976,125093,125094)
-
SKU: PAN-00326F
Model: H-X012
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00849CSK
Model: DMW-BCSK6
Condition: New-In-Box
-
SKU: PAN-00421
Model: DE-A79BR
Condition: New-In-Box
-
SKU: PAN-00423
Model: DE-A99B
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-00361
Model: VW-VBD58
Condition: New-In-Box
-
SKU: PAN-00520
Model: DMW-LFC46GU
Condition: New-In-Box
-
SKU: PAN-05102
Model: QE-AL102K
Condition: New-In-Box
-
SKU: PAN-05201
Model: QE-AL201K
Condition: New-In-Box
-
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-00405
Model: DMW-MS2
Condition: New-In-Box
-
SKU: PAN-00352G
Model: DMW-BGGH3
Condition: New-In-Box
-
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
-
SKU: PAN-00321TS
Model: DMC-G7KS
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00321TT
Model: DMC-G7HK
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-00422
Model: DE-A83BA
Condition: New-In-Box
-
SKU: PAN-00325CH1
Model: H-ES12060
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00852K
Model: DC-GX850K
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00852S
Model: DC-GX850S
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00352J
Model: DMW-BGGH5
Condition: New-In-Box
-
SKU: PAN-00409
Model: DMW-XLR1
Condition: New-In-Box
-
SKU: PAN-02002B
Model: AG-VBR89G
Condition: New-In-Box
-
SKU: PAN-02002C
Model: AG-BRD50P
Condition: New-In-Box