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 (15913, 15914, 15916, 16238, 16240, 16241, 16243, 16244, 16245, 16442, 16591, 16592, 16998, 17047, 17224, 23388, 25264, 25265, 33232, 37626, 37629, 42640, 12440, 12500, 12510, 12511, 12585, 12586, 12587, 12588)) 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,15913,15914,15916,16238,16240,16241,16243,16244,16245,16442,16591,16592,16998,17047,17224,23388,25264,25265,33232,37626,37629,42640,12440,12500,12510,12511,12585,12586,12587,12588)
-
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-21177
Model: 9839B001
Condition: New-In-Box
-
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
-
SKU: CAN-20943
Model: 1892B001
Condition: New-In-Box
-
SKU: CAN-40210A
Model: 0608C002
Condition: New-In-Box
-
SKU: CAN-21174
Model: 5668B001
Condition: New-In-Box
-
SKU: CAN-43126B
Model: 1686B062
Condition: New-In-Box
-
SKU: CAN-42385
Model: 4879B009
Condition: New-In-Box
-
SKU: CAN-42384
Model: 4868B007
Condition: New-In-Box
-
SKU: CAN-42371
Model: 4868B002
Condition: New-In-Box
-
SKU: CAN-42372
Model: 4869B002
Condition: New-In-Box
-
SKU: CAN-42373
Model: 4870B002
Condition: New-In-Box
-
SKU: CAN-42374
Model: 4871B002
Condition: New-In-Box