Users tabular - Quarry

SQL

use fawiki_p;
select /* SLOW OK */ user_name, max(rev_timestamp) latest, group_concat(distinct ug.ug_group) from user
join user_groups ug on ug.ug_user = user_id
join revision on rev_user = user_id
left join user_groups ug2 on ug2.ug_user = user_id and ug2.ug_group in ('bot')
where ug2.ug_group is null
and ug.ug_group in ('rollbacker', 'patroller', 'eliminator', 'sysop', 'bureaucrat', 'Image-reviewer', 'templateeditor', 'oversight')
group by user_name
having latest < date_format(date_sub(now(), interval 6 month),'%Y%m%d%H%i%s')
SQL

Checking query status...
