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, 384440, 345329, 416881, 511249, 511250, 401894, 484674, 330305, 330306, 365454, 511251, 511252, 512109, 256423, 256443, 270013, 270014, 309985, 220935, 220936, 220937, 220938, 220939, 220940, 220941)) 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,384440,345329,416881,511249,511250,401894,484674,330305,330306,365454,511251,511252,512109,256423,256443,270013,270014,309985,220935,220936,220937,220938,220939,220940,220941)
-
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-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-00550
Model: S-S35
Condition: New-In-Box
Mount Type: L Mount
-
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-00161
Model: S-S24
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-20033
Model: S-S18
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-00189
Model: DC-S5M2BODY
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-00189K
Model: DC-S5M2KK
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-00161G
Model: S-R1428
Condition: New-In-Box
Mount Type: L Mount
-
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
-
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-00980
Model: DC-S1BODY
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-00981
Model: DC-S1MK
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-00982
Model: DC-S1RBODY
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-00983
Model: DC-S1RMK
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-20050
Model: S-R24105
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-20070
Model: S-X50
Condition: New-In-Box
Mount Type: L Mount
-
SKU: PAN-20090
Model: S-R70200
Condition: New-In-Box
Mount Type: L Mount