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 (557414, 550147, 550144, 550140, 546792, 462214, 462216, 462588, 520274, 520275, 520279, 520281, 520284, 495927, 498695, 498806, 498808, 258119, 258139, 226014, 200378, 15363, 15364, 15365, 15378, 15445, 15446, 15447, 15530, 15531)) 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,557414,550147,550144,550140,546792,462214,462216,462588,520274,520275,520279,520281,520284,495927,498695,498806,498808,258119,258139,226014,200378,15363,15364,15365,15378,15445,15446,15447,15530,15531)
-
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-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-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-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-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-10141T72
Model: 2727C021
Condition: New-In-Box
Mount Types: Canon EOS (EF), Canon EOS (EF-S)
-
SKU: CAN-11632
Model: 3071C001
Condition: New-In-Box
-
SKU: CAN-11017R
Model: 8197B001
Condition: New-In-Box
-
SKU: CAN-11017G
Model: 8191B001
Condition: New-In-Box
-
SKU: CAN-11017S
Model: 8194B001
Condition: New-In-Box
-
SKU: CAN-30136
Model: 8063B002
Condition: New-In-Box
-
SKU: CAN-11029N
Model: 8206B001
Condition: New-In-Box
-
SKU: CAN-11029S
Model: 8203B001
Condition: New-In-Box
-
SKU: CAN-11029P
Model: 8212B001
Condition: New-In-Box
-
SKU: CAN-11016L
Model: 8605B001
Condition: New-In-Box
-
SKU: CAN-11016S
Model: 8602B001
Condition: New-In-Box