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 Mercurial Superfly 8 Pro KM FG
Firm-Ground Soccer Cleats PURE HEAT FOR YOUR FEET.
Embody Kylian Mbappé’s relentless pace with fiery design details. A knit collar wraps your ankle in lightweight fabric that moves with you when it’s time to turn up the heat.
Grip and Go
Nike Aerotrak zone in the forefoot plate and chevron studs provide multidirectional traction with every step. Precision Touch
A textured pattern on the molded upper gives you precise touch when dribbling at high speeds. Made to Move
Knit collar wraps your ankle in soft, stretchy fabric for a secure feel. Rep Kylian
“KM” logo on the heel lets you represent the world’s fastest soccer player.