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
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)
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 football boots, featuring a flexible adidas Primeknit upper and ultra-responsive Boost. Made to dominate on firm ground.
Stretchy Sockfit collar features adidas Primeknit for adaptive support, ultralight comfort and ease of entry; Control the ball at high speed with a Purecut laceless sock forefoot with no edges, overlays or laces to get between you and the ball
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
Integrated forged knit midfoot design features zoned areas of support for medial and lateral stability without an external cage or internal tongue
Boost is our most responsive cushioning ever: The more energy you give, the more you get
Innovative injection-moulded Controlframe helps stabilise fast movement; Hybrid stud tips amplify rotation and traction; Outsole optimised for firm ground