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,max(z.non_invt) as non_invt
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)
LEFT JOIN tb_styles z on (z.style_id = a.style_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,4)
GROUP BY b.attr1
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
Nike Mercurial Vapor 14 Pro FG
Firm-Ground Soccer Cleats DESIGNED FOR SPEED.
Unlock the blueprint for speed with the Nike Mercurial Vapor 14 Pro. Color blocking at the sides and forefoot highlights key areas for precise dribbling, passing and shooting. We added a grippy texture throughout the upper to help you take total control of the game.
All Conditions Control (ACC) finish is designed for reliable touch in wet and dry weather. NikeSkin overlay across the foot adds durability. Tuned for Touch
A molded, synthetic upper features a textured pattern for better ball control when dribbling. Dig In and Take Off
Nike Aerotrak plate with micro grooves delivers explosive acceleration. Chevron studs provide multidirectional traction with every step. Seamless Fit
A comfortable lining wraps your foot for a natural, close-fitting feel.