Yuvipanda's untitled query #1407513624

SQL

use jawiki_p;
select rc_timestamp,rc_this_oldid as oldid,rc_new_len-rc_old_len as diff,substr(rc_user_text,1,30) as user,substr(rc_title,1,40),substr(rc_comment,1,40) from recentchanges_userindex where rc_user in (select user_id from user where user_id > (select user_id from user where user_registration >= (select replace(replace(replace(date_sub(now(), interval 2 month), '-', ''), ':', ''), ' ', '')) and user_name not like '%bot' limit 1) ) and rc_user_text not like "%bot" and ((rc_new_len - rc_old_len > 600 or (rc_new_len - rc_old_len > -10 and length(substr(rc_comment, locate('*/',rc_comment)+1)) > 30  and  locate('[[WP:AES|',rc_comment)=0)) and locate('[[Special:Contributions',rc_comment)=0) and locate('[[Category:',rc_comment)!=1 and rc_new_len > 1400 and rc_namespace = 0 order by rc_timestamp desc limit 100;
SQL

Checking query status...
