/doc subpages in cswiki

Fork of Templates with Doc template and no subpage by Martin Urbanec

This query is marked as a draft This query has been published by Matěj Suchánek.

SQL

USE cswiki_p;
SELECT * FROM page AS temps
JOIN (SELECT * FROM templatelinks WHERE tl_title = "Dokumentace" AND tl_namespace = 10) AS tlinks ON tl_from = page_id
WHERE page_namespace = 10
AND NOT EXISTS (SELECT * FROM page AS docs WHERE docs.page_namespace = 10 AND docs.page_title = CONCAT(temps.page_title, "/doc"))
ORDER BY page_title;

SELECT * FROM page AS temps
LEFT JOIN (SELECT * FROM templatelinks WHERE tl_title = "Dokumentace" AND tl_namespace = 10) AS tlinks ON tl_from = page_id
WHERE page_namespace = 10
AND tl_from IS NULL
AND EXISTS (SELECT * FROM page AS docs WHERE docs.page_namespace = 10 AND docs.page_title = CONCAT(temps.page_title, "/doc"))
ORDER BY page_title;

SQL

Checking query status...