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 Lunar LegendX 7 Pro 10R IC
Indoor/Court Football Boot CUSHIONED TOUCH. RONALDINHO CLASS.
The Nike Lunar LegendX 7 Pro 10R IC Indoor/Court Football Boot combines the classic touch of calf leather with 10R details, like a throwback quilted toe, that celebrate Ronaldinho’s success in storied football cities throughout his career.
Colorway is inspired by Ronaldinho's success in storied football cities.
Calf leather with throwback quilted toe provides cushioned touch.
Zonal herringbone outsole provides lightweight targeted traction on indoor/court surfaces.
Tongue loop provides easy on-and-off.
Lunarlon cushioning system features a soft yet resilient foam core for the ultimate in lightweight cushioning.