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 (381932, 392247, 392254, 396116, 397642, 401921, 342179, 360334, 258308, 217655, 218730, 218731, 228273, 173350, 173351, 50480, 50496, 50515, 50529, 77930, 77932, 77934, 77935, 77937, 101565, 113588, 114461, 114493, 114494, 114495)) 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,381932,392247,392254,396116,397642,401921,342179,360334,258308,217655,218730,218731,228273,173350,173351,50480,50496,50515,50529,77930,77932,77934,77935,77937,101565,113588,114461,114493,114494,114495)
-
SKU: PTX-PH82729
Model: PH82729
Condition: New-In-Box
-
SKU: PTX-PH82728
Model: PH82728
Condition: New-In-Box
-
SKU: PTX-PH82733
Model: PH82733
Condition: New-In-Box
-
SKU: PTX-PH81439
Model: PH81439
Condition: New-In-Box
-
SKU: PTX-PH82726
Model: PH82726
Condition: New-In-Box
-
SKU: PTX-PH80364
Model: PH80364
Condition: New-In-Box
-
SKU: PTX-PH82722
Model: PH82722
Condition: New-In-Box
-
SKU: PTX-PH82727
Model: PH82727
Condition: New-In-Box
-
SKU: PTX-PH92512
Model: PH92512
Condition: New-In-Box
-
SKU: PTX-PH89079
Model: PH89079
Condition: New-In-Box
-
SKU: PTX-PH82588
Model: PH82588
Condition: New-In-Box
-
SKU: PTX-PH82724
Model: PH82724
Condition: New-In-Box
-
SKU: PTX-PH88188
Model: PH88188
Condition: New-In-Box
-
SKU: PTX-PH82720
Model: PH82720
Condition: New-In-Box
-
SKU: PTX-PH82721
Model: PH82721
Condition: New-In-Box
-
SKU: PTX-PH89067
Model: PH89067
Condition: New-In-Box
-
SKU: PTX-PH89072
Model: PH89072
Condition: New-In-Box
-
SKU: PTX-PH89074
Model: PH89074
Condition: New-In-Box
-
SKU: PTX-PH89069
Model: PH89069
Condition: New-In-Box
-
SKU: PTX-PH86305
Model: PH86305
Condition: New-In-Box
-
SKU: PTX-PH86492
Model: PH86492
Condition: New-In-Box
-
SKU: PTX-PH86497
Model: PH86497
Condition: New-In-Box
-
SKU: PTX-PH86498
Model: PH86498
Condition: New-In-Box
-
SKU: PTX-PH88189
Model: PH88189
Condition: New-In-Box
-
SKU: PTX-PH87308
Model: PH87308
Condition: New-In-Box
-
SKU: PTX-PH82741
Model: PH82741
Condition: New-In-Box
-
SKU: PTX-PH88207
Model: PH88207
Condition: New-In-Box
-
SKU: PTX-PH88209
Model: PH88209
Condition: New-In-Box
-
SKU: PTX-PH88211
Model: PH88211
Condition: New-In-Box
-
SKU: PTX-PH88221
Model: PH88221
Condition: New-In-Box