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)
Show your true colors and support your favorite national team on the big stage with the Official Licensed Replica kit. Authentic Serbian textile patterns are the starting point to create a graphic which can represent the serbian culture and history to the world, with the incorporation of elements from the NT crest. NIKOLA TESLA The origin story of the genius who changed the world is finally being told to the future generations. Today his ideas are more relevant than ever and they are a great inspiration.
Material
Main Material 1: 100% polyester -double knit-finish: bio-based wicking finish;inside out;print: sublimation print-150.00 g/m²-FUN/001;PS/01-CF/002-sublimation print Main Material 2: 100% polyester -double knit-finish: bio-based wicking finish-150.00 g/m²-FUN/001;PS/01-CF/002-piece dyed
