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
Achim55
.
due to bad encoding
Toggle Highlighting
SQL
USE commonswiki_p; SELECT CONCAT ('* [[:File:', REPLACE (page_title,'_',' '), ']]') AS files FROM page WHERE page_namespace = 6 AND page_is_redirect = 0 AND ( page_title LIKE '%197lsg229rde%' OR page_title LIKE '%197rhus%' OR page_title LIKE '%216lby%' OR page_title LIKE '%216lsted%' OR page_title LIKE '%216resund%' OR page_title LIKE '%216sjs%' OR page_title LIKE '%216stbanen%' OR page_title LIKE '%216sts%' OR page_title LIKE '%asn230s%' OR page_title LIKE '%bahnh246fe%' OR page_title LIKE '%d228nisch%' OR page_title LIKE '%d220wag%' OR page_title LIKE '%fr252her%' OR page_title LIKE '%frederiksv230rk%' OR page_title LIKE '%g252terwagen%' OR page_title LIKE '%gr248nnehave%' OR page_title LIKE '%h216ka%' OR page_title LIKE '%h228lt%' OR page_title LIKE '%h248jstrup%' OR page_title LIKE '%H248ng%' OR page_title LIKE '%Hiller248d%' OR page_title LIKE '%hiller248d%' OR page_title LIKE '%Hj248rring%' OR page_title LIKE '%hj248rring%' OR page_title LIKE '%helsing248r%' OR page_title LIKE '%herf248lge%' OR page_title LIKE '%holb230k%' OR page_title LIKE '%hornb230k%' OR page_title LIKE '%j230lland%' OR page_title LIKE '%k248ge%' OR page_title LIKE '%k248benhavn%' OR page_title LIKE '%laug248%' OR page_title LIKE '%m228rz%' OR page_title LIKE '%n230rum%' OR page_title LIKE '%n230stved%' OR page_title LIKE '%n248rre%' OR page_title LIKE '%nyk248bing%' OR page_title LIKE '%r248dvig%' OR page_title LIKE '%ringk248bing%' OR page_title LIKE '%s248llested%' OR page_title LIKE '%sch246ma%' OR page_title LIKE '%sk230vinge%' OR page_title LIKE '%skjolden230sholm%' OR page_title LIKE '%t248ll248se%' OR page_title LIKE '%t248nder%' OR page_title LIKE '%thybor248n%' OR page_title LIKE '%triebz252ge%' OR page_title LIKE '%vipper248d%' ) #AND page_title REGEXP '\&..?2.\;' GROUP BY page_title LIMIT 1000;
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...