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 (217656, 217657, 217658, 217659, 64783, 64792, 64793, 64795, 64801, 64809, 65049, 65058, 39163, 39198, 39429, 39463, 80176, 80178, 87779, 87781, 87782, 87783, 88132, 88133, 88134, 89270, 89271, 89272, 90804, 200614)) 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,217656,217657,217658,217659,64783,64792,64793,64795,64801,64809,65049,65058,39163,39198,39429,39463,80176,80178,87779,87781,87782,87783,88132,88133,88134,89270,89271,89272,90804,200614)
-
SKU: TAM-T06301919
Model: T0630-1919
Condition: New-In-Box
-
SKU: TAM-T11508585
Model: T1150-8585
Condition: New-In-Box
-
SKU: TAM-T11558585
Model: T1155-8585
Condition: New-In-Box
-
SKU: TAM-T11608585
Model: T1160-8585
Condition: New-In-Box
-
SKU: TAM-T01231519
Model: T0123-1519
Condition: New-In-Box
-
SKU: TAM-T11804343
Model: T1180-4343
Condition: New-In-Box
-
SKU: TAM-T11805252
Model: T1180-5252
Condition: New-In-Box
-
SKU: TAM-T11808585
Model: T1180-8585
Condition: New-In-Box
-
SKU: TAM-T14001313
Model: T1400-1313
Condition: New-In-Box
-
SKU: TAM-T14051313
Model: T1405-1313
Condition: New-In-Box
-
SKU: TAM-T14301313
Model: T1430-1313
Condition: New-In-Box
-
SKU: TAM-T14651313
Model: T1465-1313
Condition: New-In-Box
-
SKU: TAM-T0601-CP
Model: T0601-1919
Condition: New-In-Box
-
SKU: TAM-T0610-CP
Model: T0610-1919
Condition: New-In-Box
-
SKU: TAM-T0620-CP
Model: T0620-1919
Condition: New-In-Box
-
SKU: TAM-T0640-CP
Model: T0640-1919
Condition: New-In-Box
-
SKU: TAM-T14651919
Model: T1465-1919
Condition: New-In-Box
-
SKU: TAM-T14151919
Model: T1415-1919
Condition: New-In-Box
-
SKU: TAM-T15001519
Model: T15001519, T15004519
Condition: New-In-Box
-
SKU: TAM-T15101519
Model: T15101519
Condition: New-In-Box
-
SKU: TAM-T15104519
Model: T15104519
Condition: New-In-Box
-
SKU: TAM-T15501519
Model: T15501519
Condition: New-In-Box
-
SKU: TAM-T16007878
Model: T16007878
Condition: New-In-Box
-
SKU: TAM-T1605-7878
Model: T1605-7878
Condition: New-In-Box
-
SKU: TAM-T16107878
Model: T16107878
Condition: New-In-Box
-
SKU: TAM-T11001919
Model: T1100-1919
Condition: New-In-Box
-
SKU: TAM-T11051919
Model: T1105-1919
Condition: New-In-Box
-
SKU: TAM-T1116-1919
Model: T1116-1919
Condition: New-In-Box
-
SKU: TAM-T14101919
Model: T1410-1919
Condition: New-In-Box
-
SKU: TAM-T0210
Model: T0210-1919
Condition: New-In-Box