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 (17047, 17224, 12440, 12500, 12510, 12511, 12585, 12586, 12587, 12588, 12589, 12590, 12591, 12592, 12593, 12594, 12595, 12597, 13114, 13672, 13816, 9820, 9852, 9884, 9973, 9974, 9975, 9979, 9980, 9981)) 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,17047,17224,12440,12500,12510,12511,12585,12586,12587,12588,12589,12590,12591,12592,12593,12594,12595,12597,13114,13672,13816,9820,9852,9884,9973,9974,9975,9979,9980,9981)
-
SKU: CAN-12738
Model: 1693B001
Condition: New-In-Box
-
SKU: CAN-21169
Model: 8724B001
Condition: New-In-Box
-
SKU: CAN-21174
Model: 5668B001
Condition: New-In-Box
-
SKU: CAN-43126B
Model: 1686B062
Condition: New-In-Box
-
SKU: CAN-42385
Model: 4879B009
Condition: New-In-Box
-
SKU: CAN-42384
Model: 4868B007
Condition: New-In-Box
-
SKU: CAN-42371
Model: 4868B002
Condition: New-In-Box
-
SKU: CAN-42372
Model: 4869B002
Condition: New-In-Box
-
SKU: CAN-42373
Model: 4870B002
Condition: New-In-Box
-
SKU: CAN-42374
Model: 4871B002
Condition: New-In-Box
-
SKU: CAN-42375
Model: 4872B002
Condition: New-In-Box
-
SKU: CAN-42376
Model: 4873B002
Condition: New-In-Box
-
SKU: CAN-42377
Model: 4874B002
Condition: New-In-Box
-
SKU: CAN-42378
Model: 4875B002
Condition: New-In-Box
-
SKU: CAN-42379
Model: 4876B002
Condition: New-In-Box
-
SKU: CAN-42380
Model: 4877B002
Condition: New-In-Box
-
SKU: CAN-42381
Model: 4878B002
Condition: New-In-Box
-
SKU: CAN-42382
Model: 4879B002
Condition: New-In-Box
-
SKU: CAN-12169
Model: 5175B002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-21041
Model: 5752B002
Condition: New-In-Box
-
SKU: CAN-21050
Model: 5109B001
Condition: New-In-Box
-
SKU: CAN-12794
Model: 3531B001
Condition: New-In-Box
-
SKU: CAN-20944
Model: 9370A001
Condition: New-In-Box
-
SKU: CAN-21306
Model: 4524B001
Condition: New-In-Box
-
SKU: CAN-42110
Model: 0620B002
Condition: New-In-Box
-
SKU: CAN-42111
Model: 0621B002
Condition: New-In-Box
-
SKU: CAN-42112
Model: 0627B002
Condition: New-In-Box
-
SKU: CAN-42114
Model: 0624B002
Condition: New-In-Box
-
SKU: CAN-42115
Model: 0625B002
Condition: New-In-Box
-
SKU: CAN-42116
Model: 0626B002
Condition: New-In-Box