Redirects with more than one internal link on cswiki

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.

SQL

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;

AخA
 
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 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.

SQL

Checking query status...