Main pl.wiki query 3

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

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 '%/%';

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.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
