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 (76145, 17611, 33232, 226014, 13114, 7991, 258119, 258139, 76124, 76126, 76137, 77086, 18956, 20116, 23319, 98388, 197498, 197499, 143427, 161824, 181210, 181211, 121789, 121790, 131390, 131391, 131392, 188208, 188211, 188272)) 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,76145,17611,33232,226014,13114,7991,258119,258139,76124,76126,76137,77086,18956,20116,23319,98388,197498,197499,143427,161824,181210,181211,121789,121790,131390,131391,131392,188208,188211,188272)
-
SKU: CAN-12127
Model: 0573C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12128
Model: 9518B002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12192A
Model: 9523B002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-10141T72
Model: 2727C021
Condition: New-In-Box
Mount Types: Canon EOS (EF), Canon EOS (EF-S)
-
SKU: CAN-12169
Model: 5175B002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12244
Model: 3554B002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-10264
Model: 3616C002
Condition: New-In-Box
Mount Types: Canon EOS (EF), Canon EOS (EF-S)
-
SKU: CAN-10266
Model: 3616C016
Condition: New-In-Box
Mount Types: Canon EOS (EF), Canon EOS (EF-S)
-
SKU: CAN-10347
Model: 1483C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-10349
Model: 1483C010
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12175
Model: 1380C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12109
Model: 0570C010AA
Condition: New-In-Box
Mount Types: Canon EOS (EF), Canon EOS (EF-S)
-
SKU: CAN-12249
Model: 9524B002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12112
Model: 9520B002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12201
Model: 0570C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12225
Model: 0571C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12290
Model: 3329C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12276
Model: 3045C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-10347B
Model: 1483C082
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-10141T7
Model: 2727C002
Condition: New-In-Box
Mount Types: Canon EOS (EF), Canon EOS (EF-S)
-
SKU: CAN-12219
Model: 3044C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12223
Model: 2309C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-10324
Model: 1897C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-10325
Model: 1897C009
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12235
Model: 2271C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12295
Model: 2273C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12296M
Model: 2274C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-30313
Model: 2215C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-30316
Model: 22116C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12310
Model: 8325B001
Condition: New-In-Box
Mount Type: Canon EOS (EF)