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, 550220, 7991, 33232, 375880, 375882, 472586, 345134, 404384, 498693, 321689, 321691, 321692, 197187, 197189, 197191, 8010, 8011, 8019, 8023, 8033, 8036, 8038, 8050)) 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,550220,7991,33232,375880,375882,472586,345134,404384,498693,321689,321691,321692,197187,197189,197191,8010,8011,8019,8023,8033,8036,8038,8050)
-
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-16991
Model: 6128C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-12244
Model: 3554B002
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-17256
Model: 5054C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17130
Model: 4514C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16990
Model: 5668C002AA
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
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-17016
Model: 5776C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17052
Model: 4234C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17250
Model: 3986C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17300
Model: 3987C002
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-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-12198
Model: 2515A003
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12288
Model: 2534A002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12236
Model: 2519A003
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12298
Model: 3553B002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12274
Model: 2533A002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12284
Model: 2532A002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12196
Model: 1257B002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12302
Model: 3552B002
Condition: New-In-Box
Mount Types: Canon EOS (EF), Canon EOS (EF-S)