English Wikipedia recent copyright cleanup editors

SQL

SELECT
	`actor_name` as "Username",
    COUNT(`actor_name`) as `Edits`,
	IF(NOT(so.ug_group IS NULL), "Y", NULL) as "Sysop?",
    IF(NOT(pt.ug_group IS NULL), "Y", NULL) as "Patroller?"
FROM `recentchanges_userindex`
LEFT JOIN `actor_revision` ON `rc_actor` = `actor_id`
JOIN `user` ON `actor_user` = `user_id`
LEFT JOIN user_groups pt ON pt.`ug_user` = `user_id` AND pt.`ug_group` = "patroller"
LEFT JOIN user_groups so ON so.`ug_user` = `user_id` AND so.`ug_group` = "sysop"
WHERE
	`rc_type` IN (0, 1)
    AND `rc_namespace` = 4
    AND (
      	`rc_title` LIKE "Contributor_copyright_investigations%"
        OR `rc_title` LIKE "Copyright_problems%"
        OR `rc_title` LIKE "Media_copyright_questions%"
    )
GROUP BY `actor_name`
ORDER BY `Edits` DESC;
SQL

Checking query status...
