Templates linked from page, by creator edit count

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 = 4 AND drut.page_title = 'Database_reports/Unused_templates_(filtered)/1'
  AND tmpl.page_namespace = 10
  AND rev_parent_id = 0
ORDER BY user_editcount DESC, tmpl.page_title ASC;

SQL

Checking query status...