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 (12066, 12081, 5528, 5531, 5535, 5546, 5551, 3368, 3376, 3383, 3384, 9312, 54475, 62159, 20510, 11109, 12041, 12044, 12046, 12065, 12068, 12070, 12072, 12074, 12076, 12082, 12083, 12084, 12088, 12089)) 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,12066,12081,5528,5531,5535,5546,5551,3368,3376,3383,3384,9312,54475,62159,20510,11109,12041,12044,12046,12065,12068,12070,12072,12074,12076,12082,12083,12084,12088,12089)
-
SKU: PEL-00054D
Model: PC1621
Condition: New-In-Box
-
SKU: PEL-00059E
Model: PC1669
Condition: New-In-Box
-
SKU: PEL-00013
Model: PC1401
Condition: New-In-Box
-
SKU: PEL-00033A
Model: PC1510B
Condition: New-In-Box
-
SKU: PEL-00036E
Model: PC1525
Condition: New-In-Box
-
SKU: PEL-00053E
Model: PC1615
Condition: New-In-Box
-
SKU: PEL-00059
Model: 1660
Condition: New-In-Box
-
SKU: PEL-00009
Model: 1301
Condition: New-In-Box
-
SKU: PEL-00035A
Model: PC1521
Condition: New-In-Box
-
SKU: PEL-00055
Model: PC1650B
Condition: New-In-Box
-
SKU: PEL-00056
Model: PC1651
Condition: New-In-Box
-
SKU: PEL-00053J
Model: PC1612
Condition: New-In-Box
-
SKU: PEL-00053B
Model: PC1609
Condition: New-In-Box
-
SKU: PEL-01485NFB
Model: PC1485NFB
Condition: New-In-Box
-
SKU: PEL-00046
Model: PC1569
Condition: New-In-Box
-
SKU: PEL-00002E
Model: PC1075B
Condition: New-In-Box
-
SKU: PEL-00060E
Model: PC1751
Condition: New-In-Box
-
SKU: PEL-00002
Model: PC1010SB
Condition: New-In-Box
-
SKU: PEL-00011OR
Model: PC1400O
Condition: New-In-Box
-
SKU: PEL-00057A
Model: PC1659
Condition: New-In-Box
-
SKU: PEL-00033B
Model: PC1511
Condition: New-In-Box
-
SKU: PEL-00028
Model: PC1506TSA
Condition: New-In-Box
-
SKU: PEL-00068
Model: PC2220
Condition: New-In-Box
-
SKU: PEL-00020A
Model: PC1490CC1
Condition: New-In-Box
-
SKU: PEL-00020C
Model: PC1495B
Condition: New-In-Box
-
SKU: PEL-00059H
Model: PC1690B
Condition: New-In-Box
-
SKU: PEL-00059M
Model: PC1699
Condition: New-In-Box
-
SKU: PEL-00015C
Model: PC1450O
Condition: New-In-Box
-
SKU: PEL-00014
Model: PC1430NFB
Condition: New-In-Box
-
SKU: PEL-00014A
Model: PC1439
Condition: New-In-Box