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 (360334, 401921, 258308, 217655, 218730, 218731, 228273, 533728, 533785, 533790, 16429, 83451, 101563, 102939, 102940, 114460, 119613, 119614, 119732, 120740, 120741, 120743, 120744, 368927, 381932, 385177, 396115, 349632, 353728, 360336)) 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,360334,401921,258308,217655,218730,218731,228273,533728,533785,533790,16429,83451,101563,102939,102940,114460,119613,119614,119732,120740,120741,120743,120744,368927,381932,385177,396115,349632,353728,360336)
-
SKU: PTX-PH82727
Model: PH82727
Condition: New-In-Box
-
SKU: PTX-PH80364
Model: PH80364
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-PH88216
Model: PH88216
Condition: New-In-Box
-
SKU: PTX-PH81300
Model: PH81300
Condition: New-In-Box
-
SKU: PTX-PH81492
Model: PH81492
Condition: New-In-Box
-
SKU: PTX-PH15653
Model: PH15653
Condition: New-In-Box
-
SKU: PTX-PH01200
Model: PH01200
Condition: New-In-Box
-
SKU: PTX-PH00330
Model: PH00330
Condition: New-In-Box
-
SKU: PTX-PH82618
Model: PH82618
Condition: New-In-Box
-
SKU: PTX-PH82619
Model: PH82619
Condition: New-In-Box
-
SKU: PTX-PH18300
Model: PH18300
Condition: New-In-Box
-
SKU: PTX-PH15656
Model: PH15656
Condition: New-In-Box
-
SKU: PTX-PH15657
Model: PH15657
Condition: New-In-Box
-
SKU: PTX-PH80361
Model: PH80361
Condition: New-In-Box
-
SKU: PTX-PH82480
Model: PH82480
Condition: New-In-Box
-
SKU: PTX-PH82481
Model: PH82481
Condition: New-In-Box
-
SKU: PTX-PH82590
Model: PH82590
Condition: New-In-Box
-
SKU: PTX-PH82591
Model: PH82591
Condition: New-In-Box
-
SKU: PTX-PH89553
Model: PH89553
Condition: New-In-Box
-
SKU: PTX-PH82729
Model: PH82729
Condition: New-In-Box
-
SKU: PTX-PH83431
Model: PH83431
Condition: New-In-Box
-
SKU: PTX-PH81438
Model: PH81438
Condition: New-In-Box
-
SKU: PTX-PH85360
Model: PH85360
Condition: New-In-Box
-
SKU: PTX-PH99930
Model: PH99930
Condition: New-In-Box
-
SKU: PTX-PH82584
Model: PH82584
Condition: New-In-Box