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
HAVING sum(e.qoh+e.qc) > 0
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
The player of miracles. Messi makes any goal scorable. Any match winnable. And with superhuman agility, he creates moments of magic you never thought possible. Unlock agility and make your mark with these football boots. Designed for firm ground.
Zigzag your way to glory with godlike agility.
Experience zero wear-in time with Messi's favourite AGILITY KNIT upper that moulds perfectly to your foot the instant you slip it on
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
Secure lockdown and ankle stability with a DUAL LOCK COLLAR