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 (603179, 589940, 589939, 589938, 585167, 557414, 7991, 375882, 376152, 390094, 462211, 462213, 462238, 462239, 472586, 472588, 472593, 484716, 338071, 345136, 404385, 498693, 498695, 498806, 498808, 520274, 520275, 520293, 520295, 247280)) 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,603179,589940,589939,589938,585167,557414,7991,375882,376152,390094,462211,462213,462238,462239,472586,472588,472593,484716,338071,345136,404385,498693,498695,498806,498808,520274,520275,520293,520295,247280)
-
[Black, Silver]
SKU: CAN-V10
Model: 5946C002, 5947C002
Condition: New-In-Box
-
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: CAN-15202
Model: 5803C037
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-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-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-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-16990
Model: 5668C002AA
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-11295
Model: 4825C015
Condition: New-In-Box
-
SKU: CAN-30137H
Model: 5734C002
Condition: New-In-Box
-
Canon
EOS C70
Special Price
USD $4,999.00
After USD $500.00 Savings
SKU: CAN-30290
Model: 4507C002
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-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)
-
SKU: CAN-15200
Model: 5803C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-15201
Model: 5803C012
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17017
Model: 5823C002
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-17015
Model: 3684C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
