Templates linked from page, by creator edit count

Fork of Templates linked from page, by creator edit count by Cryptic

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

Templates linked from [[Wikipedia:Database reports/Unused templates (filtered)/1]], with their creators and their edit counts.

For [[WP:RAQ#Unused templates created by users with more than 10000 edits, sort by the number of edits by the creator]] circa 23 May 2023.

SQL

SELECT user_name, user_editcount, CONCAT('[[Template:', tmpl.page_title, ']]')
FROM pagelinks
JOIN page AS drut ON drut.page_id = pl_from
JOIN page AS tmpl ON tmpl.page_namespace = pl_namespace AND tmpl.page_title = pl_title
JOIN revision ON rev_page = tmpl.page_id
JOIN actor_revision ON actor_id = rev_actor
JOIN user ON user_id = actor_user
WHERE drut.page_namespace = 12 AND drut.page_title = 'Visi šablonai'
  AND tmpl.page_namespace = 10
ORDER BY user_editcount DESC, tmpl.page_title ASC;

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