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, 46525, 46527, 46842, 46843, 46844, 46845, 46944, 46959, 46960, 48060, 48061, 48062, 48063, 48065, 48340, 48341, 48342, 48343, 48344, 59259, 59260)) 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,46525,46527,46842,46843,46844,46845,46944,46959,46960,48060,48061,48062,48063,48065,48340,48341,48342,48343,48344,59259,59260)
-
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: CAN-12829
Model: 0579C001
Condition: New-In-Box
-
SKU: CAN-12844B
Model: 5186B001
Condition: New-In-Box
-
SKU: CAN-42202C
Model: 6514B001
Condition: New-In-Box
-
SKU: CAN-42202G
Model: 6517B001
Condition: New-In-Box
-
SKU: CAN-42202M
Model: 6515B001
Condition: New-In-Box
-
SKU: CAN-42202N
Model: 6513B001
Condition: New-In-Box
-
SKU: CAN-42202Y
Model: 6516B001
Condition: New-In-Box
-
SKU: CAN-42327A
Model: 0555C002
Condition: New-In-Box
-
SKU: CAN-42327C
Model: 0547C002
Condition: New-In-Box
-
SKU: CAN-42327CO
Model: 0547C002
Condition: New-In-Box
-
SKU: CAN-42327G
Model: 0552C002
Condition: New-In-Box
-
SKU: CAN-42327M
Model: 0548C002
Condition: New-In-Box
-
SKU: CAN-42327MB
Model: 0545C002
Condition: New-In-Box
-
SKU: CAN-42327PB
Model: 0546C002
Condition: New-In-Box
-
SKU: CAN-42327PC
Model: 0550C002
Condition: New-In-Box
-
SKU: CAN-42327PG
Model: 0553C002
Condition: New-In-Box
-
SKU: CAN-42327PM
Model: 0551C002
Condition: New-In-Box
-
SKU: CAN-42327R
Model: 0554C002
Condition: New-In-Box
-
SKU: CAN-42327Y
Model: 0554C002
Condition: New-In-Box
-
SKU: CAN-21153
Model: 1169C002
Condition: New-In-Box
-
SKU: CAN-21057
Model: 1170C002
Condition: New-In-Box
