View List of Changes by Author
Question: How can I get a list of Wiki changes by author?
Answer: You can use this query snippet:
SELECT DISTINCT p.page_name, p.page_namespace
FROM exp_wiki_page p, exp_wiki_revisions r
WHERE p.page_id = r.page_id
AND r.revision_author = '_author_id_in_here_'
ORDER BY p.last_updated