User's edits by tag

SQL

#USE wikidatawiki_p;
SELECT
  #actor.actor_name AS 'User', #If you only know the user's actor id, but you want the user's name too
  change_tag_def.ctd_id AS 'Tag id',
  change_tag_def.ctd_name AS 'Tag',
  #actor.actor_id, #If you only know the user's name, but want the actor id too
  COUNT(revision_userindex.rev_id) AS 'Count'
FROM
  revision_userindex
  LEFT JOIN change_tag ON revision_userindex.rev_id = ct_rev_id
  LEFT JOIN change_tag_def ON ct_tag_id = ctd_id
  LEFT JOIN actor ON revision_userindex.rev_actor = actor.actor_id
WHERE
  actor.actor_name = 'DannyS712'
  #AND revision_userindex.rev_actor = 2167
  AND ctd_name <> ''
GROUP BY
  actor.actor_name,
  change_tag_def.ctd_name
ORDER BY
  COUNT(revision_userindex.rev_id) DESC
SQL

Checking query status...
