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, 602666, 577919, 577918, 577917, 577868, 383565, 384440, 345329, 142719, 45782, 29364, 95930, 416881, 460126, 508820, 511249, 511250, 383564, 391361, 401894, 330305, 330306, 365454, 270013, 270014, 309985, 241354, 256423, 256443)) 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,602666,577919,577918,577917,577868,383565,384440,345329,142719,45782,29364,95930,416881,460126,508820,511249,511250,383564,391361,401894,330305,330306,365454,270013,270014,309985,241354,256423,256443)
-
SKU: PRE-PAN-20060
Model: S-R28200
Condition: Preorder
Mount Type: L Mount
-
SKU: PAN-20153
Model: S-E100
Condition: New-In-Box
Mount Type: L Mount
-
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-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-20098
Model: S-S85
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-00341
Model: H-ES200
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00339
Model: H-RS100400
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00155
Model: DMC-FZ300K
Condition: New-In-Box
-
SKU: PAN-00336
Model: H-FSA100300
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-00452
Model: H-X09
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
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-00360LK
Model: DC-GH5M2LK
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00400
Model: H-X2550
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: PAN-00161
Model: S-S24
Condition: New-In-Box
Mount Type: L Mount
-
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-20091A
Model: S-R70300
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-20030
Model: S-R1635
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-20088
Model: S-E70200
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-20035
Model: S-R2060
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-00325B1025
Model: H-X1025
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-20040
Model: S-E2470
Condition: New-In-Box
Mount Type: L Mount