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 mesh upper with a snug-fitting collar that locks you in for total control. On the forefoot a grippy, textured coating adds confidence to every touch.
Structured Primemesh upper provides a comfortable, sock-like fit so you can move with instinct to control the ball at high speed; Control the ball in all conditions with the Controlskin upper that keeps the ball glued to your feet
Experience ultimate lockdown with an anatomically designed upper that mimics your heel shape; Stretchy collar expands to your foot while ensuring supportive fit
Dominate on firm ground
High-performance TPU-injected layers in the outsole designed to stabilise movement"