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 Phantom GT Elite Dynamic Fit FG
Firm-Ground Soccer Cleat ATTACK WITH PRECISION AND AGILITY.
The Nike Phantom GT Elite Dynamic Fit FG is a data-driven design 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. A stretchy collar creates a secure feel, so you can focus on your footwork.
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. Lightweight Agility
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
Flyknit construction wraps your foot in stretchy yarns for a supportive, sock-like fit. All Conditions Control (ACC) finish means you get a reliable touch in wet and dry conditions. Snug Support
Dynamic Fit collar wraps your ankle in soft, stretchy fabric for a secure feel.
Off-center lacing gives you a clean strike zone.