Most frequently linked to policies in Article and User Talk Pages

Fork of Most frequently linked to policies in Arbitration Requests by PaigePhault

This query is marked as a draft This query has been published by PaigePhault.

SQL

select pl_title, count(page_title) as refs from page
join pagelinks on page_id = pl_from
where page_namespace = 1 or page_namespace = 3
  and pl_from_namespace = 1 or pl_from_namespace = 3
  and pl_namespace = 4
  and pl_title not like "%/%"  # No subpolicies
group by pl_title
order by refs desc
limit 40

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