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 

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 IN ('sysop','rollbacker','autopatrolled','bot') 

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 = '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 = '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 = '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 = 'sysop'

GROUP BY user_name

ORDER BY user_name;

​

SELECT NOW() AS Rapporten_klar_UTC;