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 that hugs your foot like a second skin. The TPU-injected outsole gives you the stability to take command of the game, while hybrid stud tips let you cut and accelerate with precision.
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