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
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)
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)
Grade-School Kids' Nike Jr. Vapor 12 Academy (MG) Multi-Ground Football Boot
SPEED ON EVERY PITCH.
Grade-School Kids' Nike Jr. Vapor 12 Academy (MG) Multi-Ground Football Boot features an anchored tongue and a synthetic upper that wraps your foot for consistent fit all match long. A 2-part podular plate system provides responsive speed whether you're on a natural- or artificial-grass pitch.
Synthetic 2-tone upper with anchored tongue offers consistent fit.
Micro-texture provides precise touch at high speeds.
Podular plate system creates responsive traction.
Sculpted arch with internal last provides responsive support.
High outsole wrap on the toe resists wear.
Chevron and hollow-point studs provide versatile performance on natural- and artificial-grass pitches.