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 Venom Elite Game Over FG Firm-Ground Soccer Cleat
The Nike Phantom Venom Elite Game Over FG is engineered for powerful, precise strikes that win games. Blades on the instep create spin to control the flight of the ball, while Flywire cables and a flexible plate provide the stability and traction needed to unleash at any moment.
Flyknit construction with Flywire cables adapts to your foot.
Instep blades create spin for precise, powerful strikes.
HyperReactive plate flexes for multidirectional traction.
Micro-texture is molded into the toe and vamp for better ball control.
Foam wraps your heel for plant foot stability.
Textured NikeGrip top cloth helps hold your foot in place.