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. Tiempo Legend 9 Academy MG
Little/Big Kids' Multi-Ground Soccer Cleats
Celebrate the game’s biggest competition in a design ignited by the science of connectivity and gravity that the world stage inspires. Featuring a stunning futuristic look made for the globe's greatest players, these cleats have raised areas throughout the strike zone for precise dribbling, passing and scoring in 1 of our lightest Tiempos to date.
Where in the World?
Keep an eye out for special symbols around the design, nods to the host’s whereabouts that pay homage to the game’s grandest worldwide tournament. You’ll find our WHQ coordinates too, as well as scientific emblems speaking to the science of connected energy. The Legend Gets Lighter
A redesigned plate and refined upper help reduce bulk, so you can strike fast on the field. Supersoft Leather
Leather upper backed by soft foam pods helps you place your shots with precision.