Тт - Quarry

SQL

use ruwiki_p;
select cast(user_name as char) user_name, user_id, user_editcount from user where user_editcount > 10000 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 (select count(*) from logging where replace (log_title, '_', ' ')=user_name and log_namespace=2 and log_action = "block" < 3);
SQL

Checking query status...
