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 (589938, 585167, 76145, 23319, 17611, 13114, 8041, 390094, 472586, 345134, 404384, 258148, 258174, 267623, 197186, 197188, 197189, 498693, 520293, 520295, 540285, 76137, 16309, 131390, 18487, 7993, 8010, 8018, 8019, 8023)) 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,589938,585167,76145,23319,17611,13114,8041,390094,472586,345134,404384,258148,258174,267623,197186,197188,197189,498693,520293,520295,540285,76137,16309,131390,18487,7993,8010,8018,8019,8023)
-
SKU: PRE-CAN-17009
Model: 6347C002
Condition: Preorder
Mount Type: Canon EOS (RF)
-
SKU: CAN-16850
Model: 6182C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-12127
Model: 0573C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12201
Model: 0570C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12128
Model: 9518B002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12169
Model: 5175B002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12230
Model: 6473A003
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-16951
Model: 4857C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16990
Model: 5668C002AA
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17022
Model: 4515C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16955
Model: 5051C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16950
Model: 3682C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17004
Model: 3680C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17045
Model: 3792C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17000
Model: 2965C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17010
Model: 2963C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17030
Model: 2973C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17016
Model: 5776C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17017
Model: 5823C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17018
Model: 5824C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: PRE-CAN-17156
Model: 6055C002
Condition: Preorder
Mount Type: Canon EOS (RF)
-
SKU: CAN-12175
Model: 1380C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12157
Model: 2545A003AA
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12235
Model: 2271C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12166
Model: 9522B002
Condition: New-In-Box
Mount Type: Canon EOS (EF-S)
-
SKU: CAN-12106
Model: 4427B002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12198
Model: 2515A003
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12232
Model: 6472A002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12236
Model: 2519A003
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12298
Model: 3553B002
Condition: New-In-Box
Mount Type: Canon EOS (EF)