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 Jr. Phantom GX Academy MG
Little/Big Kids' Multi-Ground Soccer Cleats
Looking to take your game to the next level? Academy cleats 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.
Cleat-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 cleat 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. Tri-Star Traction
The newly implemented blend of conical and tri-star studs help unlock change of direction and movement for an easy transition, allowing you to tack down into the grass for a quick takeoff. Easy On!
Better yet, there’s no need to tie these! Pull tabs and an adjustable tongue offer your young star an easy slip-on solution, so you can play fast and free. Elastic laces offer adaptable lockdown.