SQL
x
SELECT CONCAT("# [[",page_title,"]]") AS page_title
FROM page
WHERE page_namespace = 0 AND page_len = 0;
SELECT CONCAT("# [[Wikipedia:",page_title,"]]") AS page_title
FROM page
WHERE page_namespace = 4 AND page_len = 0 AND page_title NOT LIKE '%sprawozdanie%';
SELECT CONCAT("# [[Pliku:",page_title,"]]") AS page_title
FROM page
WHERE page_namespace = 6 AND page_len = 0;
SELECT CONCAT("# [[MediaWiki:",page_title,"]]") AS page_title
FROM page
WHERE page_namespace = 8 AND page_len = 0 AND page_title NOT LIKE '%1-description' AND page_title NOT LIKE '%notice';
SELECT CONCAT("# [[Szablon:",page_title,"]]") AS page_title
FROM page
WHERE page_namespace = 10 AND page_len = 0;
SELECT CONCAT("# [[Pomoc:",page_title,"]]") AS page_title
FROM page
WHERE page_namespace = 12 AND page_len = 0;
SELECT CONCAT("# [[Kategoria:",page_title,"]]") AS page_title
FROM page
WHERE page_namespace = 14 AND page_len = 0;
SELECT CONCAT("# [[Portal:",page_title,"]]") AS page_title
FROM page
WHERE page_namespace = 100 AND page_len = 0;
SELECT CONCAT("# [[Wikiprojekt:",page_title,"]]") AS page_title
FROM page
WHERE page_namespace = 102 AND page_len = 0 AND page_title NOT LIKE '%disambigów%';
SELECT CONCAT("# [[Moduł:",page_title,"]]") AS page_title
FROM page
WHERE page_namespace = 828 AND page_len = 0;
SELECT CONCAT("# [[Gadżet:",page_title,"]]") AS page_title
FROM page
WHERE page_namespace = 2300 AND page_len = 0;
SELECT CONCAT("# [[Definicja gadżetu:",page_title,"]]") AS page_title
FROM page
WHERE page_namespace = 2302 AND page_len = 0;
SELECT CONCAT("# [[Dyskusja:",page_title,"]]") AS page_title
FROM page
WHERE page_namespace = 1 AND page_len = 0;
SELECT CONCAT("# [[Dyskusja Wikipedii:",page_title,"]]") AS page_title
FROM page
WHERE page_namespace = 5 AND page_len = 0;
SELECT CONCAT("# [[Dyskusja pliku:",page_title,"]]") AS page_title
FROM page
WHERE page_namespace = 7 AND page_len = 0;
SELECT CONCAT("# [[Dyskusja MediaWiki:",page_title,"]]") AS page_title
FROM page
WHERE page_namespace = 9 AND page_len = 0;
SELECT CONCAT("# [[Dyskusja szablonu:",page_title,"]]") AS page_title
FROM page
WHERE page_namespace = 11 AND page_len = 0;
SELECT CONCAT("# [[Dyskusja pomocy:",page_title,"]]") AS page_title
FROM page
WHERE page_namespace = 13 AND page_len = 0;
SELECT CONCAT("# [[Dyskusja kategorii:",page_title,"]]") AS page_title
FROM page
WHERE page_namespace = 15 AND page_len = 0;
SELECT CONCAT("# [[Dyskusja portalu:",page_title,"]]") AS page_title
FROM page
WHERE page_namespace = 101 AND page_len = 0;
SELECT CONCAT("# [[Dyskusja wikiprojektu:",page_title,"]]") AS page_title
FROM page
WHERE page_namespace = 103 AND page_len = 0;
SELECT CONCAT("# [[Dyskusja modułu:",page_title,"]]") AS page_title
FROM page
WHERE page_namespace = 829 AND page_len = 0;
SELECT CONCAT("# [[Dyskusja gadżetu:",page_title,"]]") AS page_title
FROM page
WHERE page_namespace = 2301 AND page_len = 0;
SELECT CONCAT("# [[Dyskusja definicji gadżetu:",page_title,"]]") AS page_title
FROM page
WHERE page_namespace = 2303 AND page_len = 0;
SELECT CONCAT('# [[:Plik:',page_title,']]') AS page_title
FROM page LEFT OUTER JOIN categorylinks ON cl_from = page_id
WHERE cl_from IS NULL AND page_namespace = 6 AND page_is_redirect = 0 AND page_title NOT LIKE '%/%';
SELECT CONCAT('# [[:Szablon:',page_title,']]') AS page_title
FROM page LEFT OUTER JOIN categorylinks ON cl_from = page_id
WHERE cl_from IS NULL AND page_namespace = 10 AND page_is_redirect = 0 AND page_title NOT LIKE '%/%' AND page_title NOT LIKE '%.css%';
SELECT CONCAT('# [[:Pomoc:',page_title,']]') AS page_title
FROM page LEFT OUTER JOIN categorylinks ON cl_from = page_id
WHERE cl_from IS NULL AND page_namespace = 12 AND page_is_redirect = 0 AND page_title NOT LIKE '%/%' AND page_title NOT LIKE '%Wikipedię%' AND page_title NOT LIKE '%Obliczenia%' AND page_title NOT LIKE '%Przesyłanie%';
SELECT CONCAT('# [[:Kategoria:',page_title,']]') AS page_title
FROM page LEFT OUTER JOIN categorylinks ON cl_from = page_id
WHERE cl_from IS NULL AND page_namespace = 14 AND page_is_redirect = 0 AND page_title NOT LIKE '%/%' AND page_title NOT LIKE 'Kategorie';
SELECT CONCAT('# [[:Portal:',page_title,']]') AS page_title
FROM page LEFT OUTER JOIN categorylinks ON cl_from = page_id
WHERE cl_from IS NULL AND page_namespace = 100 AND page_is_redirect = 0 AND page_title NOT LIKE '%/%';
SELECT CONCAT('# [[:Wikiprojekt:',page_title,']]') AS page_title
FROM page LEFT OUTER JOIN categorylinks ON cl_from = page_id
WHERE cl_from IS NULL AND page_namespace = 102 AND page_is_redirect = 0 AND page_title NOT LIKE '%/%';
SELECT CONCAT('# [[:Gadżet:',page_title,']]') AS page_title
FROM page LEFT OUTER JOIN categorylinks ON cl_from = page_id
WHERE cl_from IS NULL AND page_namespace = 2300 AND page_is_redirect = 0 AND page_title NOT LIKE '%/%';
SELECT CONCAT('# [[:Definicja gadżetu:',page_title,']]') AS page_title
FROM page LEFT OUTER JOIN categorylinks ON cl_from = page_id
WHERE cl_from IS NULL AND page_namespace = 2302 AND page_is_redirect = 0 AND page_title NOT LIKE '%/%';
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 Wikipedii:",p1.page_title,"]]") AS page_title
FROM page AS p1 WHERE p1.page_title NOT LIKE '%/%' AND p1.page_namespace = 5 AND page_title NOT LIKE '%Propozycja%' AND page_title NOT LIKE '%Nazewnictwo%' AND page_title NOT LIKE '%Kategorie%'
AND NOT EXISTS (SELECT 1 FROM page AS p2 WHERE p2.page_namespace = 4 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.
All SQL code is licensed under CC0 License.