Number of recent edits at svwp by users in different groups

SQL

USE svwiki_p;

SELECT NOW() AS Rapporten_körs_UTC;

SELECT ug_group AS Grupp, COUNT(ug_user) AS Antal FROM user_groups
WHERE ug_group IN ('sysop','rollbacker','autopatrolled','bot')
GROUP BY ug_group
ORDER BY ug_group;

SELECT user_groups.ug_group AS Grupp, user.user_name AS Användare, COUNT(recentchanges.rc_id) AS Senaste30d, MAX(recentchanges.rc_timestamp) AS Senaste FROM user_groups 
LEFT OUTER JOIN recentchanges ON user.user_id = recentchanges.rc_user
INNER JOIN user ON user_groups.ug_user = user.user_id
WHERE ug_group IN ('sysop','rollbacker','autopatrolled','bot') AND recentchanges.rc_timestamp>'20170505000000'
GROUP BY ug_group, user_name
ORDER BY ug_group, user_name;
/*
SELECT user.user_name AS Autopatrullerade, COUNT(recentchanges.rc_id) AS Senaste30d, MAX(recentchanges.rc_timestamp) AS Senaste FROM user_groups 
INNER JOIN user ON user_groups.ug_user = user.user_id
LEFT OUTER JOIN recentchanges ON user.user_id = recentchanges.rc_user
WHERE ug_group LIKE 'autopatrolled'
GROUP BY user_name
ORDER BY user_name;

SELECT user.user_name AS Robotar, COUNT(recentchanges.rc_id) AS Senaste30d, MAX(recentchanges.rc_timestamp) AS Senaste FROM user_groups 
INNER JOIN user ON user_groups.ug_user = user.user_id
LEFT OUTER JOIN recentchanges ON user.user_id = recentchanges.rc_user
WHERE ug_group LIKE 'bot'
GROUP BY user_name
ORDER BY user_name;

SELECT user.user_name AS Tillbakarullare, COUNT(recentchanges.rc_id) AS Senaste30d, MAX(recentchanges.rc_timestamp) AS Senaste FROM user_groups 
INNER JOIN user ON user_groups.ug_user = user.user_id
LEFT OUTER JOIN recentchanges ON user.user_id = recentchanges.rc_user
WHERE ug_group LIKE 'rollbacker'
GROUP BY user_name
ORDER BY user_name;

SELECT user.user_name AS Administratörer, COUNT(recentchanges.rc_id) AS Senaste30d, MAX(recentchanges.rc_timestamp) AS Senaste FROM user_groups 
INNER JOIN user ON user_groups.ug_user = user.user_id
LEFT OUTER JOIN recentchanges ON user.user_id = recentchanges.rc_user
WHERE ug_group LIKE 'sysop'
GROUP BY user_name
ORDER BY user_name;
*/
SELECT NOW() AS Rapporten_klar_UTC;
SQL

Checking query status...
