SELECT id AS Code, name AS Name, CONCAT('/store/cat/TOYS/TOOUT/', replace(replace(replace(replace(replace(replace(replace(replace(id, ' ', '+'), '!', '%21'), "'", '%27'), '-', '%2D'), '/', '2F'), '(', '%28'), ')', '%29'), '&', '%26'), '/TOYS+&+ACTIVITIES/OUTDOOR+FUN/', replace(replace(replace(replace(replace(replace(replace(replace(name, ' ', '+'), '!', '%21'), "'", '%27'), '-', '%2D'), '/', '2F'), '(', '%28'), ')', '%29'), '&', '%26')) AS URL FROM subclasses WHERE web = 1 AND department = 'TOYS' AND class = 'TOOUT' ORDER BY Name