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 FROM page, templatelinks WHERE tl_from_namespace = 1 AND tl_namespace = 10 AND page_id = tl_from AND tl_title IN ('Enkenbach-Alsenborn_(1972-2014)','Gmina_Głębokie_(1921-1939)','Gmina_Osiek_(1867-1954)','Gmina_Postawy_(1921-1939)','Gmina_Tursko_(1867-1954)','Gmina_związkowa_Loreley_(1972-2012)','Gmina_związkowa_Traben-Trarbach_(1968-2014)','Meklemburgia-Pomorze_Przednie_(1994-2011)','Powiat_Rügen_(1990-2011)','Rząd_Tymczasowy_Królestwa_Polskiego_(1831-1832)','Urząd_Crivitz_(1992-2013)','Urząd_Unterspreewald_(1992-2012)','Waldsee_(1972-2014)','Wittlich-Land_(1968-2014)','Województwo_radomskie_(1975-1998)','Województwo_śląskie_(1920-1939)','Wojna_chińsko-japońska_(1894-1895)','Wojsko_Polskie_na_Wschodzie_(1914-1920)','Władcy_Bułgarii_(1878-1946)') 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...