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 (554121, 8840, 380751, 384019, 244439, 244440, 250964, 259462, 234823, 125415, 12966, 7775, 7778, 7780, 7782, 7784, 7785, 8443, 8444, 8449, 8450, 8839, 8842, 11449, 11452, 11866, 4494, 4495, 4590, 4592)) 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,554121,8840,380751,384019,244439,244440,250964,259462,234823,125415,12966,7775,7778,7780,7782,7784,7785,8443,8444,8449,8450,8839,8842,11449,11452,11866,4494,4495,4590,4592)
-
SKU: LWP-03185B
Model: LP37177-GRL
Condition: New-In-Box
-
SKU: LWP-02006J
Model: LP-36304-0AM
Condition: New-In-Box
-
SKU: LWP-01713A
Model: LP37350
Condition: New-In-Box
-
[Dark Gray, Black]
SKU: LWP-FLIPSIDE 400 AW III
Model: LP37353, LP37352
Condition: New-In-Box
-
SKU: LWP-LP37255
Model: LP37255
Condition: New-In-Box
-
SKU: LWP-LP37260
Model: LP37260
Condition: New-In-Box
-
SKU: LWP-05611
Model: LP37226
Condition: New-In-Box
-
SKU: LWP-LP37182
Model: LP37182
Condition: New-In-Box
-
SKU: LWP-LP37178
Model: LP37178
Condition: New-In-Box
-
SKU: LWP-01712
Model: LP37125
Condition: New-In-Box
-
SKU: LWP-01178A
Model: LP34998-0EU
Condition: New-In-Box
-
SKU: LWP-03546A
Model: LP36256-0AM
Condition: New-In-Box
-
SKU: LWP-03552A
Model: LP36259-0AM
Condition: New-In-Box
-
SKU: LWP-03556A
Model: LP36261-PAM
Condition: New-In-Box
-
SKU: LWP-03560A
Model: LP36277-0AM
Condition: New-In-Box
-
SKU: LWP-03568A
Model: LP36282-BAM
Condition: New-In-Box
-
SKU: LWP-03570A
Model: LP36283-0AM
Condition: New-In-Box
-
SKU: LWP-03544A
Model: LP36255-0AM
Condition: New-In-Box
-
SKU: LWP-03564A
Model: LP36279-0AM
Condition: New-In-Box
-
SKU: LWP-03576A
Model: LP36286-BAM
Condition: New-In-Box
-
SKU: LWP-03578A
Model: LP36287-BAM
Condition: New-In-Box
-
SKU: LWP-02006G
Model: LP-36303-0AM
Condition: New-In-Box
-
SKU: LWP-02006S
Model: LP36307
Condition: New-In-Box
-
SKU: LWP-01170B
Model: LP34994-0EU
Condition: New-In-Box
-
SKU: LWP-01480B
Model: LP20080-PEF
Condition: New-In-Box
-
SKU: LWP-02006P
Model: LP36306-PWW
Condition: New-In-Box
-
SKU: LWP-01160A
Model: LP34983-0EU
Condition: New-In-Box
-
SKU: LWP-01165A
Model: LP34992-0EU
Condition: New-In-Box
-
SKU: LWP-01910A
Model: 35233
Condition: New-In-Box
-
SKU: LWP-01915A
Model: 35236
Condition: New-In-Box