Тт - Quarry

SQL

use ruwiki_p;
select cast(user_name as char) user_name, user_editcount from user where user_editcount > 5000 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(*) > 0);
SQL

Checking query status...
