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 Premier II FG
Firm-Ground Soccer Cleat PURE LEATHER FOR PURE TOUCH.
The Nike Premier II FG Cleat perfects the fundamentals. Soft kangaroo leather conforms to your foot for a classic, cushioned touch, while conical studs deliver consistent traction and a comfortable feel underfoot.
A wider lace area is designed to accommodate a range of foot sizes and is easy to take on and off for everyday play. Classic Kangaroo Leather Touch
Renowned for softness and durability, the kangaroo leather used in the forefoot offers a touch unlike any other. Reliable, Comfortable Traction
Conical studs deliver consistent traction anywhere on the field and dig in evenly for a smooth ride.
Fold-over tongue keeps laces out of the way.
Full-length TPU plate offers durability and stability.
Lightweight insole delivers low-profile cushioning.
Firm-ground (FG) cleats are best for use on slightly wet short-grass fields.