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
Blahma
.
Redirect pages that contain more than one internal link (i.e. the target of the redirect) might be broken in various ways, because the other links will never be seen by a user (unless they explicitely want to see the redirect page itself). Pages that result from this query should be inspected manually and problematic issues should be fixed.
Toggle Highlighting
SQL
select page_id, page_namespace, page_title, (select count(*) from pagelinks where pl_from = page_id) as linknumber from cswiki_p.page where page_is_redirect = 1 having linknumber > 1 order by linknumber;
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...