Templates linked from page, by creator edit count

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;

AخA
 
SELECT user_name, user_editcount, CONCAT('[[Template:', tmpl.page_title, ']]')FROM pagelinksJOIN page AS drut ON drut.page_id = pl_fromJOIN page AS tmpl ON tmpl.page_namespace = pl_namespace AND tmpl.page_title = pl_titleJOIN revision ON rev_page = tmpl.page_idJOIN actor_revision ON actor_id = rev_actorJOIN user ON user_id = actor_userWHERE drut.page_namespace = 12 AND drut.page_title = 'Visi_šablonai'  AND tmpl.page_namespace = 10  AND rev_parent_id = 0ORDER BY user_editcount DESC, tmpl.page_title ASC;

SQL

Checking query status...