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 (560825, 557414, 550147, 550144, 550140, 462211, 462213, 338071, 520274, 258119, 258139, 449105, 419775, 495920, 520275, 247279, 267601, 282592, 218287, 76124, 76126, 143427, 188208, 188209, 188210, 188211, 190110)) 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,560825,557414,550147,550144,550140,462211,462213,338071,520274,258119,258139,449105,419775,495920,520275,247279,267601,282592,218287,76124,76126,143427,188208,188209,188210,188211,190110)
-
SKU: CAN-16262
Model: 6052C022
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16260
Model: 6052C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16261
Model: 6052C012
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-30292
Model: 4507C017
Condition: New-In-Box
-
SKU: CAN-15202
Model: 5803C037
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)
-
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-15200
Model: 5803C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-10264
Model: 3616C002
Condition: New-In-Box
Mount Types: Canon EOS (EF), Canon EOS (EF-S)
-
SKU: CAN-10266
Model: 3616C016
Condition: New-In-Box
Mount Types: Canon EOS (EF), Canon EOS (EF-S)
-
SKU: CAN-10966
Model: 5638C001
Condition: New-In-Box
-
SKU: CAN-30291
Model: 4507C015
Condition: New-In-Box
-
SKU: CAN-15142
Model: 5137C055
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-112612S
Model: 3638C001
Condition: New-In-Box
-
SKU: CAN-11261K3
Model: 3637C026
Condition: New-In-Box
-
SKU: CAN-10429
Model: 3829C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-30137C
Model: 3667C002
Condition: New-In-Box
-
SKU: CAN-10347
Model: 1483C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-10349
Model: 1483C010
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-10347B
Model: 1483C082
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-30313
Model: 2215C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-30314
Model: 2215C017
Condition: New-In-Box
Mount Type: Arri PL
-
SKU: CAN-30315
Model: 2244C002
Condition: New-In-Box
-
SKU: CAN-30316
Model: 22116C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-30310
Model: 0202C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)