Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Osteuropäische Ligaturen in Blau- und Rotlinks
by
Wurgl
This query is marked as a draft
This query has been published
by
Wurgl
.
Toggle Highlighting
SQL
USE dewiki_p; SELECT page_title AS "von Seite", pl_title AS "Link auf Seite" FROM page, pagelinks WHERE page_id = pl_from AND pl_from_namespace = 0 AND ( pl_title LIKE "%DŽ%" OR pl_title LIKE "%dž%" OR pl_title LIKE "%Dž%" OR pl_title LIKE "%DZ%" OR pl_title LIKE "%Dz%" OR pl_title LIKE "%dz%" OR pl_title LIKE "%LJ%" OR pl_title LIKE "%Lj%" OR pl_title LIKE "%lj%" OR pl_title LIKE "%NJ%" OR pl_title LIKE "%Nj%" OR pl_title LIKE "%nj%" OR pl_title LIKE "%IJ%" OR pl_title LIKE "%ij%" /* OR pl_title LIKE "%Œ%" OR pl_title LIKE "%œ%" */ OR pl_title LIKE "%ff%" OR pl_title LIKE "%fi%" OR pl_title LIKE "%fl%" OR pl_title LIKE "%ffi%" OR pl_title LIKE "%ffl%" OR pl_title LIKE "%ſt%" OR pl_title LIKE "%st%" ) AND pl_title NOT IN ( "DŽ", "dž%", "Dž", "DZ", "Dz", "dz", "LJ", "Lj", "lj", "NJ", "Nj", "nj", "IJ", "ij", /*"Œ", "œ",*/ "ff", "fi", "fl", "ffi", "ffl", "ſt", "st")
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...