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

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_title NOT LIKE 'Poczekalnia/naprawa_załatwione_24'
AND page_title NOT LIKE 'Poczekalnia/naprawa'
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.

Checking query status...