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 (5536, 5538, 5539, 5541, 5542, 5543, 5544, 5545, 5547, 5548, 5550, 5552, 5553, 452807, 462423, 424304, 495228, 260454, 280095, 288530, 291973, 214413, 220243, 230814, 230815, 230816, 230817, 230818, 54472, 54473)) 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,5536,5538,5539,5541,5542,5543,5544,5545,5547,5548,5550,5552,5553,452807,462423,424304,495228,260454,280095,288530,291973,214413,220243,230814,230815,230816,230817,230818,54472,54473)
-
SKU: PEL-00037
Model: 1526
Condition: New-In-Box
-
SKU: PEL-00041
Model: PC1551
Condition: New-In-Box
-
SKU: PEL-00045E
Model: PC1560B
Condition: New-In-Box
-
SKU: PEL-00047
Model: PC1600B
Condition: New-In-Box
-
SKU: PEL-00049
Model: PC1601
Condition: New-In-Box
-
SKU: PEL-00050
Model: PC1602
Condition: New-In-Box
-
SKU: PEL-00051
Model: PC1604B
Condition: New-In-Box
-
SKU: PEL-00053C
Model: PC1614B
Condition: New-In-Box
-
SKU: PEL-00054A
Model: PC1624B
Condition: New-In-Box
-
SKU: PEL-00054H
Model: PC1630B
Condition: New-In-Box
-
SKU: PEL-00058
Model: 1655
Condition: New-In-Box
-
SKU: PEL-00059A
Model: 1651
Condition: New-In-Box
-
SKU: PEL-00059C
Model: 1665
Condition: New-In-Box
-
SKU: PEL-IM2950
Model: IM2950-00000
Condition: New-In-Box
-
SKU: PEL-00080
Model: VCV800-0000-BLK
Condition: New-In-Box
-
SKU: PEL-PCVCV300PDB
Model: VCV300-0040-BLK
Condition: New-In-Box
-
SKU: PEL-00054P
Model: 016460-0000-110
Condition: New-In-Box
-
SKU: PEL-00055B
Model: 016500-0050-110
Condition: New-In-Box
-
SKU: PEL-PC1730B
Model: PC1730B
Condition: New-In-Box
-
SKU: PEL-PC1607B
Model: PC1607B
Condition: New-In-Box
-
SKU: PEL-PC1607AIRDS
Model: PC1607AIRDS
Condition: New-In-Box
-
SKU: PEL-01200
Model: 016500-0040-110
Condition: New-In-Box
-
SKU: PEL-02101
Model: IM2275
Condition: New-In-Box
-
SKU: PEL-PCVCV100B
Model: PCVCV100B
Condition: New-In-Box
-
SKU: PEL-PCVCV200B
Model: PCVCV200B
Condition: New-In-Box
-
SKU: PEL-PCVCV300B
Model: PCVCV300B
Condition: New-In-Box
-
SKU: PEL-PCVCV550B
Model: PCVCV550B
Condition: New-In-Box
-
SKU: PEL-PCVCV600B
Model: PCVCV600B
Condition: New-In-Box
-
SKU: PEL-00000O
Model: PC1120FO
Condition: New-In-Box
-
SKU: PEL-000202
Model: PC1472
Condition: New-In-Box