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 (50480, 50496, 50515, 50529, 77930, 77932, 77934, 77935, 77937, 101565, 113588, 114461, 114493, 114494, 114495, 119509, 119510, 119511, 120747, 131000, 131001, 173350, 173351, 381932, 392247, 392254, 396116, 397642, 401921, 447666)) 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,50480,50496,50515,50529,77930,77932,77934,77935,77937,101565,113588,114461,114493,114494,114495,119509,119510,119511,120747,131000,131001,173350,173351,381932,392247,392254,396116,397642,401921,447666)
-
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
-
SKU: PTX-PH87198
Model: PH87198
Condition: New-In-Box
-
SKU: PTX-PH87199
Model: PH87199
Condition: New-In-Box
-
SKU: PTX-PH87200
Model: PH87200
Condition: New-In-Box
-
SKU: PTX-PH82751
Model: PH82751
Condition: New-In-Box
-
SKU: PTX-PH85341
Model: PH85341
Condition: New-In-Box
-
SKU: PTX-PH85361
Model: PH85361
Condition: New-In-Box
-
SKU: PTX-PH82720
Model: PH82720
Condition: New-In-Box
-
SKU: PTX-PH82721
Model: PH82721
Condition: New-In-Box
-
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-PH87224
Model: PH87224
Condition: New-In-Box