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 (6147, 6150, 149246, 10888, 10889, 10890, 10891, 12251, 4178, 4179, 4180, 4183, 4184, 6142, 6143, 6144, 6145, 6148, 6149, 217661, 158983, 175186, 71159, 15652, 16759, 14619, 20837, 106608, 116555, 77953)) 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,6147,6150,149246,10888,10889,10890,10891,12251,4178,4179,4180,4183,4184,6142,6143,6144,6145,6148,6149,217661,158983,175186,71159,15652,16759,14619,20837,106608,116555,77953)
-
SKU: SMV-401342
Model: 401342
Condition: New-In-Box
-
SKU: SMV-402049
Model: 402049
Condition: New-In-Box
-
SKU: SMV-401610
Model: 401610
Condition: New-In-Box
-
SKU: SMV-401019
Model: 401019
Condition: New-In-Box
-
SKU: SMV-408085
Model: 408085
Condition: New-In-Box
-
SKU: SMV-401140
Model: 401140
Condition: New-In-Box
-
SKU: SMV-401983
Model: 401983
Condition: New-In-Box
-
SKU: SMV-401301
Model: 401301
Condition: New-In-Box
-
SKU: SMV-401402
Model: 401402A
Condition: New-In-Box
-
SKU: SMV-401430
Model: 401430
Condition: New-In-Box
-
SKU: SMV-401431
Model: 401431
Condition: New-In-Box
-
SKU: SMV-401313
Model: 401313
Condition: New-In-Box
-
SKU: SMV-401309
Model: 401309
Condition: New-In-Box
-
SKU: SMV-401222
Model: 401222
Condition: New-In-Box
-
SKU: SMV-401436
Model: 401436
Condition: New-In-Box
-
SKU: SMV-401432
Model: 401432
Condition: New-In-Box
-
SKU: SMV-401433
Model: 401433
Condition: New-In-Box
-
SKU: SMV-401310
Model: 401310
Condition: New-In-Box
-
SKU: SMV-401343
Model: 401343
Condition: New-In-Box
-
SKU: SMV-401825
Model: 401825
Condition: New-In-Box
-
SKU: SMV-401602
Model: 401602
Condition: New-In-Box
-
SKU: SMV-401648
Model: 401648
Condition: New-In-Box
-
SKU: SMV-401434
Model: 401434
Condition: New-In-Box
-
SKU: SMV-401440
Model: 401440
Condition: New-In-Box
-
SKU: SMV-690001
Model: 690001
Condition: New-In-Box
-
SKU: SMV-700103
Model: 700103
Condition: New-In-Box
-
SKU: SMV-401400
Model: 401400
Condition: New-In-Box
-
SKU: SMV-401613
Model: 401613
Condition: New-In-Box
-
SKU: SMV-401608
Model: 401608
Condition: New-In-Box
-
SKU: SMV-401600
Model: 401600
Condition: New-In-Box