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)
"If your command of the pitch leaves your rivals' tactics in tatters, you're ready to own Predators. Built for precision on firm ground, these football boots have a supportive knit textile upper for a locked-in fit that eliminates the need for laces and leaves more room for ball control. On the forefoot a grippy, textured coating adds confidence to every touch. A layer of responsive cushioning distributes stud pressure across the sole.
Master the ball in all conditions with the Controlskin upper that keeps the ball glued to your feet; Control the ball at high speed with a Purecut laceless sock forefoot with no edges, overlays or laces to get between you and the ball
adidas Primeknit upper wraps the foot with an engineered fit for targeted support that enhances body motion and movement
Boost is our most responsive cushioning ever, delivering incredible energy return: The more energy you give, the more you get
Stability on firm ground
Innovative injection-moulded Controlframe helps stabilise fast movement"