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 GX Academy IC
Indoor/Court Soccer Shoes
Looking to take your game to the next level? Academy shoes give you the precision touch you need to let your innermost playing instincts dazzle. Featuring NikeSkin and a mesh touch zone for enhanced ball control and an agility plate that’s designed to swerve and sprint with you, it’s ready to ignite your spontaneous playmaking spirit.
Shoe-to-Ball Contact
An expanded NikeSkin touch zone, powered by engineered mesh, brings your foot even closer to the ball for better control while dribbling and passing in wet or dry conditions. The upper is soft and almost knit-like while the contact zone on the inside of the shoe is heightened for even better touch. Contoured for Comfort
Asymmetry in the heel provides comfort. Soft elements in the heel make for an easy break-in process and help reduce irritation and pressure without compromising stability and structure. Court Traction
A generative texture outsole gives you traction on street, court and indoor surfaces.