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)
Liverpool FC Windrunner
Men's Hooded Soccer Jacket THE ORIGINAL RUNNING JACKET GETS REDS PRIDE.
The Liverpool FC Windrunner Jacket pays tribute to a classic by elevating the original running layer for the field. It features iconic design details like the 26-degree chevron on the chest, and a water-repellent finish helps you stay dry while you rep the Reds.
Zippered pockets let you easily secure your essentials. Breathable comfort
Mesh lining helps keep you cool and comfortable. Your Team, Your Colors
Signature details highlight your Reds pride.
Ribbed cuffs and hem provide a stay-put fit.
Drawcord at the hood lets you adjust the coverage.
Loose fit for a roomy feel
Upper body: 100% nylon. Lower body and mesh: 100% polyester.