Uncategorized pages on plwiki

SQL

SELECT CONCAT('# [[:Wikipedia:',page_title,']]') AS page_title
FROM page LEFT OUTER JOIN categorylinks ON cl_from = page_id
WHERE cl_from IS NULL AND page_namespace = 4 AND page_is_redirect = 0 AND page_title NOT LIKE '%/%';

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

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

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

Checking query status...
