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)
GROUP BY b.attr1
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
Premier League Flight
Soccer Ball ENGINEERED FOR PRECISION FLIGHT.
Honed over 8 years and 1,700 hours of testing, the Premier League Flight Soccer Ball is a revolution in consistent flight. Molded grooves and a grippy texture reduce unexpected movement through the air to help you put the ball where you want it.
Nike Aerowsculpt technology uses molded grooves to disrupt airflow across the ball for less drag and more stable flight. The revolution in aerodynamics results in 30% truer flight compared to Nike's Merlin ball. All-Weather Touch
All Conditions Control (ACC) technology adds a grippy texture, so you get a consistent touch in both wet or dry conditions. Micro Tuned
3D-printed ink overlay fine-tunes ball flight so you hit your target shot after shot, pass after pass. Fused for Power
4 fused panels create a larger sweet spot on the ball for powerful strikes.