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, 589938, 585167, 560819, 7991, 13114, 375882, 376152, 390094, 345136, 291731, 321685, 197186, 197187, 197188, 197191, 258119, 258139, 258148, 258174, 267623, 17611, 76145, 432969, 462211, 462213, 498693, 498695, 498806, 498808)) 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,589938,585167,560819,7991,13114,375882,376152,390094,345136,291731,321685,197186,197187,197188,197191,258119,258139,258148,258174,267623,17611,76145,432969,462211,462213,498693,498695,498806,498808)
-
SKU: PRE-CAN-17159
Model: 6263C002
Condition: Preorder
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: CAN-15125
Model: 5077C024
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-12244
Model: 3554B002
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-17130
Model: 4514C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-15110
Model: 4895C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16951
Model: 4857C002
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-15120
Model: 4147C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-15122
Model: 4147C013
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-17020
Model: 2959C002
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-17050
Model: 3447C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-10264
Model: 3616C002
Condition: New-In-Box
Mount Types: Canon EOS (EF), Canon EOS (EF-S)
-
SKU: CAN-10266
Model: 3616C016
Condition: New-In-Box
Mount Types: Canon EOS (EF), Canon EOS (EF-S)
-
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-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-15123
Model: 5077C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-15140
Model: 5137C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-15141
Model: 5137C009
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-15135
Model: 5666C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-15136
Model: 5666C018
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-15137
Model: 5666C011
Condition: New-In-Box
Mount Type: Canon EOS (RF)