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 (589939, 578317, 578316, 578312, 578311, 578310, 578309, 578308, 550220, 7991, 375882, 345136, 247280, 291272, 321690, 33232, 462238, 8011, 8033, 8036, 375878, 375880, 197498, 197499, 188272, 188273, 188274, 188275, 188276, 188277)) 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,589939,578317,578316,578312,578311,578310,578309,578308,550220,7991,375882,345136,247280,291272,321690,33232,462238,8011,8033,8036,375878,375880,197498,197499,188272,188273,188274,188275,188276,188277)
-
SKU: CAN-16846
Model: 6262C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
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-17130
Model: 4514C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17047
Model: 4318C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17015
Model: 3684C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17012
Model: 4111C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17150
Model: 4112C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-12192A
Model: 9523B002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-16900
Model: 4858C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-12288
Model: 2534A002
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-17190
Model: 5053C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17256
Model: 5054C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
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-12310
Model: 8325B001
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12311
Model: 1714C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12312
Model: 6569B001
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12314
Model: 9139B001
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12316
Model: 6570B001
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-12316C
Model: 2568C002
Condition: New-In-Box
Mount Type: Canon EOS (EF)