Fork of
AC/DC edits by day
by Jean-Frédéric
This query is marked as a draft
This query has been published
by Jean-Frédéric.
SQL
AخA
USE commonswiki_p;
SELECT actor_name, COUNT(rev_id) as edits
FROM change_tag
JOIN change_tag_def ON ctd_id = ct_tag_id
JOIN revision ON rev_id = ct_rev_id
JOIN page ON page_id = rev_page
JOIN actor_revision ON actor_id = rev_actor
JOIN comment_revision ON comment_id = rev_comment_id
WHERE ctd_name = 'ACDC'
GROUP BY actor_name
ORDER BY edits DESC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.