Fork of
Orbarutelud
by Wkentaur
This query is marked as a draft
This query has been published
by Estopedist1.
SQL
AخA
USE etwiki_p;
SELECT
REPLACE(CONCAT('[[{{ns:', p1.page_namespace, '}}:', p1.page_title, ']]'),'_',' ') as talkpage
FROM page AS p1
LEFT JOIN page AS p2
ON p2.page_title = p1.page_title
AND p2.page_namespace = p1.page_namespace-1
WHERE p1.page_title NOT LIKE '%%/%%'
AND p1.page_namespace mod 2 != 0
AND p1.page_namespace NOT IN (3,9)
AND p2.page_id IS NULL;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.