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)
These juniors' adidas football boots were built to improve your accuracy with the ball at your feet. Spread across their soft synthetic forefoot, High Definition Texture provides grip for pinged passes and drilled shots. Perfected for firm ground, the outsole delivers maximum traction to keep you in control. Made with a series of recycled materials, this upper features at least 50% recycled content. This product represents just one of our solutions to help end plastic waste.
2 PIECE MID CUT COLLAR: 4 WAY STRETCH MATERIAL DELIVERS A SUPPORTIVE AND ADAPTIVE FIT.
2 PIECE MID CUT COLLAR: PREMIUM 2 PIECE COLLAR CONSTRUCTION ALLOWS FOR EASY STEP AND PROVIDES A SECURE LOCKDOWN.
BOLD LATERAL BRANDING: 3-stripes lateral branding
COATED TEXTILE: DURABLE AND SOFT TOUCH UPPER MATERIAL.
Firm Ground Outsole: Move with maximum traction on firm ground (dry natural grass) with the FG outsole
High Definition Texture: 3D texture allows for better grip on the ball and close boot to ball contact