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 Phantom GX Pro Dynamic Fit FG
Firm-Ground Soccer Cleats
Serious about your game? Pro cleats are for the pinpoint passer who can curl the ball around the defense and the inventive, yet elusive yo-yo dribbler who has the ball on a string. Your game is all about precision, making the plays that matter most. Take your skills to the next level with some of Nike’s greatest innovations, like an enlarged touch zone up top. It complements a design that moves with your natural on-field flow, so you can command the game from any position. This version has a Dynamic Fit collar, which wraps your ankle in soft, stretchy fabric for a secure feel.?
Enhanced Touch
An expanded NikeSkin touch zone, powered by engineered mesh, brings your foot even closer to the ball for better control while dribbling and passing in wet or dry conditions. The upper is soft and almost knit-like while the contact zone on the inside of the cleat is heightened for even better touch. Contoured for Comfort
Asymmetry in the heel provides comfort. Soft elements in the heel make for an easy break-in process and help reduce irritation and pressure without compromising stability and structure. Our ghost lace system lets you forget about your shoelaces when it’s time to play. A stretch mesh cover offers access to the laces for tying and provides a cleaner cleat-to-ball connection. It complements the NikeSkin while offering a secure fit and feel. Traction for the Field
Tri-star studs work with forefoot flex grooves to provide optimal traction and help unlock change of direction. See the lines on the outsole? They match your typical on-field movements, which push forward then zigzag before a strike.