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 Jr. Tiempo Legend 9 Academy IC
Little/Big Kids' Indoor/Court Soccer Shoes STRIKE WITH CONFIDENCE. STRIKE IN COMFORT.
1 of our lightest Tiempos to date, the Nike Jr. Tiempo Legend 9 Academy IC lets you go on the offensive with a low-profile design that's reinvented for attackers. The upper has raised textures backed by soft foam pods for precise dribbling, passing and shooting, while a rubber sole helps supercharge traction during small-sided games.
Seamless Fit and Feel
A comfortable lining wraps your foot for a natural, close-fitting feel. Supersoft Leather
Premium leather in the upper with a suede toe tip lets you place your shots with precision. Made for Motion
Based on Nike Sports Research Lab analysis of player movements, the rubber outsole is designed to provide multidirectional traction on street, court and indoor surfaces.