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 (149246, 6147, 6150, 20837, 16759, 77953, 83039, 87653, 87654, 87655, 87656, 87657, 87658, 87659, 87660, 91997, 71159, 106608, 116555, 158983, 175186, 14619, 15652, 10888, 10889, 10890, 10891, 12251, 6142, 6143)) 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,149246,6147,6150,20837,16759,77953,83039,87653,87654,87655,87656,87657,87658,87659,87660,91997,71159,106608,116555,158983,175186,14619,15652,10888,10889,10890,10891,12251,6142,6143)
-
SKU: SMV-401610
Model: 401610
Condition: New-In-Box
-
SKU: SMV-401342
Model: 401342
Condition: New-In-Box
-
SKU: SMV-402049
Model: 402049
Condition: New-In-Box
-
SKU: SMV-401400
Model: 401400
Condition: New-In-Box
-
SKU: SMV-690001
Model: 690001
Condition: New-In-Box
-
SKU: SMV-401600
Model: 401600
Condition: New-In-Box
-
SKU: SMV-401946
Model: 401946
Condition: New-In-Box
-
SKU: SMV-402085
Model: 402085
Condition: New-In-Box
-
SKU: SMV-402086
Model: 402086
Condition: New-In-Box
-
SKU: SMV-650021
Model: 650021
Condition: New-In-Box
-
SKU: SMV-650022
Model: 650022
Condition: New-In-Box
-
SKU: SMV-700500
Model: 700500
Condition: New-In-Box
-
SKU: SMV-700501
Model: 700501
Condition: New-In-Box
-
SKU: SMV-700502
Model: 700502
Condition: New-In-Box
-
SKU: SMV-700503
Model: 700503
Condition: New-In-Box
-
SKU: SMV-670147
Model: 670147
Condition: New-In-Box
-
SKU: SMV-401434
Model: 401434
Condition: New-In-Box
-
SKU: SMV-401613
Model: 401613
Condition: New-In-Box
-
SKU: SMV-401608
Model: 401608
Condition: New-In-Box
-
SKU: SMV-401602
Model: 401602
Condition: New-In-Box
-
SKU: SMV-401648
Model: 401648
Condition: New-In-Box
-
SKU: SMV-700103
Model: 700103
Condition: New-In-Box
-
SKU: SMV-401440
Model: 401440
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-401222
Model: 401222
Condition: New-In-Box
-
SKU: SMV-401436
Model: 401436
Condition: New-In-Box