Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
The Polish
.
Toggle Highlighting
SQL
USE plwiki_p; SELECT CONCAT("[[",page_title,"]]") AS page_title, COUNT(*) FROM page, pagelinks WHERE pl_from_namespace = 10 AND pl_namespace = 0 AND page_id = pl_from AND page_title IN ( 'Powiat_Blansko', 'Powiat_Chomutov', 'Powiat_Czeska_Lipa', 'Powiat_Havlíčkův_Brod', 'Powiat_Karlowe_Wary', 'Powiat_Klatovy', 'Powiat_Litomierzyce', 'Powiat_Louny', 'Powiat_Most', 'Powiat_Pelhřimov', 'Powiat_Pilzno_Północ', 'Powiat_Prachatice', 'Powiat_Przybram', 'Powiat_Písek', 'Powiat_Rakovník', 'Powiat_Strakonice', 'Powiat_Svitavy', 'Powiat_Tachov', 'Powiat_Třebíč', 'Powiat_Uście_nad_Orlicą', 'Powiat_Vyškov', 'Powiat_Zdziar_nad_Sazawą' ) AND NOT EXISTS (SELECT * FROM page AS p1 WHERE p1.page_namespace = pl_namespace AND p1.page_title = pl_title) GROUP BY page_title ORDER BY page_title ASC;
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
.
Checking query status...