Untitled query #87084

SQL

USE commonswiki_p;

SELECT 
    CASE 
        WHEN ug_group = 'sysop' THEN 'Administrator'
        WHEN ug_group = 'image-reviewer' THEN 'License Reviewer'
        ELSE 'Other'
    END AS user_type,
    actor_name AS user,
    COUNT(recentchanges.rc_id) AS actions_count
FROM recentchanges
JOIN actor ON recentchanges.rc_actor = actor.actor_id
INNER JOIN 
    (
        SELECT ug_user, ug_group
        FROM user_groups
        WHERE ug_group IN ('sysop', 'image-reviewer')
    ) AS ug ON actor.actor_user = ug.ug_user
WHERE recentchanges.rc_namespace = 6
AND (
      recentchanges.rc_comment LIKE '%icense review%' 
      OR recentchanges.rc_comment LIKE '%LR passed%'
      OR recentchanges.rc_comment LIKE '%: passed%'
     )
GROUP BY user_type, user
ORDER BY user_type, actions_count DESC;
LIMIT 500;
SQL

Checking query status...
