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 (3555, 3556, 3557, 3561, 3570, 3571, 3572, 3573, 3577, 3583, 3584, 9865, 10248, 10249, 10251, 8616, 373852, 381203, 381214, 381232, 381235, 358306, 423484, 262240, 262647, 262648, 262649, 262651, 262653, 262670)) 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,3555,3556,3557,3561,3570,3571,3572,3573,3577,3583,3584,9865,10248,10249,10251,8616,373852,381203,381214,381232,381235,358306,423484,262240,262647,262648,262649,262651,262653,262670)
-
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
-
SKU: PRF-101521
Model: 101521
Condition: New-In-Box
-
SKU: PRO-42242
Model: 9370
Condition: New-In-Box
-
SKU: PRO-42243
Model: 9377
Condition: New-In-Box
-
SKU: PRO-42245
Model: 9307
Condition: New-In-Box
-
SKU: PRF-101561
Model: 101561
Condition: New-In-Box
-
SKU: PRF-100706
Model: 100706
Condition: New-In-Box
-
SKU: PRF-101231
Model: 101231
Condition: New-In-Box
-
SKU: PRF-101234
Model: 101234
Condition: New-In-Box
-
SKU: PRF-101235
Model: 101235
Condition: New-In-Box
-
SKU: PRF-101236
Model: 101236
Condition: New-In-Box
-
SKU: PRF-254587
Model: 254587
Condition: New-In-Box
-
SKU: PRF-101303
Model: 101303
Condition: New-In-Box
-
SKU: PRF-101219
Model: 101219
Condition: New-In-Box
-
SKU: PRF-101012
Model: 101012
Condition: New-In-Box
-
SKU: PRF-101013
Model: 101013
Condition: New-In-Box
-
SKU: PRF-101014
Model: 101014
Condition: New-In-Box
-
SKU: PRF-101016
Model: 101016
Condition: New-In-Box
-
SKU: PRF-101018
Model: 101018
Condition: New-In-Box
-
SKU: PRF-101019
Model: 101019
Condition: New-In-Box