Number of edits at svwp by users in different groups

SQL

USE svwiki_p;

SELECT DISTINCT ug_group FROM user_groups
LIMIT 100;
SELECT * FROM user_groups
LIMIT 200;

/*
SELECT user.user_name AS Användare, COUNT(recentchanges.rc_id) AS Antal, MIN(recentchanges.rc_timestamp) AS Första, MAX(recentchanges.rc_timestamp) AS Senaste FROM user_groups #recentchanges.rc_title, recentchanges.rc_timestamp FROM user_groups 
INNER JOIN user ON user_groups.ug_user = user.user_id
INNER JOIN recentchanges ON user.user_id = recentchanges.rc_user
WHERE ug_group LIKE 'sysop' #'rollbacker' #'autopatrolled'
GROUP BY user_name
ORDER BY user_name
LIMIT 100
*/
/*
SELECT user.user_name AS Användare, COUNT(revision.rev_id) AS Antal, MIN(revision.rev_timestamp) AS Första, MAX(revision.rev_timestamp) AS Senaste FROM user_groups #recentchanges.rc_title, recentchanges.rc_timestamp FROM user_groups 
INNER JOIN user ON user_groups.ug_user = user.user_id
INNER JOIN revision ON user.user_id = revision.rev_user
WHERE ug_group LIKE 'sysop' # 'rollbacker' #'autopatrolled'
GROUP BY user_name
ORDER BY user_name
LIMIT 100
*/
SQL

Checking query status...
