User's edits by tag

SQL

#USE commonswiki_p;
SELECT actor.actor_name AS 'User', change_tag_def.ctd_name AS 'Tag', 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'
#WHERE revision_userindex.rev_actor = 2167
AND ctd_name <> ''
#AND ctd_name NOT LIKE 'mw-%'
GROUP BY actor.actor_name, change_tag_def.ctd_name
ORDER BY COUNT(revision_userindex.rev_id) DESC
SQL

Checking query status...
