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
MRDBurroughs
.
Toggle Highlighting
SQL
SELECT p.page_title, target.page_title, COUNT(p.page_title) FROM page AS p, page AS target, redirect as r WHERE p.page_id = r.rd_from AND target.page_namespace = r.rd_namespace AND target.page_title = r.rd_title AND target.page_namespace = 0 AND p.page_namespace = 0 AND p.page_is_redirect = 1 # AND NOT p.page_title REGEXP '^[-a-zA-Z!_ ‼]+$' # AND p.page_title regexp '[ĀāĀ́ā́Ā̀ā̀Ā̂ā̂Ā̃ā̃ǞǟĀ̈ā̈ǠǡA̱a̱Å̄å̄ǢǣB̄b̄ḆḇC̄c̄C̱c̱D̄d̄ḎḏĒēḖḗḔḕĒ̂ē̂Ē̃ē̃Ê̄ê̄E̱e̱Ë̄ë̄E̊̄e̊̄F̄f̄ḠḡG̱g̱H̱ẖĪīĪ́ī́Ī̀ī̀Ī̂ī̂Ī̃ī̃I̱i̱J̄j̄J̱j̱ḴḵL̄l̄ḸḹḺḻM̄m̄M̱m̱N̄n̄ṈṉŌōṒṓṐṑŌ̂ō̂Ō̃ō̃ȪȫŌ̈ō̈ǬǭȬȭȰȱO̱o̱Ø̄ø̄Œ̄œ̄P̄p̄P̱p̱Q̄q̄R̄r̄ṞṟṜṝS̄s̄S̱s̱T̄t̄ṮṯŪūŪ́ū́Ū̀ū̀Ū̂ū̂Ū̃ū̃U̇̄u̇̄ǕǖṺṻṲ̄ṳ̄U̱u̱V̄v̄W̄w̄X̄x̄X̱x̱ȲȳȲ́ȳ́Ȳ̀ȳ̀Ȳ̃ȳ̃Y̱y̱Z̄z̄ẔẕᾹᾱĒῙῑῩῡа̄ӢӣӮӯ]' AND p.page_title REGEXP '^[^ -~]+$' AND NOT target.page_title REGEXP '^[^ -~]+$' LIMIT 100
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...