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 (619434, 619429, 619428, 619423, 619420, 619416, 619414, 619407, 587889, 587859, 587937, 587936, 581808, 578474, 578472, 578469, 578465, 578460, 578456, 578443, 578438, 578433, 578431, 578430, 578428, 578425, 578412, 576498, 555400, 555395)) 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,619434,619429,619428,619423,619420,619416,619414,619407,587889,587859,587937,587936,581808,578474,578472,578469,578465,578460,578456,578443,578438,578433,578431,578430,578428,578425,578412,576498,555400,555395)
-
SKU: PRO-72108
Model: 72108
Condition: New-In-Box
-
SKU: PRO-72101
Model: 72101
Condition: New-In-Box
-
SKU: PRO-72094
Model: 72094
Condition: New-In-Box
-
SKU: PRO-72122
Model: 72122
Condition: New-In-Box
-
SKU: PRO-72115
Model: 72115
Condition: New-In-Box
-
SKU: PRO-70988
Model: 70988
Condition: New-In-Box
-
SKU: PRO-70981
Model: 70981
Condition: New-In-Box
-
SKU: PRO-72199
Model: 72199
Condition: New-In-Box
-
Sizes: X-Small, Small, Medium, Large
SKU: PRO-BLUE RIDGE GREEN
Model: 68736, 68737, 68738, 68739
Condition: New-In-Box
-
Sizes: X-Small, Small, Medium, Large
SKU: PRO-BLUE RIDGE DEEP BLUE
Model: BLUERIDGE XS, BLUERIDGE S, BLUERIDGE M, BLUERIDGE L
Condition: New-In-Box
-
SKU: PRO-67907
Model: 67907
Condition: New-In-Box
-
SKU: PRO-67900
Model: 67900
Condition: New-In-Box
-
SKU: PRO-61277
Model: 8046
Condition: New-In-Box
-
SKU: PRO-68551
Model: 68551
Condition: New-In-Box
-
SKU: PRO-68579
Model: 68579
Condition: New-In-Box
-
SKU: PRO-68572
Model: 68572
Condition: New-In-Box
-
SKU: PRO-68565
Model: 68565
Condition: New-In-Box
-
SKU: PRO-69023
Model: 69023
Condition: New-In-Box
-
SKU: PRO-69022
Model: 69022
Condition: New-In-Box
-
SKU: PRO-69031
Model: 69031
Condition: New-In-Box
-
SKU: PRO-69030
Model: 69030
Condition: New-In-Box
-
SKU: PRO-68488
Model: 68488
Condition: New-In-Box
-
SKU: PRO-67872
Model: 67872
Condition: New-In-Box
-
SKU: PRO-67865
Model: 67865
Condition: New-In-Box
-
SKU: PRO-67431
Model: 67431
Condition: New-In-Box
-
SKU: PRO-67424
Model: 67424
Condition: New-In-Box
-
SKU: PRO-68734
Model: 68734
Condition: New-In-Box
-
SKU: MAN-00157
Model: MB PL-CL-S
Condition: New-In-Box
-
SKU: PRO-65625
Model: 65625
Condition: New-In-Box
-
SKU: PRO-65639
Model: 65639
Condition: New-In-Box