SELECT
    p.title AS title,
    CONCAT(n.title, ": ") AS namespace,
    REPLACE(CONCAT(p.namespace, "::", p.title), " ", "_") AS url
FROM rwpg_pages p
JOIN rwpg_namespaces n ON p.namespace = n.name
GROUP BY n.title, p.title
ORDER BY n.title, p.title