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 laceless adidas football boots were built to improve your accuracy with the ball at your feet. Spread across their coated textile 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.
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
Firm Ground Outsole: Outsole designed for maximum traction on firm ground (dry natural grass)
High Definition Texture: 3D texture allows for better grip on the ball and close boot to ball contact
LACELESS MID CUT COLLAR: FOR CLEAN BALL-STRIKING.
LACELESS MID CUT COLLAR: HIGH REBOUND STRETCH COLLAR MATERIAL PROVIDES A SUPPORTIVE AND COMFORTABLE FIT.
LACELESS MID CUT COLLAR: PREMIUM LACELESS CONSTRUCTION ALLOWS FOR EASY STEP AND PROVIDES A SECURE LOCKDOWN.