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)
Lightweight and comfortable, these adidas football boots borrow from Copa's rich heritage. Their quilted-leather forefoot offers a soft touch and timeless feel. The firm ground outsole supports classy play on dry, natural grass. Made in part with recycled content generated from production waste, e.g. cutting scraps, and post-consumer household waste to avoid the larger environmental impact of producing virgin content. 25% of the components used to make the upper are made with a minimum of 50% recycled content.
BOLD LATERAL BRANDING: 3-stripes lateral branding
Firm Ground Outsole: OUTSOLE AND STUD CONFIGURATION ARE OPTIMISED FOR USE ON FIRM GROUND (DRY NATURAL GRASS).
LACED: U-THROAT COLLAR CONSTRUCTIONS ALLOWS FOR EASE OF ENTRY FOR ALL FOOT TYPES. LACES PROVIDE LOCK DOWN.
PREMIUM COW LEATHER VAMP: Premium Cow Leather Vamp creates soft ball touch sensation and great fit