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, 546792, 462214, 462216, 462588, 484716, 495927, 498695, 498806, 498808, 520279, 520281, 520284, 200378, 449074, 449079, 449092, 449096, 449098, 484717, 343196, 520287, 520289, 249948, 249949, 305289, 197184, 205385, 224759, 232008)) 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,546792,462214,462216,462588,484716,495927,498695,498806,498808,520279,520281,520284,200378,449074,449079,449092,449096,449098,484717,343196,520287,520289,249948,249949,305289,197184,205385,224759,232008)
-
[Black, Silver]
SKU: CAN-V10
Model: 5946C002, 5947C002
Condition: New-In-Box
-
SKU: CAN-16255
Model: 5811C059
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-15162
Model: 5331C009
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-30137H
Model: 5734C002
Condition: New-In-Box
-
SKU: CAN-15163
Model: 5331C079
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-16250
Model: 5811C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16251
Model: 5811C012
Condition: New-In-Box
-
SKU: CAN-16252
Model: 5811C022
Condition: New-In-Box
-
SKU: CAN-11632
Model: 3071C001
Condition: New-In-Box
-
SKU: CAN-10960
Model: 5157C001
Condition: New-In-Box
-
SKU: CAN-10961
Model: 4839C001
Condition: New-In-Box
-
SKU: CAN-10962
Model: 5424C002AA
Condition: New-In-Box
-
SKU: CAN-10963
Model: 5157C002
Condition: New-In-Box
-
SKU: CAN-10964
Model: 4839C002
Condition: New-In-Box
-
SKU: CAN-30218P
Model: 5733C002
Condition: New-In-Box
-
[Black, Silver]
SKU: CAN-SL3
Model: 3453C001, 3453C002, 3457C001
Condition: New-In-Box
Mount Types: Canon EOS (EF), Canon EOS (EF-S)
-
SKU: CAN-16253
Model: 5812C002
Condition: New-In-Box
-
SKU: CAN-16254
Model: 5812C012
Condition: New-In-Box
-
SKU: CAN-30218K
Model: 3666C002
Condition: New-In-Box
-
SKU: CAN-30218M
Model: 3668C002
Condition: New-In-Box
-
SKU: CAN-15105
Model: 3380C132
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-15000
Model: 3075C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-30249
Model: 3041C002
Condition: New-In-Box
-
SKU: CAN-15100
Model: 3380C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-30137D
Model: 3670C002
Condition: New-In-Box