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)
Neymar Jr. Superfly 6 Academy MG Grade-School Kids' Multi-Ground Football Boot
FAST FIT. NEYMAR FLAIR.
Neymar Jr. Superfly 6 Academy MG Grade-School Kids' Multi-Ground Football Boot features a new low-profile Dynamic Fit collar and a synthetic upper that wraps your foot for a streamlined fit straight out of the box. The details celebrate the legendary sense of flow, beauty and rhythm in the Brasilian style of play that Neymar embodies.
Neymar details celebrate his connection to Brasil and the beautiful game.
Low-profile Dynamic Fit collar offers a streamlined fit.
Pull tabs provide easy on-and off.
Micro-textured upper provides precise touch at high speeds.
Multi-ground plate provides traction on both natural- and artificial-grass pitches.
Internal lining hugs the foot for a premium, locked-in feel.