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)
Chivas de Guadalajara was founded in May, 1906 by Edgar Everaert, a Belgian living in Mexico. The red and white striped flag of Bruges, Everaert's hometown, inspired the red and white stripes on the jersey. Chivas has grown into one of the most popular and one of the most successful teams in Mexico, winning multiple Liga Mx and CONCACAF Champions League titles.
From a squad originally made up of French, English and other nationalities, Chivas now fields only Mexican players, the only club in the country with this policy.
It's the club of Salvador Reyes, Ignacio Calderon, Sabas Ponce, and Javier "Chicharito" Hernandez.
Salute the history of the Goats with a Chivas 115 Years Jersey.
- Traditional red and white stripes.
- Ribbed collar and cuffs.
- "115" printed on the upper back.
- Features the original club badge.
- dryCELL technology wicks sweat.