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 (9717, 9718, 9719, 10624, 45784, 51348, 61525, 61526, 64233, 64235, 64236, 64237, 65278, 66707, 15762, 16315, 16515, 16516, 17191, 17380, 17461, 20865, 23665, 23666, 23668, 77889, 77890, 78750, 79635, 83034)) 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,9717,9718,9719,10624,45784,51348,61525,61526,64233,64235,64236,64237,65278,66707,15762,16315,16515,16516,17191,17380,17461,20865,23665,23666,23668,77889,77890,78750,79635,83034)
-
SKU: PAN-00384
Model: DMW-LMCH62
Condition: New-In-Box
-
SKU: PAN-00410
Model: DMW-ZL1
Condition: New-In-Box
-
SKU: PAN-00404
Model: DMW-MS1
Condition: New-In-Box
-
SKU: PAN-00343
Model: DMW-AC8
Condition: New-In-Box
-
SKU: PAN-00298S
Model: DMC-ZS100S
Condition: New-In-Box
-
SKU: PAN-00325CH
Model: H-FS12060
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00055
Model: VW-VBT190
Condition: New-In-Box
-
SKU: PAN-02095
Model: HC-VX981K
Condition: New-In-Box
-
SKU: PAN-00325DA2
Model: H-FS1442AKA
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-00352B
Model: DMW-BCK7
Condition: New-In-Box
-
SKU: PAN-04010
Model: DMW-CGK33K
Condition: New-In-Box
-
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-02090
Model: HC-X920K
Condition: New-In-Box
-
SKU: PAN-00352D
Model: DMW-BCM13
Condition: New-In-Box
-
SKU: PAN-00327A
Model: H-H020AK
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00327B
Model: H-H020AS
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00408
Model: DMW-YAGH
Condition: New-In-Box
-
SKU: PAN-00370
Model: DMW-HGR1S
Condition: New-In-Box
-
SKU: PAN-02500
Model: HX-A500H
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-00421
Model: DE-A79B
Condition: New-In-Box
-
SKU: PAN-00423
Model: DE-A99B
Condition: New-In-Box
-
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