Replicas browser and optimizer
This query is marked as a draft
This query has been published
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.
select page_id, page_namespace, page_title, (select count(*) from cswiki_p.pagelinks where pl_from = page_id) as linkcount from cswiki_p.page where page_is_redirect = 1 having linkcount > 1 order by linkcount;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in