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. Superfly 360 Elite FG
Kids' Firm-Ground Football Boot 360 DEGREES OF SPEED.
The Flyknit constructed upper of the Nike Jr. Superfly 360 Elite FG Kids' Firm-Ground Football Boot wraps your foot for an all-enveloping, second-skin-like fit straight out of the box. A 2-part podular plate system provides responsive traction at every step.
Flyknit upper with Dynamic Fit collar wraps all around your foot.
Textured NIKESKIN technology overlay provides touch at high speeds.
Podular plate system creates responsive traction.
Low-profile collar links foot and lower leg while leaving the ankle free to move.
All Conditions Control (ACC) technology optimizes ball control in wet and dry conditions.
Cushioned foam heel lining grips your foot and helps hold boot in place.
The outsole's chevron studs facilitate bursts of speed and quick stops.