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, 8041, 375880, 345136, 321690, 321691, 321692, 404385, 462239, 498693, 520295, 8011, 8018, 8019, 8033, 8036, 16015, 16732, 18956, 98388, 131390, 181210, 181211, 375878, 267624, 197498, 197499, 440641, 440644)) 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,8041,375880,345136,321690,321691,321692,404385,462239,498693,520295,8011,8018,8019,8033,8036,16015,16732,18956,98388,131390,181210,181211,375878,267624,197498,197499,440641,440644)
-
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-12230
Model: 6473A003
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-17256
Model: 5054C002
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-17150
Model: 4112C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17250
Model: 3986C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17300
Model: 3987C002
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-16902
Model: 5564C002
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-17018
Model: 5824C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-12288
Model: 2534A002
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-12274
Model: 2533A002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12284
Model: 2532A002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12265
Model: 5176B002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12208
Model: 8546B002
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-12235
Model: 2271C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
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-17190
Model: 5053C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17051
Model: 3450C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-12290
Model: 3329C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12276
Model: 3045C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-17600
Model: 5055C002AA
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17601
Model: 5056C002AA
Condition: New-In-Box
Mount Type: Canon EOS (RF)