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)
The planet's fastest boot. Experience extreme acceleration and razor-sharp handling
thanks to a SPRINTSKIN upper with TPU support bands, sprint frame outsole and new
Upper: SPRINTSKIN is a revolutionary single-layer synthetic for incredible ball
feel and reduced weight. TPU bottom frame reinforces the upper and prevents abrasion
in the kicking area. Internal TPU support bands offer increased stability and support in
the important lateral and medial movements.
Inlay: Delivered with the ultralight sockliner in the shoe. Additionally, a socond
pair of comfort sockliners is in the box.
Outsole: The sprint frame construction uses geometrical learnings and a new
stud shape to offer the perfect balance between light weight and stability. A new
TRAXION stud shape for maximum acceleration and speed on firm natural surfaces.