History of infinite protections

SQL

use ruwiki_p;
select cast(user_name as char) user_name, user_editcount from user where user_editcount>500 and user_name not in (select replace (log_title, '_', ' ') from logging where log_params like '%bot%' or log_params like '%editor%' or log_params like '%sysop%') and user_id in (select rev_user from revision where rev_timestamp > now() - interval 30 day group by rev_user) and user_name not in (select replace (log_title, '_', ' ') from logging where log_action='block' group by log_title having count(*) > 1;

SQL

Checking query status...