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 (578316, 578311, 578310, 578309, 578308, 560819, 557414, 550220, 550147, 550144, 550140, 546792, 371661, 375882, 376152, 390094, 462211, 462213, 462216, 462238, 462239, 462588, 472586, 345134, 345136, 350269, 351292, 404384, 404385, 432969)) 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,578316,578311,578310,578309,578308,560819,557414,550220,550147,550144,550140,546792,371661,375882,376152,390094,462211,462213,462216,462238,462239,462588,472586,345134,345136,350269,351292,404384,404385,432969)
-
SKU: CAN-12337
Model: 6403C001
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-15202
Model: 5803C037
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-12916
Model: 2964C001
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-15110
Model: 4895C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16951
Model: 4857C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-15140
Model: 5137C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-15141
Model: 5137C009
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-16900
Model: 4858C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16902
Model: 5564C002
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-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-17047
Model: 4318C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17500
Model: 2971C002
Condition: New-In-Box
-
SKU: CAN-12721
Model: 4518C001
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-17152
Model: 5050C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-15123
Model: 5077C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)