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 (613775, 602923, 602922, 602833, 602666, 577920, 577919, 577918, 577917, 577868, 15174, 7614, 7769, 5499, 383565, 384440, 460126, 463933, 476969, 331050, 345329, 367492, 367493, 367499, 367854, 416881, 508820, 511249, 511250, 223792)) 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,613775,602923,602922,602833,602666,577920,577919,577918,577917,577868,15174,7614,7769,5499,383565,384440,460126,463933,476969,331050,345329,367492,367493,367499,367854,416881,508820,511249,511250,223792)
-
SKU: PRE-PAN-20060
Model: S-R28200
Condition: Preorder
Mount Type: L Mount
-
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-00398
Model: DMW-SHGR2
Condition: New-In-Box
-
SKU: PAN-20153
Model: S-E100
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-00349
Model: DMW-BG1
Condition: New-In-Box
-
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-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-00357L
Model: DMW-BLF19
Condition: New-In-Box
-
SKU: PAN-00359
Model: DMW-BMB9
Condition: New-In-Box
-
SKU: PAN-00355
Model: DMW-BLC12
Condition: New-In-Box
-
SKU: PAN-00325
Model: H-F007014
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-20071
Model: S-S50
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-00452
Model: H-X09
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-02103
Model: HC-V785K
Condition: New-In-Box
-
SKU: PAN-00905
Model: DC-G95DMK
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-003611
Model: DMW-BLK22
Condition: New-In-Box
-
SKU: PAN-20098
Model: S-S85
Condition: New-In-Box
Mount Type: L Mount
-
SKU: RDIS-BATT 44
Model: CR-2L
Condition: New-In-Box
-
SKU: RDIS-BATT 42
Model: 2CR-5L
Condition: New-In-Box
-
SKU: RDIS-BATT 41
Model: CR-P2L
Condition: New-In-Box
-
SKU: PAN-003221
Model: DC-G100KK
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-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-00352M
Model: DMW-BLJ31
Condition: New-In-Box
