User's edits by tag

SQL

# use simplewiki_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 <> ''
GROUP BY change_tag_def.ctd_name
ORDER BY COUNT(revision_userindex.rev_id) DESC
SQL

Checking query status...
