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 (59260, 60576, 61273, 67525, 76145, 76156, 76164, 15893, 15894, 15895, 15896, 15897, 15898, 15899, 15900, 15901, 15903, 15904, 15905, 15906, 15907, 15908, 15909, 15910, 15911, 15912, 15913, 15914, 15916, 16238)) 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,59260,60576,61273,67525,76145,76156,76164,15893,15894,15895,15896,15897,15898,15899,15900,15901,15903,15904,15905,15906,15907,15908,15909,15910,15911,15912,15913,15914,15916,16238)
-
SKU: CAN-21057
Model: 1170C002
Condition: New-In-Box
-
SKU: CAN-20481
Model: 1180C001
Condition: New-In-Box
-
SKU: CAN-12860
Model: 1277C001
Condition: New-In-Box
-
SKU: CAN-20368
Model: 9840B001
Condition: New-In-Box
-
SKU: CAN-12127
Model: 0573C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-20184
Model: 1485C001
Condition: New-In-Box
-
SKU: CAN-12925
Model: 0580C001
Condition: New-In-Box
-
SKU: CAN-42500
Model: 6402B002
Condition: New-In-Box
-
SKU: CAN-42501
Model: 6403B002
Condition: New-In-Box
-
SKU: CAN-42502
Model: 6404B002
Condition: New-In-Box
-
SKU: CAN-42503
Model: 6405B002
Condition: New-In-Box
-
SKU: CAN-42504
Model: 6406B002
Condition: New-In-Box
-
SKU: CAN-42505
Model: 6407B002
Condition: New-In-Box
-
SKU: CAN-42506
Model: 6408B002
Condition: New-In-Box
-
SKU: CAN-42507
Model: 6409B002
Condition: New-In-Box
-
SKU: CAN-42508
Model: 6410B002
Condition: New-In-Box
-
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