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
  AND rev_parent_id = 0
ORDER BY user_editcount DESC, tmpl.page_title ASC;

SQL

Checking query status...