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 (200647, 200648, 200649, 200650, 200651, 200652, 200653, 200995, 200998, 203037, 203038, 203039, 203040, 203041, 203042, 203043, 203044, 203045, 203049, 203050, 203051, 203052, 203053, 203054, 203055, 203056, 203057, 203058, 217656, 217657)) 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,200647,200648,200649,200650,200651,200652,200653,200995,200998,203037,203038,203039,203040,203041,203042,203043,203044,203045,203049,203050,203051,203052,203053,203054,203055,203056,203057,203058,217656,217657)
-
SKU: TAM-T11404343
Model: T11404343
Condition: New-In-Box
-
SKU: TAM-T11405252
Model: T1140-5252
Condition: New-In-Box
-
SKU: TAM-T11408585
Model: T1140-8585
Condition: New-In-Box
-
SKU: TAM-T11504343
Model: T1150-4343
Condition: New-In-Box
-
SKU: TAM-T11505252
Model: T1150-5252
Condition: New-In-Box
-
SKU: TAM-T11554343
Model: T1155-4343
Condition: New-In-Box
-
SKU: TAM-T11555252
Model: T1155-5252
Condition: New-In-Box
-
SKU: TAM-T11604343
Model: T1160-4343
Condition: New-In-Box
-
SKU: TAM-T11605252
Model: T1160-5252
Condition: New-In-Box
-
SKU: TAM-T03201919
Model: T0320-1919
Condition: New-In-Box
-
SKU: TAM-T03251919
Model: T0325-1919
Condition: New-In-Box
-
SKU: TAM-T03301919
Model: T0330-1919
Condition: New-In-Box
-
SKU: TAM-T03351919
Model: T0335-1919
Condition: New-In-Box
-
SKU: TAM-T03401919
Model: T0340-1919
Condition: New-In-Box
-
SKU: TAM-T03451919
Model: T0345-1919
Condition: New-In-Box
-
SKU: TAM-T03501919
Model: T0350-1919
Condition: New-In-Box
-
SKU: TAM-T03551919
Model: T0355-1919
Condition: New-In-Box
-
SKU: TAM-T03601919
Model: T0360-1919
Condition: New-In-Box
-
SKU: TAM-T11854343
Model: T1185-4343
Condition: New-In-Box
-
SKU: TAM-T11855252
Model: T1185-5252
Condition: New-In-Box
-
SKU: TAM-T11858585
Model: T1185-8585
Condition: New-In-Box
-
SKU: TAM-T12004515
Model: T1200-4515
Condition: New-In-Box
-
SKU: TAM-T12005515
Model: T1200-5515
Condition: New-In-Box
-
SKU: TAM-T12008715
Model: T1200-8715
Condition: New-In-Box
-
SKU: TAM-T12104515
Model: T1210-4515
Condition: New-In-Box
-
SKU: TAM-T12105515
Model: T1210-5515
Condition: New-In-Box
-
SKU: TAM-T12108715
Model: T1210-8715
Condition: New-In-Box
-
SKU: TAM-T14601313
Model: T1460-1313
Condition: New-In-Box
-
SKU: TAM-T06301919
Model: T0630-1919
Condition: New-In-Box
-
SKU: TAM-T11508585
Model: T1150-8585
Condition: New-In-Box