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. These juniors' football boots have a synthetic upper that's anatomically designed to lock down your feet as you lock onto goal. Hybrid stud tips let you move with instinct on firm ground.
Moulded heel offers a snug fit for instinctive movement
Control embossing on the upper gives you improved ball handling
Snug sock-like material fits like a second skin
High-performance TPU-injected layers in the outsole designed to stabilise movement
Hybrid stud tips amplify rotation and traction; Outsole optimised for firm ground