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 (189545, 189837, 182290, 182291, 189820, 189821, 189822, 189823, 189824, 189825, 189826, 189827, 189828, 189829, 189830, 189831, 189832, 189833, 189834, 189835, 189836, 189838, 189839, 189840, 189841, 189842, 189843, 6638)) 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,189545,189837,182290,182291,189820,189821,189822,189823,189824,189825,189826,189827,189828,189829,189830,189831,189832,189833,189834,189835,189836,189838,189839,189840,189841,189842,189843,6638)
-
SKU: WEI-990120
Model: W990120
Condition: New-In-Box
-
SKU: WEI-990124
Model: W990124
Condition: New-In-Box
-
SKU: WEI-990120-12
Model: W990120
Condition: New-In-Box
-
SKU: WEI-990124-12
Model: W990124
Condition: New-In-Box
-
SKU: WEI-918110
Model: W918110
Condition: New-In-Box
-
SKU: WEI-918111
Model: W918111
Condition: New-In-Box
-
SKU: WEI-918200
Model: W918200
Condition: New-In-Box
-
SKU: WEI-920200
Model: W920200
Condition: New-In-Box
-
SKU: WEI-928110
Model: W928110
Condition: New-In-Box
-
SKU: WEI-928120
Model: W928120
Condition: New-In-Box
-
SKU: WEI-930010
Model: W930010
Condition: New-In-Box
-
SKU: WEI-930020
Model: W930020
Condition: New-In-Box
-
SKU: WEI-930025
Model: W930025
Condition: New-In-Box
-
SKU: WEI-940020
Model: W940020
Condition: New-In-Box
-
SKU: WEI-940030
Model: W940030
Condition: New-In-Box
-
SKU: WEI-940040
Model: W940040
Condition: New-In-Box
-
SKU: WEI-940050
Model: W940050
Condition: New-In-Box
-
SKU: WEI-940070
Model: W940070
Condition: New-In-Box
-
SKU: WEI-970100
Model: W970100
Condition: New-In-Box
-
SKU: WEI-990122
Model: W990122
Condition: New-In-Box
-
SKU: WEI-990122-12
Model: W990122
Condition: New-In-Box
-
SKU: WEI-990200
Model: W990200
Condition: New-In-Box
-
SKU: WEI-990315
Model: W990315
Condition: New-In-Box
-
SKU: WEI-990320
Model: W990320
Condition: New-In-Box
-
SKU: WEI-990400
Model: W990400
Condition: New-In-Box
-
SKU: WEI-990510
Model: W990510
Condition: New-In-Box
-
SKU: WEI-990560
Model: W990560
Condition: New-In-Box
-
SKU: WEI-940001
Model: W940001
Condition: New-In-Box