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 (14992, 11837, 11840, 6814, 7832, 4791, 4794, 4795, 4796, 4799, 4803, 2661, 2662, 2666, 2667, 2669, 2670, 2671, 2672, 9166, 9167, 9168, 9169, 22420, 22424, 31763, 31764, 31765, 31794, 31795)) 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,14992,11837,11840,6814,7832,4791,4794,4795,4796,4799,4803,2661,2662,2666,2667,2669,2670,2671,2672,9166,9167,9168,9169,22420,22424,31763,31764,31765,31794,31795)
-
SKU: MAC-01325
Model: 1325
Condition: New-In-Box
-
SKU: MAC-01321
Model: 1321
Condition: New-In-Box
-
SKU: MAC-01065
Model: 1065
Condition: New-In-Box
-
SKU: MAC-01086
Model: 1086
Condition: New-In-Box
-
SKU: MAC-01323
Model: 1323
Condition: New-In-Box
-
SKU: MAC-01010
Model: 1010
Condition: New-In-Box
-
SKU: MAC-01015
Model: 1015
Condition: New-In-Box
-
SKU: MAC-01017
Model: 1017
Condition: New-In-Box
-
SKU: MAC-01011
Model: 1011
Condition: New-In-Box
-
SKU: MAC-01056
Model: 1056
Condition: New-In-Box
-
SKU: MAC-01822
Model: 1822
Condition: New-In-Box
-
SKU: MAC-01012
Model: 1012
Condition: New-In-Box
-
SKU: MAC-01029
Model: 1029
Condition: New-In-Box
-
SKU: MAC-01021
Model: 1021
Condition: New-In-Box
-
SKU: MAC-01023
Model: 1023
Condition: New-In-Box
-
SKU: MAC-01307
Model: 1307
Condition: New-In-Box
-
SKU: MAC-01309
Model: 1309
Condition: New-In-Box
-
SKU: MAC-01311
Model: 1311
Condition: New-In-Box
-
SKU: MAC-01319
Model: 1319
Condition: New-In-Box
-
SKU: MAC-01605
Model: 1605
Condition: New-In-Box
-
SKU: MAC-01607
Model: 1607
Condition: New-In-Box
-
SKU: MAC-01609
Model: 1609
Condition: New-In-Box
-
SKU: MAC-01615
Model: 1615
Condition: New-In-Box
-
SKU: MAC-01016
Model: 1016
Condition: New-In-Box
-
SKU: MAC-01824
Model: 1824
Condition: New-In-Box
-
SKU: MAC-01093
Model: 1093
Condition: New-In-Box
-
SKU: MAC-01058
Model: 1058
Condition: New-In-Box
-
SKU: MAC-01018
Model: 1018
Condition: New-In-Box
-
SKU: MAC-01327
Model: 1327
Condition: New-In-Box
-
SKU: MAC-01331
Model: 1331
Condition: New-In-Box