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 Tiempo Legend VI (FG) Women's Firm-Ground Football Boot DOMINATING TOUCH, LOCKED-DOWN FIT.
With water-repellent New Tiempo Adaptive kangaroo leather for dry play and a midfoot cage for fit stabilization, Nike Tiempo Legend VI (FG) Women’s Firm-Ground Football Boot maintains a consistent touch all match long. Bold plate graphics give your opponents something to look at.
New Tiempo Adaptive kangaroo leather reduces water absorption and improves the boot's ability to dry.
All Conditions Control (ACC) technology provides optimal ball control in dry or wet weather.
Tongueless construction wraps the foot for a snug, locked-down fit.
Interior silicone dot grid grips the insole to prevent slipping.
TPU flex plate moves with your foot for stability, traction and comfort.