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 8 Academy IC Little/Big Kids’ Indoor/Court Soccer Shoe
LEATHER FOR LEGENDARY TOUCH.
The Nike Jr. Tiempo Legend 8 Academy Shoe takes the legendary touch of calfskin leather and adds cushioning that equips you for the court or the streets. A mesh tongue and collar lining add breathability and street style.
Calfskin Leather Touch
The soft calfskin leather forefoot is left unstitched with a molded diamond texture for ball control.
A foam midsole helps absorb the impact of urban play, and a foam tongue adds cushioning on top of your foot.
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.
Sockliner for low-profile cushioning
Lace loop helps hold the tongue in place
For traction on the street, court and indoor surfaces