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 (589940, 589939, 589938, 585167, 540285, 17611, 76145, 13114, 390094, 462238, 462239, 472588, 345136, 404385, 247280, 258148, 258174, 267623, 321690, 197186, 197188, 520295, 17612, 18956, 98388, 101843, 181210, 181211, 188273, 188277)) 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,589940,589939,589938,585167,540285,17611,76145,13114,390094,462238,462239,472588,345136,404385,247280,258148,258174,267623,321690,197186,197188,520295,17612,18956,98388,101843,181210,181211,188273,188277)
-
SKU: PRE-CAN-17159
Model: 6263C002
Condition: Preorder
Mount Type: Canon EOS (RF)
-
SKU: CAN-16846
Model: 6262C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
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: PRE-CAN-17156
Model: 6055C002
Condition: Preorder
Mount Type: Canon EOS (RF)
-
SKU: CAN-12128
Model: 9518B002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12127
Model: 0573C002
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-16951
Model: 4857C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16900
Model: 4858C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16902
Model: 5564C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16945
Model: 5775C002AA
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17047
Model: 4318C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17152
Model: 5050C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17015
Model: 3684C002
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-17150
Model: 4112C002
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-17018
Model: 5824C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-12108
Model: 9519B002
Condition: New-In-Box
Mount Type: Canon EOS (EF-S)
-
SKU: CAN-12249
Model: 9524B002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12225
Model: 0571C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12147A
Model: 1620C002
Condition: New-In-Box
Mount Type: Canon EOS (EF-S)
-
SKU: CAN-12219
Model: 3044C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12223
Model: 2309C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12311
Model: 1714C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12316C
Model: 2568C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)