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)
Every striker's dream, every defender's nightmare. Messi is the player you wish you were and hope you never face. Haunt the keeper with goal-bound strikes and unlock agility in these Nemeziz Messi juniors' 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 during radical play with the revolutionary TORSION TAPE of the laceless 360 AGILITY BANDAGE SYSTEM, inspired by sports taping for a completely new fit experience
Lateral and medial support from 360 TORSION TAPE
Secure lockdown and ankle stability with a DUAL LOCK COLLAR