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)
GROUP BY b.attr1
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
Kids' Nike Jr. LegendX 7 Academy (TF) Artificial-Turf Football Boot
ADAPTIVE. CUSHIONED. STABLE.
Kids' Nike Jr. LegendX 7 Academy (TF) Artificial-Turf Football Boot combines the classic touch of calf leather with the durable fit of an internal mesh liner that prevents overstretching as the leather seasons. It’s fit, touch and traction—evolved.
Floating mesh liner and webbed cables provide a durable, adaptive fit.
Calf leather on the vamp with interior quilting provides cushioned touch.
Rubber outsole provides reliable traction on artificial-turf surfaces.
Elastic gussets on the sides of the tongue hold it in place during play.
Swoosh design trademark is screenprinted for flexibility.