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 knit textile upper that provides support to put you in total control. On the forefoot a grippy, textured coating aids confidence to every touch.
Master the ball in all conditions with the Controlskin upper that keeps the ball feeling like it's glued to your feet
Experience ultimate lockdown with an anatomically designed upper that mimics your heel shape
Knit textile upper delivers a supportive heel-to-toe fit for enhanced feel and control
Dominate on firm ground
Innovative injection-moulded Controlframe helps stabilise fast movement; Hybrid stud tips amplify rotation and traction"
Moulded Controlframe adds stability; Anatomically designed heel