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 (15651, 13876, 13877, 11457, 11458, 11462, 11463, 11466, 11468, 11470, 11472, 11477, 11478, 11479, 11480, 11481, 11482, 11483, 11486, 11487, 11493, 11494, 11498, 11501, 11502, 11503, 11550, 11551, 11555, 11557)) 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,15651,13876,13877,11457,11458,11462,11463,11466,11468,11470,11472,11477,11478,11479,11480,11481,11482,11483,11486,11487,11493,11494,11498,11501,11502,11503,11550,11551,11555,11557)
-
SKU: LOW-05150
Model: LCP-944LB
Condition: New-In-Box
-
SKU: LOW-04160
Model: GS
Condition: New-In-Box
-
SKU: LOW-04900
Model: LC
Condition: New-In-Box
-
SKU: LOW-07625
Model: VIP-61
Condition: New-In-Box
-
SKU: LOW-07620
Model: VIP-41
Condition: New-In-Box
-
SKU: LOW-07210
Model: T1-923LBZ
Condition: New-In-Box
-
SKU: LOW-07180
Model: T1-80
Condition: New-In-Box
-
SKU: LOW-07165
Model: T1-50
Condition: New-In-Box
-
SKU: LOW-07150
Model: T1-32
Condition: New-In-Box
-
SKU: LOW-07135
Model: T1-20
Condition: New-In-Box
-
SKU: LOW-07110
Model: T1-10
Condition: New-In-Box
-
SKU: LOW-05315
Model: ML-13
Condition: New-In-Box
-
SKU: LOW-06110
Model: Unavailable
Condition: New-In-Box
-
SKU: LOW-06115
Model: Unavailable
Condition: New-In-Box
-
SKU: LOW-06120
Model: O1-17
Condition: New-In-Box
-
SKU: LOW-06125
Model: Unavailable
Condition: New-In-Box
-
SKU: LOW-06130
Model: Unavailable
Condition: New-In-Box
-
SKU: LOW-06135
Model: O1-53
Condition: New-In-Box
-
SKU: LOW-06310
Model: P1-80
Condition: New-In-Box
-
SKU: LOW-06320
Model: P2-10
Condition: New-In-Box
-
SKU: LOW-04415
Model: IP-20
Condition: New-In-Box
-
SKU: LOW-04420
Model: IP-50H
Condition: New-In-Box
-
SKU: LOW-04440
Model: IP-56
Condition: New-In-Box
-
SKU: LOW-04620
Model: KPH
Condition: New-In-Box
-
SKU: LOW-02110
Model: D2-10
Condition: New-In-Box
-
SKU: LOW-04625
Model: KS Stand
Condition: New-In-Box
-
SKU: LOW-03310
Model: FLS-100
Condition: New-In-Box
-
SKU: LOW-03315
Model: FLS-120
Condition: New-In-Box
-
SKU: LOW-03345
Model: FLS-650DM
Condition: New-In-Box
-
SKU: LOW-03355
Model: FLS-843
Condition: New-In-Box