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)
Kids' Neymar Jr. Mercurial Vortex III (FG) Firm-Ground Football Boot MEET THE NEW PHENOMENON.
Kids' Neymar Jr. Mercurial Vortex III (FG) Firm-Ground Football Boot remixes elements of past Mercurials to celebrate Neymar's status as the new Brasilian phenomenon. It combines a synthetic leather upper with embossed ridges to create a boot for today's fast-paced game.
Synthetic leather upper provides durability.
Ribbing inspired by the original 1998 Mercurial helps enhance touch.
Print on the medial side is inspired by the Mercurial Neymar wore in 2010.
Neymar name crest is printed on the back of the heel.
Full-length TPU plate provides durability and traction.