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 (376152, 382260, 390094, 391634, 454095, 462211, 462213, 462214, 462216, 462238, 462239, 462588, 472586, 472588, 472593, 484716, 332293, 338071, 338220, 339562, 341577, 345134, 345135, 345136, 345265, 350269, 351292, 360644, 404377, 404378)) 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,376152,382260,390094,391634,454095,462211,462213,462214,462216,462238,462239,462588,472586,472588,472593,484716,332293,338071,338220,339562,341577,345134,345135,345136,345265,350269,351292,360644,404377,404378)
-
SKU: CAN-15110
Model: 4895C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-13353
Model: 5743B012
Condition: New-In-Box
-
SKU: CAN-16951
Model: 4857C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-12940
Model: 2966C001
Condition: New-In-Box
-
SKU: CAN-21155
Model: 0749C001
Condition: New-In-Box
-
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-15161
Model: 5331C016
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-15160
Model: 5331C002
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-15162
Model: 5331C009
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
-
SKU: CAN-20629
Model: 0250C001
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-17506
Model: 4757C001
Condition: New-In-Box
-
SKU: CAN-20937
Model: 3224C001
Condition: New-In-Box
-
SKU: CAN-21139
Model: 4307C002AA
Condition: New-In-Box
-
SKU: CAN-17022
Model: 4515C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-40205
Model: 4280C002
Condition: New-In-Box
-
SKU: CAN-17047
Model: 4318C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-42147CPK
Model: 4215C007
Condition: New-In-Box
-
SKU: CAN-17500
Model: 2971C002
Condition: New-In-Box
-
SKU: CAN-12721
Model: 4518C001
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-42327FS
Model: 0545C006
Condition: New-In-Box
-
SKU: CAN-20703
Model: 4896C001
Condition: New-In-Box
-
SKU: CAN-20704
Model: 4897C001
Condition: New-In-Box