SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh, max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(z.non_invt) as non_invt
FROM tb_skus a
LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id)
LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id)
LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1)
LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id)
LEFT JOIN tb_styles z on (z.style_id = a.style_id)
WHERE (a.sell_web not in ('N','NO') or (a.sell_web is null)) and a.style_id=?
AND e.store_id in(1,2,3,4)
GROUP BY b.attr1
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
Nike Dri-FIT Academy
Men's Soccer Pants FIT FOR SWEAT-WICKING SPEED.
The Nike Dri-FIT Academy Pants are made with sweat-wicking fabric to keep you dry and comfortable—whether you're working on your game or keeping it casual while on the go.
Nike Dri-FIT technology moves sweat from your skin for quicker evaporation—helping you stay dry and comfortable. Versatile Fit
Zippered hems let you change without having to remove your cleats. Secure Storage
Side pockets keep your essentials zipped away while you're on the move. Cool Comfort
Mesh-lined waistband and hidden drawcord give you a snug, yet breathable fit. Fast Feel
Speed-inspired look is modeled after training apparel worn by professional players.