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)
Your creativity is dominating. Now prove it. Pull the strings and control the outcome of the game. You choose who, when and where. You dictate what happens next. Master control with Predator. Built for ultimate lockdown, these football boots have a sock-like Primemesh upper so you can move with instinct at high speed. Controlskin keeps the ball where you need it, while the TPU-injected outsole gives you stability to take command on firm ground.
Moulded heel offers a snug fit for instinctive movement
Control the ball in all conditions with the Controlskin upper that keeps the ball glued to your feet
Stretchy collar expands to your foot while ensuring supportive fit
High-performance TPU-injected layers in the outsole designed to stabilise movement
Hybrid stud tips amplify rotation and traction; Outsole has been designed and engineered for best use on firm ground