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 (10992, 10996, 11937, 11995, 3511, 3512, 3625, 3627, 3633, 2065, 2067, 2069, 2070, 364373, 10993, 10995, 10997, 10998, 10999, 11000, 11001, 11003, 11004, 11005, 11006, 11007, 11008, 11009, 11010, 11011)) 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,10992,10996,11937,11995,3511,3512,3625,3627,3633,2065,2067,2069,2070,364373,10993,10995,10997,10998,10999,11000,11001,11003,11004,11005,11006,11007,11008,11009,11010,11011)
-
SKU: INK-14214
Model: PCL81050
Condition: New-In-Box
-
SKU: INK-14250
Model: PCL10100
Condition: New-In-Box
-
SKU: INK-12810
Model: ITF851120
Condition: New-In-Box
-
SKU: INK-16466
Model: PP6044100
Condition: New-In-Box
-
SKU: INK-14220
Model: PCL111420
Condition: New-In-Box
-
SKU: INK-14222
Model: PCL111450
Condition: New-In-Box
-
SKU: INK-14232
Model: PCL131920
Condition: New-In-Box
-
SKU: INK-14238
Model: PCL172220
Condition: New-In-Box
-
SKU: INK-16820
Model: PP80851150
Condition: New-In-Box
-
SKU: INK-14210
Model: PCL46100
Condition: New-In-Box
-
SKU: INK-14216
Model: PCL851150
Condition: New-In-Box
-
SKU: INK-14228
Model: PCL111750
Condition: New-In-Box
-
SKU: INK-14810
Model: PCUG46100
Condition: New-In-Box
-
SKU: INK-PG5750
Model: PG5750
Condition: New-In-Box
-
SKU: INK-14224
Model: PCL1114100
Condition: New-In-Box
-
SKU: INK-14236
Model: PCL1319100
Condition: New-In-Box
-
SKU: INK-14254
Model: PCL17100
Condition: New-In-Box
-
SKU: INK-14258
Model: PCL24100
Condition: New-In-Box
-
SKU: INK-14260
Model: PCL36100
Condition: New-In-Box
-
SKU: INK-14262
Model: PCL44100
Condition: New-In-Box
-
SKU: INK-14264
Model: PCL60100
Condition: New-In-Box
-
SKU: INK-14814
Model: PCUG81050
Condition: New-In-Box
-
SKU: INK-14824
Model: PCUG1114100
Condition: New-In-Box
-
SKU: INK-14834
Model: PCUG1117100
Condition: New-In-Box
-
SKU: INK-14844
Model: PCUG1319100
Condition: New-In-Box
-
SKU: INK-14860
Model: PCUG17100
Condition: New-In-Box
-
SKU: INK-14864
Model: PCUG24100
Condition: New-In-Box
-
SKU: INK-14868
Model: PCUG36100
Condition: New-In-Box
-
SKU: INK-14872
Model: PCUG44100
Condition: New-In-Box
-
SKU: INK-14876
Model: PCUG60100
Condition: New-In-Box