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, 380751, 384019, 298156, 234823, 250964, 259462, 244439, 244440, 22319, 8840, 125415, 125418, 4494, 4495, 4590, 4592, 4595, 4613, 4614, 2570, 2614, 2623, 12966, 11449, 11452, 11866, 380767, 334513, 334514)) 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,380751,384019,298156,234823,250964,259462,244439,244440,22319,8840,125415,125418,4494,4495,4590,4592,4595,4613,4614,2570,2614,2623,12966,11449,11452,11866,380767,334513,334514)
-
SKU: LWP-03185B
Model: LP37177-GRL
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-LP37269
Model: LP37269
Condition: New-In-Box
-
SKU: LWP-LP37178
Model: LP37178
Condition: New-In-Box
-
SKU: LWP-05611
Model: LP37226
Condition: New-In-Box
-
SKU: LWP-LP37182
Model: LP37182
Condition: New-In-Box
-
SKU: LWP-LP37255
Model: LP37255
Condition: New-In-Box
-
SKU: LWP-LP37260
Model: LP37260
Condition: New-In-Box
-
SKU: LWP-01108
Model: LP36866
Condition: New-In-Box
-
SKU: LWP-02006J
Model: LP-36304-0AM
Condition: New-In-Box
-
SKU: LWP-01712
Model: LP37125
Condition: New-In-Box
-
SKU: LWP-01715
Model: LP37131
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
-
SKU: LWP-02110A
Model: LP36054-PEU
Condition: New-In-Box
-
SKU: LWP-02510A
Model: LP35244
Condition: New-In-Box
-
SKU: LWP-02520A
Model: LP35248
Condition: New-In-Box
-
SKU: LWP-01175B
Model: LP34996-0EU
Condition: New-In-Box
-
SKU: LWP-01700A
Model: lp35271-peu
Condition: New-In-Box
-
SKU: LWP-02540A
Model: 35256
Condition: New-In-Box
-
SKU: LWP-01178A
Model: LP34998-0EU
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-01631A
Model: LP37331
Condition: New-In-Box
-
SKU: LWP-LP37345
Model: LP37345-PWW
Condition: New-In-Box
-
SKU: LWP-LP37346
Model: LP37346-PWW
Condition: New-In-Box