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)
Men's Nike Superfly 6 Academy MG Multi-Ground Football Boot
FIT FOR SPEED.
Men's Nike Superfly 6 Academy MG Multi-Ground Football Boot features a low-profile Dynamic Fit collar and a synthetic upper that wraps your foot for a skin-like fit straight out of the box. The 2-part podular plate system provides propulsive speed at every step.
Dynamic Fit collar links foot and lower leg while leaving ankle free to move.
Micro-textured, 2-tone upper provides precise touch at high speeds.
Podular plate system creates propulsive traction.
High outsole wrap on the toe enhances durability.
Chevron and circular studs are designed for both natural- and artificial-grass pitches.
Sculpted arch with internal last provides responsive support.