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 (113588, 114461, 114493, 114494, 114495, 119509, 119510, 119511, 173350, 173351, 385177, 396115, 349632, 353728, 360336, 362032, 367638, 368927, 436010, 436367, 436371, 436372, 533725, 498687, 512039, 512040, 512041, 512042, 512043, 512044)) 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,113588,114461,114493,114494,114495,119509,119510,119511,173350,173351,385177,396115,349632,353728,360336,362032,367638,368927,436010,436367,436371,436372,533725,498687,512039,512040,512041,512042,512043,512044)
-
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-PH82720
Model: PH82720
Condition: New-In-Box
-
SKU: PTX-PH82721
Model: PH82721
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
-
SKU: PTX-PH82725
Model: PH82725
Condition: New-In-Box
-
SKU: PTX-PH82325
Model: PH82325
Condition: New-In-Box
-
SKU: PTX-PH89553
Model: PH89553
Condition: New-In-Box
-
SKU: PTX-PH81418
Model: PH81418
Condition: New-In-Box
-
SKU: PTX-PH81453
Model: PH81453
Condition: New-In-Box
-
SKU: PTX-PH88194
Model: PH88194
Condition: New-In-Box
-
SKU: PTX-PH88195
Model: PH88195
Condition: New-In-Box
-
SKU: PTX-PH88213
Model: PH88213
Condition: New-In-Box
-
SKU: PTX-PH82585
Model: PH82585
Condition: New-In-Box
-
SKU: PTX-PH83720
Model: PH83720
Condition: New-In-Box
-
SKU: PTX-PH83721
Model: PH83721
Condition: New-In-Box
-
SKU: PTX-PH83722
Model: PH83722
Condition: New-In-Box
-
SKU: PTX-PH83723
Model: PH83723
Condition: New-In-Box
-
SKU: PTX-PH83724
Model: PH83724
Condition: New-In-Box
-
SKU: PTX-PH83725
Model: PH83725
Condition: New-In-Box