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 Jr. Phantom Vision 2 Elite Dynamic Fit MG
Big Kids' Multi-Ground Soccer Cleat A NEW LEVEL OF PRECISION.
The Nike Jr. Phantom Vision 2 Elite Dynamic Fit MG brings a new level of fierce precision to the field. A comfortable inner sleeve is concealed in a Flyknit constructed outer layer to create a cleat for the finishers, the providers and the battlers of tomorrow's game.
Targeted texture across the upper provides precise touch and control on the ball. Conforming Comfort
Quad-Fit mesh hugs your foot without being constricting for dynamic support cut after cut. Breathable Support
Flyknit construction integrates areas of high breathability, stretch and support. Hidden Laces
Ghost Lace system tightens with one pull and stays hidden for a clean striking surface and precision on the ball. Streamlined Fit
Dynamic Fit collar wraps your ankle in soft, stretchy knit for a comfortable, secure fit.