English Wikipedia recent copyright cleanup editors

SQL

SELECT
	`actor_name` as "Username",
    COUNT(`actor_name`) as `Edits`,
	IF(NOT(so.ug_group IS NULL), "sysop", 
       IF(NOT(pt.ug_group IS NULL), "patroller", 
          IF(NOT(xc.ug_group IS NULL), "extendedconfirmed", 
            IF(NOT(bt.ug_group IS NULL), "bot", "")))) as "UG",
    COUNT(IF(`rc_title` LIKE "Contributor_copyright_investigations%", 1, NULL)) as `CCI`,
    COUNT(IF(`rc_title` LIKE "Copyright_problems%", 1, NULL)) as `CPN`,
    COUNT(IF(`rc_title` LIKE "Media_copyright_questions%", 1, NULL)) as `MCQ`
FROM `recentchanges_userindex`
LEFT JOIN `actor_revision` ON `rc_actor` = `actor_id`
JOIN `user` ON `actor_user` = `user_id`
LEFT JOIN user_groups bt ON bt.`ug_user` = `user_id` AND bt.`ug_group` = "bot"
LEFT JOIN user_groups xc ON xc.`ug_user` = `user_id` AND xc.`ug_group` = "extendedconfirmed"
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...
