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, 17611, 18078, 19748, 19749, 23319, 25264, 25265, 33232, 37626, 37629, 42640, 93596, 197186, 197187, 197188, 197189, 197191, 197504, 200378, 226014, 121778, 134641, 100437)) 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,17611,18078,19748,19749,23319,25264,25265,33232,37626,37629,42640,93596,197186,197187,197188,197189,197191,197504,200378,226014,121778,134641,100437)
-
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-12128
Model: 9518B002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12885
Model: 9528B001
Condition: New-In-Box
-
SKU: CAN-43170
Model: 8657B004
Condition: New-In-Box
-
SKU: CAN-43176
Model: 8657B007
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
-
SKU: CAN-20943
Model: 1892B001
Condition: New-In-Box
-
SKU: CAN-40210A
Model: 0608C002
Condition: New-In-Box
-
SKU: CAN-20021
Model: 1425C002
Condition: New-In-Box
-
SKU: CAN-17000
Model: 2965C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17020
Model: 2959C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17010
Model: 2963C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17030
Model: 2973C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17050
Model: 3447C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17552
Model: 3443C002AA
Condition: New-In-Box
-
SKU: CAN-11632
Model: 3071C001
Condition: New-In-Box
-
SKU: CAN-10141T72
Model: 2727C021
Condition: New-In-Box
Mount Types: Canon EOS (EF), Canon EOS (EF-S)
-
SKU: CAN-20185
Model: 2130C001
Condition: New-In-Box
-
SKU: CAN-31070
Model: 0868C002
Condition: New-In-Box
-
SKU: CAN-43291
Model: 8657B016
Condition: New-In-Box