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)
Nike Jr. Phantom GT Pro FG
Big Kids' Firm-Ground Soccer Cleat ATTACK WITH PRECISION AND AGILITY.
The Nike Jr. Phantom GT Elite FG is engineered for precise attacks. Flyknit construction is covered with a grippy texture for better touch, while specialized traction lets you take control of the game.
Informed by athlete testing, grippy texture is thicker and denser at the instep and toe to give you better touch for passing, dribbling and shooting. Specialized Traction
Hyperquick system combines a finely-tuned chassis with an open-arch plate for lightweight stability. An updated stud configuration gives you traction for quick changes of direction. Weather-Ready Design
All Conditions Control (ACC) finish means you get reliable touch in wet and dry conditions. Strong and Stretchy
Flyknit construction wraps your foot in stretchy yarns for a supportive, sock-like fit.
Off-center lacing gives you a clean strike zone.