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)
Turn your vision into control and prove your dominance with every precise pass, every minute of the game. With Predator, you leave nothing to chance, you're the master of control. Keep the ball glued to your feet in these juniors' football boots that feature a lightweight yet supportive Controlskin upper and a flexible adidas Primeknit collar. Made to dominate on firm ground.
Control the ball in all conditions with the Controlskin upper that keeps the ball glued to your feet
Moulded heel offers a snug fit for instinctive movement
Stretchy collar expands to your foot while ensuring supportive fit
High-performance polyamide-injected outsole layers to stabilise movement
Innovative injection-moulded construction helps stabilise fast movement; Hybrid stud tips amplify rotation and traction; Outsole optimised for firm ground