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 (560819, 557414, 550147, 550144, 550140, 546792, 376152, 462211, 462213, 462214, 462216, 462588, 432969, 495927, 498695, 498806, 498808, 520274, 520275, 520279, 520281, 520284, 291731, 321685, 433526, 495920, 520287, 520289, 305289, 224759)) 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,560819,557414,550147,550144,550140,546792,376152,462211,462213,462214,462216,462588,432969,495927,498695,498806,498808,520274,520275,520279,520281,520284,291731,321685,433526,495920,520287,520289,305289,224759)
-
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-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-15110
Model: 4895C002
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-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-15123
Model: 5077C002
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-15135
Model: 5666C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-15136
Model: 5666C018
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-15137
Model: 5666C011
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-15200
Model: 5803C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-15201
Model: 5803C012
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16250
Model: 5811C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16251
Model: 5811C012
Condition: New-In-Box
-
SKU: CAN-16252
Model: 5811C022
Condition: New-In-Box
-
SKU: CAN-15120
Model: 4147C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-15122
Model: 4147C013
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-15124
Model: 5077C010
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-15142
Model: 5137C055
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16253
Model: 5812C002
Condition: New-In-Box
-
SKU: CAN-16254
Model: 5812C012
Condition: New-In-Box
-
SKU: CAN-15105
Model: 3380C132
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-15100
Model: 3380C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)