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 (550147, 550144, 550140, 549875, 547080, 546792, 546779, 546777, 546775, 540285, 6810, 7991, 8526, 8527, 8528, 8529, 8530, 8531, 8608, 9820, 9852, 9884, 9973, 9974, 9975, 9979, 9980, 9981, 9982, 9990)) 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,550147,550144,550140,549875,547080,546792,546779,546777,546775,540285,6810,7991,8526,8527,8528,8529,8530,8531,8608,9820,9852,9884,9973,9974,9975,9979,9980,9981,9982,9990)
-
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-13332
Model: 6104C001
Condition: New-In-Box
-
SKU: CAN-31435
Model: 4474C001
Condition: New-In-Box
-
SKU: CAN-16255
Model: 5811C059
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-17158
Model: 6102C001
Condition: New-In-Box
-
SKU: CAN-17157
Model: 6103C001
Condition: New-In-Box
-
SKU: CAN-15164
Model: 4474C006
Condition: New-In-Box
-
SKU: PRE-CAN-17156
Model: 6055C002
Condition: Preorder
Mount Type: Canon EOS (RF)
-
SKU: CAN-12771
Model: 3565B001
Condition: New-In-Box
-
SKU: CAN-12244
Model: 3554B002
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: CAN-42412
Model: 4530B001
Condition: New-In-Box
-
SKU: CAN-42180
Model: 4546B001
Condition: New-In-Box
-
SKU: CAN-42181
Model: 4547B001
Condition: New-In-Box
-
SKU: CAN-42182
Model: 4548B001
Condition: New-In-Box
-
SKU: CAN-42183
Model: 4549B001
Condition: New-In-Box
-
SKU: CAN-42184
Model: 4550B001
Condition: New-In-Box
-
SKU: CAN-21148
Model: 5108B002
Condition: New-In-Box
-
SKU: CAN-12794
Model: 3531B001
Condition: New-In-Box
-
SKU: CAN-20944
Model: 9370A001
Condition: New-In-Box
-
SKU: CAN-21306
Model: 4524B001
Condition: New-In-Box
-
SKU: CAN-42110
Model: 0620B002
Condition: New-In-Box
-
SKU: CAN-42111
Model: 0621B002
Condition: New-In-Box
-
SKU: CAN-42112
Model: 0627B002
Condition: New-In-Box
-
SKU: CAN-42114
Model: 0624B002
Condition: New-In-Box
-
SKU: CAN-42115
Model: 0625B002
Condition: New-In-Box
-
SKU: CAN-42116
Model: 0626B002
Condition: New-In-Box
-
SKU: CAN-42117
Model: 0623B002
Condition: New-In-Box
-
SKU: CAN-43638
Model: 3115B001
Condition: New-In-Box