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 (13433, 10934, 8616, 3535, 3537, 3539, 3540, 3541, 3543, 3544, 3545, 3546, 3547, 3548, 3549, 3550, 3551, 3552, 3554, 3555, 3556, 3557, 3561, 3570, 3571, 3572, 3573, 3577, 3583, 3584)) 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,13433,10934,8616,3535,3537,3539,3540,3541,3543,3544,3545,3546,3547,3548,3549,3550,3551,3552,3554,3555,3556,3557,3561,3570,3571,3572,3573,3577,3583,3584)
-
SKU: PRF-100619
Model: 100619
Condition: New-In-Box
-
SKU: PRF-901057
Model: 901057
Condition: New-In-Box
-
SKU: PRF-101561
Model: 101561
Condition: New-In-Box
-
SKU: PRF-100607
Model: 100607 (505-506)
Condition: New-In-Box
-
SKU: PRF-100609
Model: 100609 (505-541)
Condition: New-In-Box
-
SKU: PRF-100616
Model: 100616 (505-605)
Condition: New-In-Box
-
SKU: PRF-100617
Model: 100617 (505-505)
Condition: New-In-Box
-
SKU: PRF-100618
Model: 100618 (505-531)
Condition: New-In-Box
-
SKU: PRF-100635
Model: 100635 (505-571)
Condition: New-In-Box
-
SKU: PRF-100642
Model: 100642 (505-511)
Condition: New-In-Box
-
SKU: PRF-100660
Model: 100660 (505-707)
Condition: New-In-Box
-
SKU: PRF-100671
Model: 100671 (505-521)
Condition: New-In-Box
-
SKU: PRF-100673
Model: 100673 (505-508)
Condition: New-In-Box
-
SKU: PRF-100705
Model: 100705 (505-502)
Condition: New-In-Box
-
SKU: PRF-100718
Model: 100718 (505-720)
Condition: New-In-Box
-
SKU: PRF-100720
Model: 100720 (505-607)
Condition: New-In-Box
-
SKU: PRF-101518
Model: 101518 (504-334)
Condition: New-In-Box
-
SKU: PRF-101520
Model: 101520 (504-333)
Condition: New-In-Box
-
SKU: PRF-101533
Model: 101533 (701-262)
Condition: New-In-Box
-
SKU: PRF-102002
Model: 102002 (701-221)
Condition: New-In-Box
-
SKU: PRF-102007
Model: 102007 (701-222)
Condition: New-In-Box
-
SKU: PRF-102014
Model: 102014 (701-225)
Condition: New-In-Box
-
SKU: PRF-254527
Model: 254527
Condition: New-In-Box
-
SKU: PRF-330601
Model: 330601 (501-111)
Condition: New-In-Box
-
SKU: PRF-331511
Model: 331511 (502-212)
Condition: New-In-Box
-
SKU: PRF-331521
Model: 331521 (501-151)
Condition: New-In-Box
-
SKU: PRF-900649
Model: 900649 (505-523)
Condition: New-In-Box
-
SKU: PRF-900726
Model: 900726 (701-241)
Condition: New-In-Box
-
SKU: PRF-901024
Model: 901024
Condition: New-In-Box
-
SKU: PRF-901031
Model: 901031
Condition: New-In-Box