Orphaned talks on plwiki

This query is marked as a draft This query has been published by The Polish.
SQL

SELECT CONCAT("# [[Dyskusja:",p1.page_title,"]]") AS page_title
FROM page AS p1 WHERE p1.page_title NOT LIKE '%/%' AND p1.page_namespace = 1
AND NOT EXISTS (SELECT 1 FROM page AS p2 WHERE p2.page_namespace = 0 AND p1.page_title = p2.page_title);

SELECT CONCAT("# [[Dyskusja wikipedysty:",p1.page_title,"]]") AS page_title
FROM page AS p1 WHERE p1.page_title NOT LIKE '%/%' AND p1.page_namespace = 3
AND NOT EXISTS (SELECT 1 FROM page AS p2 WHERE p2.page_namespace = 2 AND p1.page_title = p2.page_title);

SELECT CONCAT("# [[Dyskusja Wikipedii:",p1.page_title,"]]") AS page_title
FROM page AS p1 WHERE p1.page_title NOT LIKE '%/%' AND p1.page_namespace = 5
AND NOT EXISTS (SELECT 1 FROM page AS p2 WHERE p2.page_namespace = 4 AND p1.page_title = p2.page_title);

SELECT CONCAT("# [[Dyskusja pliku:",p1.page_title,"]]") AS page_title
FROM page AS p1 WHERE p1.page_title NOT LIKE '%/%' AND p1.page_namespace = 7
AND NOT EXISTS (SELECT 1 FROM page AS p2 WHERE p2.page_namespace = 6 AND p1.page_title = p2.page_title);

SELECT CONCAT("# [[Dyskusja MediaWiki:",p1.page_title,"]]") AS page_title
FROM page AS p1 WHERE p1.page_title NOT LIKE '%/%' AND p1.page_namespace = 9
AND NOT EXISTS (SELECT 1 FROM page AS p2 WHERE p2.page_namespace = 8 AND p1.page_title = p2.page_title);

SELECT CONCAT("# [[Dyskusja szablonu:",p1.page_title,"]]") AS page_title
FROM page AS p1 WHERE p1.page_title NOT LIKE '%/%' AND p1.page_namespace = 11
AND NOT EXISTS (SELECT 1 FROM page AS p2 WHERE p2.page_namespace = 10 AND p1.page_title = p2.page_title);

SELECT CONCAT("# [[Dyskusja pomocy:",p1.page_title,"]]") AS page_title
FROM page AS p1 WHERE p1.page_title NOT LIKE '%/%' AND p1.page_namespace = 13
AND NOT EXISTS (SELECT 1 FROM page AS p2 WHERE p2.page_namespace = 12 AND p1.page_title = p2.page_title);

SELECT CONCAT("# [[Dyskusja kategorii:",p1.page_title,"]]") AS page_title
FROM page AS p1 WHERE p1.page_title NOT LIKE '%/%' AND p1.page_namespace = 15
AND NOT EXISTS (SELECT 1 FROM page AS p2 WHERE p2.page_namespace = 14 AND p1.page_title = p2.page_title);

SELECT CONCAT("# [[Dyskusja portalu:",p1.page_title,"]]") AS page_title
FROM page AS p1 WHERE p1.page_title NOT LIKE '%/%' AND p1.page_namespace = 101
AND NOT EXISTS (SELECT 1 FROM page AS p2 WHERE p2.page_namespace = 100 AND p1.page_title = p2.page_title);

SELECT CONCAT("# [[Dyskusja wikiprojektu:",p1.page_title,"]]") AS page_title
FROM page AS p1 WHERE p1.page_title NOT LIKE '%/%' AND p1.page_namespace = 103
AND NOT EXISTS (SELECT 1 FROM page AS p2 WHERE p2.page_namespace = 102 AND p1.page_title = p2.page_title);

SELECT CONCAT("# [[Dyskusja modułu:",p1.page_title,"]]") AS page_title
FROM page AS p1 WHERE p1.page_title NOT LIKE '%/%' AND p1.page_namespace = 829
AND NOT EXISTS (SELECT 1 FROM page AS p2 WHERE p2.page_namespace = 828 AND p1.page_title = p2.page_title);

SELECT CONCAT("# [[Dyskusja gadżetu:",p1.page_title,"]]") AS page_title
FROM page AS p1 WHERE p1.page_title NOT LIKE '%/%' AND p1.page_namespace = 2301
AND NOT EXISTS (SELECT 1 FROM page AS p2 WHERE p2.page_namespace = 2300 AND p1.page_title = p2.page_title);

SELECT CONCAT("# [[Dyskusja definicji gadżetu:",p1.page_title,"]]") AS page_title
FROM page AS p1 WHERE p1.page_title NOT LIKE '%/%' AND p1.page_namespace = 2303
AND NOT EXISTS (SELECT 1 FROM page AS p2 WHERE p2.page_namespace = 2302 AND p1.page_title = p2.page_title);
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
