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)
Nike Jr. Legend 7 Academy (MG) Multi-Ground Football Boot
ADAPTIVE. CUSHIONED. STABLE.
Nike Jr. Legend 7 Academy (MG) Multi-Ground Football Boot combines the classic touch of calf leather with the durable fit of an internal liner that prevents overstretching as the leather seasons. It’s fit, touch and traction—evolved.
Floating liner and webbed cables provide a durable, adaptive fit.
Calf leather on the vamp with interior quilting provides cushioned touch.
Multi-ground plate provides reliable traction on firm-ground and artificial-turf surfaces.
Elastic gussets on the sides of the tongue hold it in place during play.
Swoosh design trademark is screenprinted for flexibility.
Molded sockliner reduces stud pressure and enhances comfort.