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 GT2 Academy FlyEase MG
Multi-Ground Soccer Cleats EASE INTO A SKILLFUL ATTACK.
The Nike Phantom GT2 Academy FlyEase MG is a data-informed design engineered for skillful attacks. The textured upper gives you grip for better ball control, while specialized studs let you switch between surfaces. The cleat's fold-down heel and wraparound strap are made for quick and easy 1-handed entry.
Quick and Easy onto the Field
Nike FlyEase technology makes it quick and easy to get into your cleats and onto the field. The heel folds down to let you slide your foot in. The 1-handed strap wraps over your foot to harness it then fastens to a hook-and-loop attachment area. Great Touch
Updated texture is strategically placed based on data from athlete testing. Thicker and denser at the instep and toe, it enables a skillful touch when dribbling, passing and striking.