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)
GROUP BY b.attr1
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
Nike Phantom Vision Academy Dynamic Fit Game Over MG Multi-Ground Soccer Cleat
A NEW LEVEL OF PRECISION.
The Nike Phantom Vision Academy Dynamic Fit Game Over MG brings the fierce precision of street play to the pitch. A foot-hugging sleeve has a custom feel, and the Ghost Lace system tights with 1 pull and is hidden for a bigger striking surface.
Fit that Feels Good
The internal bootie and Dynamic Fit collar work together to wrap and cushion your foot on the field.
Precise Touch
Ghost Laces system is concealed below a textured outer layer for a clean, precise touch. The laces tighten quickly with 1 pull.
Versatile Traction
A versatile multi-ground plate provides traction on natural- and artificial-grass surfaces.