SHOW:
|
|
- or go back to the newest paste.
| 1 | SELECT | |
| 2 | p.title AS title, | |
| 3 | - | CONCAT(n.title, ": ") AS namespace, |
| 3 | + | IF(:namespace IS NULL, CONCAT(n.title, ": "), "") AS namespace, |
| 4 | REPLACE(CONCAT(p.namespace, "::", p.title), " ", "_") AS url | |
| 5 | FROM rwpg_pages p | |
| 6 | - | JOIN rwpg_namespaces n ON p.namespace = n.name |
| 6 | + | JOIN rwpg_namespaces n ON p.namespace = n.name -- pobiera tytuł przestrzeni z zewnętrznej tabeli |
| 7 | WHERE :namespace IS NULL OR p.namespace = :namespace -- wyświetla wszystkie strony jeżeli nie podano przestrzeni nazw | |
| 8 | GROUP BY n.title, p.title | |
| 9 | ORDER BY n.title, p.title |
