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 Legacy (FG) Men's Firm-Ground Football Boot SUPERB COMFORT AND TOUCH.
The Nike Tiempo Legacy (FG) Men's Firm-Ground Football Boot is made with a waterproof calf-leather upper and a Dri-FIT sweat-wicking fabric interior to help keep your foot dry and comfortable. Forefoot stitching creates a textured feel for excellent control and first touch.
Dri-FIT fabric interior and waterproof leather upper to help keep feet dry and comfortable.
Perforations at sides for breathability.
Textured forefoot surface for better control.
Recycled EVA sockliner for comfort and reduced cleat pressure.
Lightweight TPU plate with optimal cleat configuration for flexibility, traction and comfort.
Firm-ground (FG) cleats for use on short-grass fields that may be slightly wet but rarely muddy