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 (4160, 4163, 4164, 4165, 4166, 4167, 4168, 4169, 4170, 4171, 4172, 4173, 12494, 11258, 11259, 11260, 11263, 11264, 11265, 11266, 11267, 11268, 12418, 6124, 6125, 6126, 6127, 6128, 6129, 6131)) 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,4160,4163,4164,4165,4166,4167,4168,4169,4170,4171,4172,4173,12494,11258,11259,11260,11263,11264,11265,11266,11267,11268,12418,6124,6125,6126,6127,6128,6129,6131)
-
SKU: SLI-613-331
Model: 613-331
Condition: New-In-Box
-
SKU: SLI-612-212
Model: 612-212
Condition: New-In-Box
-
SKU: SLI-617-800-CP
Model: 617-800
Condition: New-In-Box
-
SKU: SLI-618-382
Model: 618-382
Condition: New-In-Box
-
SKU: SLI-615-600
Model: 615-600
Condition: New-In-Box
-
SKU: SLI-618-610
Model: 618-610
Condition: New-In-Box
-
SKU: SLI-618-612
Model: 618-612
Condition: New-In-Box
-
SKU: SLI-618-709
Model: 618-709
Condition: New-In-Box
-
SKU: SLI-618-330
Model: 618-330
Condition: New-In-Box
-
SKU: SLI-DW-PKS03
Model: DW-PKS03
Condition: New-In-Box
-
SKU: SLI-618-738
Model: 618-738
Condition: New-In-Box
-
SKU: SLI-618-731
Model: 618-731
Condition: New-In-Box
-
SKU: SLI-618-740
Model: 618-740
Condition: New-In-Box
-
SKU: SLI-615-310
Model: 615-310
Condition: New-In-Box
-
SKU: SLI-617-903
Model: 617-903
Condition: New-In-Box
-
SKU: SLI-617-400
Model: 617-400
Condition: New-In-Box
-
SKU: SLI-613-330
Model: 613-330
Condition: New-In-Box
-
SKU: SLI-613-344
Model: 613-344
Condition: New-In-Box
-
SKU: SLI-613-345
Model: 613-345
Condition: New-In-Box
-
SKU: SLI-619-975
Model: 619-975
Condition: New-In-Box
-
SKU: SLI-618-340
Model: 618-340
Condition: New-In-Box
-
SKU: SLI-618-752
Model: 618-752
Condition: New-In-Box
-
SKU: SLI-615-317
Model: 615-317
Condition: New-In-Box
-
SKU: SLI-615-320
Model: 615-320
Condition: New-In-Box
-
SKU: SLI-615-501
Model: 613-345
Condition: New-In-Box
-
SKU: SLI-615-315
Model: 615-315
Condition: New-In-Box
-
SKU: SLI-615-900
Model: 615-900
Condition: New-In-Box
-
SKU: SLI-619-915
Model: 619-915
Condition: New-In-Box
-
SKU: SLI-619-950
Model: 619-950
Condition: New-In-Box
-
SKU: SLI-618-719
Model: 618-719
Condition: New-In-Box