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 (15903, 15904, 15905, 15906, 15907, 15908, 15909, 15910, 15911, 15912, 15913, 15914, 15916, 16238, 16240, 16241, 16243, 16244, 16245, 16442, 16591, 16592, 16998, 17047, 17224, 23319, 25264, 25265, 33232, 37626)) 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,15903,15904,15905,15906,15907,15908,15909,15910,15911,15912,15913,15914,15916,16238,16240,16241,16243,16244,16245,16442,16591,16592,16998,17047,17224,23319,25264,25265,33232,37626)
-
SKU: CAN-42509
Model: 6411B002
Condition: New-In-Box
-
SKU: CAN-42510
Model: 6402B007
Condition: New-In-Box
-
SKU: CAN-42511
Model: 6411B007
Condition: New-In-Box
-
SKU: CAN-42512
Model: 6402B008
Condition: New-In-Box
-
SKU: CAN-42186
Model: 6384B002
Condition: New-In-Box
-
SKU: CAN-42187
Model: 6385B002
Condition: New-In-Box
-
SKU: CAN-42188
Model: 6386B002
Condition: New-In-Box
-
SKU: CAN-42189
Model: 6387B002
Condition: New-In-Box
-
SKU: CAN-42190
Model: 6388B002
Condition: New-In-Box
-
SKU: CAN-42191
Model: 6389B002
Condition: New-In-Box
-
SKU: CAN-42192
Model: 6390B002
Condition: New-In-Box
-
SKU: CAN-42193
Model: 6391B002
Condition: New-In-Box
-
SKU: CAN-42194
Model: 6384B007
Condition: New-In-Box
-
SKU: CAN-12853
Model: 5185B001
Condition: New-In-Box
-
SKU: CAN-12924
Model: 5181B001
Condition: New-In-Box
-
SKU: CAN-20290A
Model: 5673B001
Condition: New-In-Box
-
SKU: CAN-20294A
Model: 6555B001
Condition: New-In-Box
-
SKU: CAN-20300A
Model: 5672B001
Condition: New-In-Box
-
SKU: CAN-20298A
Model: 6318B001
Condition: New-In-Box
-
SKU: CAN-20178
Model: 8471B001
Condition: New-In-Box
-
SKU: CAN-31161
Model: 8597B002
Condition: New-In-Box
-
SKU: CAN-31165
Model: 8598B002
Condition: New-In-Box
-
SKU: CAN-12843
Model: 8268B001
Condition: New-In-Box
-
SKU: CAN-12738
Model: 1693B001
Condition: New-In-Box
-
SKU: CAN-21169
Model: 8724B001
Condition: New-In-Box
-
SKU: CAN-12201
Model: 0570C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-21152
Model: 9967B002
Condition: New-In-Box
-
SKU: CAN-21056
Model: 9968B001
Condition: New-In-Box
-
SKU: CAN-12192A
Model: 9523B002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12723
Model: 0575C001
Condition: New-In-Box