SQL
AخA
USE plwiki_p;
SELECT DISTINCT CONCAT("{{Wikipedia:" , page_title , '}}') as page_title
FROM page
JOIN templatelinks ON page_id = tl_from
JOIN categorylinks ON page_id = cl_from
WHERE page_title LIKE 'Poczekalnia/%'
AND page_title NOT LIKE 'Poczekalnia/Załatwione%'
AND page_title NOT LIKE 'Poczekalnia/Zgłoszenia%'
AND page_title NOT LIKE 'Poczekalnia/preload%'
AND page_title NOT LIKE 'Poczekalnia/wstęp'
AND page_title NOT LIKE 'Poczekalnia/archiwa'
AND page_title NOT LIKE 'Poczekalnia/intro'
AND page_title NOT LIKE 'Poczekalnia/podstrona_załatwione'
AND page_title NOT LIKE 'Poczekalnia/Dyskusja_nad_szablonami'
AND page_title NOT LIKE 'Poczekalnia/Kategorie'
AND page_title NOT LIKE 'Poczekalnia/Szablony'
AND page_title NOT LIKE 'Poczekalnia/schowek_na_postacie_fikcyjne'
AND page_namespace = 4
AND NOT EXISTS(
SELECT * FROM templatelinks t1 WHERE page_title = t1.tl_title #AND t1.tl_from_namespace = 4
#LIMIT 1
);
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.