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 (9800, 889, 890, 891, 1639, 1640, 1641, 1642, 20509, 20522, 20523, 20524, 20525, 20526, 20527, 20528, 135933, 181981, 182262, 182263, 182264, 182265, 182266, 246162, 271922, 272610, 319568, 199100, 203735, 203736)) 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,9800,889,890,891,1639,1640,1641,1642,20509,20522,20523,20524,20525,20526,20527,20528,135933,181981,182262,182263,182264,182265,182266,246162,271922,272610,319568,199100,203735,203736)
-
SKU: CTG-50706
Model: 50706
Condition: New-In-Box
-
SKU: CTG-40060
Model: 40060
Condition: New-In-Box
-
SKU: CTG-40061
Model: 40061
Condition: New-In-Box
-
SKU: CTG-50705
Model: 50705
Condition: New-In-Box
-
SKU: CTG-40057
Model: 40057
Condition: New-In-Box
-
SKU: CTG-40058
Model: 40058
Condition: New-In-Box
-
SKU: CTG-40059
Model: 40059
Condition: New-In-Box
-
SKU: CTG-50703
Model: 50703
Condition: New-In-Box
-
SKU: CTG-27005
Model: 27005
Condition: New-In-Box
-
SKU: CTG-28102
Model: 28102
Condition: New-In-Box
-
SKU: CTG-28104
Model: 28104
Condition: New-In-Box
-
SKU: CTG-39978
Model: 39978
Condition: New-In-Box
-
SKU: CTG-40308
Model: 40308
Condition: New-In-Box
-
SKU: CTG-40317
Model: 40317
Condition: New-In-Box
-
SKU: CTG-52107
Model: 52107
Condition: New-In-Box
-
SKU: CTG-54176
Model: 54176
Condition: New-In-Box
-
SKU: CTG-40409
Model: 40409
Condition: New-In-Box
-
SKU: CTG-50614
Model: 50614
Condition: New-In-Box
-
SKU: CTG-27329
Model: 27329
Condition: New-In-Box
-
SKU: CTG-27364
Model: 27364
Condition: New-In-Box
-
SKU: CTG-27398
Model: 27398
Condition: New-In-Box
-
SKU: CTG-40033
Model: 40033
Condition: New-In-Box
-
SKU: CTG-40371
Model: 40371
Condition: New-In-Box
-
SKU: CTG-28103
Model: 28103
Condition: New-In-Box
-
SKU: CTG-50615
Model: 50615
Condition: New-In-Box
-
SKU: CTG-10362
Model: 10362
Condition: New-In-Box
-
SKU: CTG-22322
Model: 22322
Condition: New-In-Box
-
SKU: CTG-28868
Model: 28868
Condition: New-In-Box
-
SKU: CTG-50212
Model: 50212
Condition: New-In-Box
-
SKU: CTG-56783
Model: 56783
Condition: New-In-Box