Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- p.title AS title,
- IF(:namespace IS NULL, 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 -- pobiera tytuł przestrzeni z zewnętrznej tabeli
- WHERE :namespace IS NULL OR p.namespace = :namespace -- wyświetla wszystkie strony jeżeli nie podano przestrzeni nazw
- GROUP BY n.title, p.title
- ORDER BY n.title, p.title
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement