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,4)
GROUP BY b.attr1
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
Of, by, and for the people. This is the USMNT kit that we wanted, that we deserved -- that we made.
E PLURIBUS UNUM: Out of many, one. Since 1776, we've declared that we are stronger together. That's why we are working together to donate to bringing the beautiful game to underserved neighborhoods.
And, since 1776, we've known that when those who govern us fail us, yeah - we complain for a little bit, but then we take things into our own hands. That's why we created the Unity Kit. No focus groups. No major sports conglomerates, it's just - of, by, and for the people.
So, you want stripes? We've got stripes. You want stars? We've got 13 of them. You want history? Not only does this kit pay homage to our legacy, but there is also a map where we signed the Declaration of Independence. Why? Because this kit is our independence, that's why.
- Side seams, retail fit
- Shoulder to shoulder taping
- Unisex sizing