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 (578317, 578316, 578312, 578311, 578310, 578309, 578308, 560819, 550220, 550147, 550144, 550140, 546792, 13114, 345134, 404384, 432969, 258119, 258139, 197186, 197187, 197191, 226014, 76145, 33232, 462214, 462216, 462588, 495927, 520279)) 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,578317,578316,578312,578311,578310,578309,578308,560819,550220,550147,550144,550140,546792,13114,345134,404384,432969,258119,258139,197186,197187,197191,226014,76145,33232,462214,462216,462588,495927,520279)
-
SKU: CAN-12338
Model: 6404C001
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-12337
Model: 6403C001
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-12336
Model: 6402C001
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-12335
Model: 6401C001
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-12334
Model: 6400C001
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-12333
Model: 6399C001
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-12332
Model: 6398C001
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-15125
Model: 5077C024
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16991
Model: 6128C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16262
Model: 6052C022
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16260
Model: 6052C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16261
Model: 6052C012
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16255
Model: 5811C059
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-12169
Model: 5175B002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-17022
Model: 4515C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16955
Model: 5051C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-15123
Model: 5077C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
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-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-17050
Model: 3447C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-10141T72
Model: 2727C021
Condition: New-In-Box
Mount Types: Canon EOS (EF), Canon EOS (EF-S)
-
SKU: CAN-12127
Model: 0573C002
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-15161
Model: 5331C016
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-15160
Model: 5331C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-15162
Model: 5331C009
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-15163
Model: 5331C079
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16250
Model: 5811C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)