Untitled query #62967

SQL

select distinct ug_group, ug_user, ug_expiry from user_groups WHERE ug_group like 'sysop';
select log_actor, count(*) from logging WHERE log_actor in (select ug_user from user_groups WHERE ug_group like 'sysop') group by log_actor;
select count(*) from logging;
select user_id, user_name from user where user_id in (select ug_user from user_groups WHERE ug_group like 'sysop');
select log_user_text, count(*) from logging WHERE log_user_text in (select user_name from user where user_id in (select ug_user from user_groups WHERE ug_group like 'sysop'))
SQL

Checking query status...
