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 GO FOR GOLD.
The Nike Mercurial Vapor 14 Pro FG elevates a classic with gold and silver accents for a new look that’s fit for champions. A cushioned insole gives you nonstop comfort, and the innovative plate provides instant responsiveness for quicker cuts at high speeds.
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.