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)
Men's Nike Tiempo Legend 7 Elite (FG) Firm-Ground Football Boot ADAPTIVE. CUSHIONED. LIGHTWEIGHT.
Men's Nike Tiempo Legend 7 Elite (FG) Firm-Ground Football Boot elevates a classic by adding a new ultra-soft leather and, for the first time in Tiempo history, a Flyknit constructed heel and midfoot with Flywire cables. It’s legendary fit, touch and traction—evolved.
Flyknit constructed heel and tongue add breathability, stretch and support where you need it most.
Premium kangaroo leather with interior quilting provides cushioned touch.
Flywire cables integrate with the laces to lock down the foot.
Stability Pods inside the collar cup your ankle for support.
NIKEGRIP technology utilizes interlocking textures to help prevent your foot from sliding inside the boot.
Molded sockliner reduces stud pressure and enhances comfort.