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)
Surprise your opponents as you appear out of nowhere. And score out of nothing. Lace up Nemeziz and create the unexpected. An innovative, tape-inspired upper on these juniors' football boots supports radical moves for devastating play. Designed for firm ground.
Supernatural agility just got more natural.
Foot-hugging AGILITY KNIT 2.0 forefoot for perfect fit and response right out of the box
Highest mobility and bandaged fit during radical play with the revolutionary TORSION TAPE of the 360 AGILITY BANDAGE SYSTEM, inspired by sports taping
Lateral and medial support from 360 TORSION TAPE inspired by sports taping
Secure lockdown and ankle stability with a DUAL LOCK COLLAR
Explosive power on dry natural grass from the lightweight TORSIONFRAME outsole with TORSION RIBS for push-off support