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 (586756, 542448, 268767, 471575, 471687, 471761, 501208, 501313, 530275, 136594, 136597, 136598, 475181, 475194, 501418, 509018)) 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,586756,542448,268767,471575,471687,471761,501208,501313,530275,136594,136597,136598,475181,475194,501418,509018)
-
Sizes: Small, Medium, Large
SKU: WAN-X1
Model: X1CB-SM-BK-1, X1CB-MD-BK-1, X1CB-LG-BK-1
Condition: New-In-Box
-
SKU: WAN-08610
Model: TP-SP-BK-1
Condition: New-In-Box
-
SKU: WAN-06485
Model: 6485
Condition: New-In-Box
-
[Black, Yuma Tan, Sedona Orange, Aegean Blue, Wasatch Green, Uyuni Purple]
SKU: WAN-ROAM SLING 3L
Model: SLG3-BK-1, SLG3-TA-1, SLG3-SO-1, SLG3-WG-1, SLG3-AB-1, SLG3-UP-1
Condition: New-In-Box
-
[Black, Yuma Tan, Uyuni Purple, Aegean Blue, Sedona Orange, Wasatch Green]
SKU: WAN-ROAM SLING 6L
Model: SLG6-BK-1, SLG6-TA-1, SLG6-UP-1, SLG6-AB-1, SLG6-SO-1, SLG6-WG-1
Condition: New-In-Box
-
[Black, Yuma Tan, Aegean Blue, Wasatch Green, Sedona Orange, Uyuni Purple]
SKU: WAN-ROAM SLING 9L
Model: SLG9-BK-1, SLG9-TA-1, SLG9-AB-1, SLG9-WG-1, SLG9-SO-1, SLG9-UP-1
Condition: New-In-Box
-
[Orange, Purple]
SKU: WAN-PRVKE LITE
Model: WAN-PKLT-SO-3, WAN-PKLT-UP-3
Condition: New-In-Box
-
[Black, Blue, Green, Tan]
SKU: WAN-PRVKE 31PB
Model: PK31-GN-PB-3, PK31-BL-PB-3, PK31-TA-PB-3, PK31-BK-PB-3
Condition: New-In-Box
-
SKU: WAN-CCEP-BK-1
Model: CCEP-BK-1
Condition: New-In-Box
-
SKU: WAN-PRVKE21BLUE
Model: 6971
Condition: New-In-Box
-
SKU: WAN-PRVKE31BLUE
Model: 6999
Condition: New-In-Box
-
SKU: WAN-PRVKE31GREEN
Model: 6992
Condition: New-In-Box
-
SKU: WAN-PRVKE31V3.0GREEN
Model: PK31-GN-PB-3
Condition: New-In-Box
-
SKU: WAN-PK31-TA-PB-3
Model: PK31-TA-PB-3
Condition: New-In-Box
-
[Black, Blue, Orange, Purple, Green, Tan]
SKU: WAN-D1FP
Model: D1FP-BK-2, D1FP-SO-2, D1FP-UP-2, D1FP-AB-2, D1FP-WG-2, D1FP-YT-2
Condition: New-In-Box
-
SKU: WAN-PK21-SO-PB-3
Model: PK21-SO-PB-3
Condition: New-In-Box