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)
Nike HyperVenom Proximo IC Men's Indoor-Court Soccer Boot PINNACLE TOUCH, COURT-READY STYLE.
Play with agility and style in the Nike HyperVenom Proximo Men's Indoor-Court Football Boot. Its textured upper amplifies ball touch, while the Dynamic Fit collar and Flywire cables create a locked-down fit so you can dominate the small-sided game.
Textured upper amplifies ball touch.
Dynamic Fit collar provides a seamless fit from ankle to foot.
Flywire cables lockdown the foot.
NIKESKIN technology overlay enhances ball feel and creates superior touch.
All Conditions Control (ACC) technology provides optimal ball control.
Contoured sockliner and Phylon midsole provide low-profile cushioning.
Durable rubber outsole is designed for traction on indoor surfaces.