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 (200629, 200630, 200631, 200632, 200633, 200634, 200635, 200636, 200637, 200638, 200639, 200640, 200641, 200642, 200643, 200644, 200645, 200646, 200647, 200648, 200649, 200650, 200651, 200652, 200653, 200995, 200998)) 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,200629,200630,200631,200632,200633,200634,200635,200636,200637,200638,200639,200640,200641,200642,200643,200644,200645,200646,200647,200648,200649,200650,200651,200652,200653,200995,200998)
-
SKU: TAM-T11104343
Model: T1110-4343
Condition: New-In-Box
-
SKU: TAM-T11105252
Model: T1110-5252
Condition: New-In-Box
-
SKU: TAM-T11108585
Model: T1110-8585
Condition: New-In-Box
-
SKU: TAM-T11154343
Model: T1115-4343
Condition: New-In-Box
-
SKU: TAM-T11155252
Model: T1115-5252
Condition: New-In-Box
-
SKU: TAM-T11158585
Model: T1115-8585
Condition: New-In-Box
-
SKU: TAM-T11204343
Model: T1120-4343
Condition: New-In-Box
-
SKU: TAM-T11205252
Model: T1120-5252
Condition: New-In-Box
-
SKU: TAM-T11208585
Model: T1120-8585
Condition: New-In-Box
-
SKU: TAM-T11254343
Model: T1125-4343
Condition: New-In-Box
-
SKU: TAM-T11255252
Model: T1125-5252
Condition: New-In-Box
-
SKU: TAM-T11258585
Model: T1125-8585
Condition: New-In-Box
-
SKU: TAM-T11304343
Model: T1130-4343
Condition: New-In-Box
-
SKU: TAM-T11305252
Model: T1130-5252
Condition: New-In-Box
-
SKU: TAM-T11308585
Model: T1130-8585
Condition: New-In-Box
-
SKU: TAM-T11354343
Model: T1135-4343
Condition: New-In-Box
-
SKU: TAM-T11355252
Model: T1135-5252
Condition: New-In-Box
-
SKU: TAM-T11358585
Model: T1135-8585
Condition: New-In-Box
-
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