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
Wurgl
.
Toggle Highlighting
SQL
SELECT P.page_title, replace(pl_title, '_', ' ') FROM page AS P, pagelinks LEFT JOIN page AS R ON R.page_title = pl_title AND R.page_namespace = pl_namespace WHERE CONVERT(pl_title USING utf8mb4) RLIKE "[-–~+&;,:<>§%/]$" # "[-–:;,<>'\"&]$" AND pl_title NOT IN ('Kju:', 'Re:', 'U\\hof:', '36:' /* really: :36:*/, 'Zyklus_:N:', 'Contemporary&', '15&', '1000&', 'Iain_Baxter&', 'Nature&', 'Film+', 'Sorozat+', 'CNN+', 'CDVU+', 'Shōnen_Jump+', 'AJ+', 'Nitro+', 'Ciné+', 'Domo+', 'Hyper+', 'Kuchnia+', 'MiniMini+', 'NSport+', 'Planete+', 'TeleTOON+', 'Cine+' /*gr. vs. fr.*/, 'TV3+', 'Atari_Flashback_2+') AND pl_title NOT LIKE '%_C++' AND pl_title NOT LIKE '%_v._Chr.' AND pl_title NOT LIKE '%_Jr.' AND pl_title NOT LIKE '%_Sr.' AND pl_title NOT LIKE '%_Ltd.' AND pl_title NOT LIKE '%_Inc.' AND pl_title NOT LIKE '%_Co.' AND pl_title NOT LIKE '%_I.' AND pl_title NOT LIKE '%_II.' AND pl_title NOT LIKE '%_III.' AND pl_title NOT LIKE '%_IV.' AND pl_title NOT LIKE '%_V.' AND pl_title NOT LIKE '%_VI.' AND pl_title NOT LIKE '%_VII.' AND R.page_title IS NULL AND P.page_id = pl_from AND pl_namespace = 0 AND pl_from_namespace = 0
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...