SELECT id AS Code, name AS Name, CONCAT('/store/cat/06/09/', replace(replace(replace(replace(replace(replace(replace(replace(id, ' ', '+'), '!', '%21'), "'", '%27'), '-', '%2D'), '/', '%252F'), '(', '%28'), ')', '%29'), '&', '%2526'), '/Men%252527s+Work+Jackets+&+Coats/SWEATSHIRT/', replace(replace(replace(replace(replace(replace(replace(replace(name, ' ', '+'), '!', '%21'), "'", '%27'), '-', '%2D'), '/', '%252F'), '(', '%28'), ')', '%29'), '&', '%2526')) AS URL FROM subclasses WHERE web = 1 AND department = '06' AND class = '09' ORDER BY Name