Early patrollers

SQL

use ruwiki_p;
select max(rev_timestamp), rev_user
from revisions
group by rev_user
having max(rev_timestamp) > (now() - interval 90 day);
#select rev_timestamp from revision join user on user_id=rev_user where user_name in (select cast(user_name as char) user_name from user left join ipblocks on user_id = ipb_user where (user_editcount > 5000 and (ipb_expiry is null or ipb_expiry <> 'infinity') and user_id not in (select ug_user from user_groups where ug_group in ('autoeditor', 'editor', 'sysop')) and user_name not in (select replace (log_title, '_', ' ') from logging where log_params like '%bot%' or log_params like '%editor%'))) order by rev_timestamp desc limit 1
SQL

Checking query status...
