SELECT id AS Code, name AS Name, CONCAT('/brand/', id, '/', replace(replace(replace(replace(replace(replace(replace(replace(name, ' ', '+'), '!', '%21'), "'", '%27'), '-', '%2D'), '/', '-'), '(', '%28'), ')', '%29'), '&', '%26')) AS URL FROM manufacturers WHERE id = 'BUMPY'