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 (226014, 472593, 9417, 15247, 15248, 15378, 15445, 15446, 15447, 218289, 45598, 45609, 17957, 17958, 20120, 20121, 20398, 17116, 17117, 17314, 17326, 17371, 17587, 17588, 37795, 37796, 12907, 12915, 12916, 12917)) 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,226014,472593,9417,15247,15248,15378,15445,15446,15447,218289,45598,45609,17957,17958,20120,20121,20398,17116,17117,17314,17326,17371,17587,17588,37795,37796,12907,12915,12916,12917)
-
SKU: CAN-10141T72
Model: 2727C021
Condition: New-In-Box
Mount Types: Canon EOS (EF), Canon EOS (EF-S)
-
SKU: CAN-11295
Model: 4825C015
Condition: New-In-Box
-
SKU: CAN-30164
Model: 5127B001
Condition: New-In-Box
-
SKU: CAN-11301
Model: 8231B020
Condition: New-In-Box
-
SKU: CAN-11300
Model: 8230B014
Condition: New-In-Box
-
SKU: CAN-30136
Model: 8063B002
Condition: New-In-Box
-
SKU: CAN-11029N
Model: 8206B001
Condition: New-In-Box
-
SKU: CAN-11029S
Model: 8203B001
Condition: New-In-Box
-
SKU: CAN-11029P
Model: 8212B001
Condition: New-In-Box
-
SKU: CAN-30181
Model: 3908C001
Condition: New-In-Box
-
SKU: CAN-30149X
Model: 1236C003
Condition: New-In-Box
-
SKU: CAN-11029US
Model: 1078C001
Condition: New-In-Box
-
SKU: CAN-11689N
Model: 9545B001
Condition: New-In-Box
-
SKU: CAN-11689R
Model: 9769B001
Condition: New-In-Box
-
SKU: CAN-11029TN
Model: 0154C001
Condition: New-In-Box
-
SKU: CAN-11029TS
Model: 0158C001
Condition: New-In-Box
-
SKU: CAN-30149V
Model: 0278C004
Condition: New-In-Box
-
SKU: CAN-11304N
Model: 9168B001
Condition: New-In-Box
-
SKU: CAN-11304W
Model: 9169B001
Condition: New-In-Box
-
SKU: CAN-11700N
Model: 9338B001
Condition: New-In-Box
-
SKU: CAN-11700R
Model: 9339B001
Condition: New-In-Box
-
SKU: CAN-30149S
Model: 9175B001
Condition: New-In-Box
-
SKU: CAN-30223
Model: 9593B002
Condition: New-In-Box
-
SKU: CAN-30224
Model: 9592B002
Condition: New-In-Box
-
SKU: CAN-11262N
Model: 0511C001
Condition: New-In-Box
-
SKU: CAN-11262S
Model: 0924C001
Condition: New-In-Box
-
SKU: CAN-30138G
Model: 6094B001
Condition: New-In-Box
-
SKU: CAN-11015B
Model: 642B001
Condition: New-In-Box
-
SKU: CAN-11015C
Model: 6045B001
Condition: New-In-Box
-
SKU: CAN-11015D
Model: 6051B001
Condition: New-In-Box