Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Whym
.
Toggle Highlighting
SQL
SELECT rc_timestamp,rc_this_oldid AS oldid, rc_new_len-rc_old_len AS diff_len, actor_name, rc_title, comment_text FROM recentchanges_userindex JOIN actor ON rc_actor = actor_id JOIN comment ON rc_comment_id = comment_id WHERE actor_user IN (SELECT user_id FROM user where user_id > (select user_id from user where user_registration >= regexp_replace(date_sub(now(), interval 2 month), '[-: ]', '') and user_name not like '%bot' limit 1) ) AND actor_name NOT LIKE "%bot" AND ((rc_new_len - rc_old_len > 1000 or (rc_new_len - rc_old_len > -10 and length(substr(comment_text, locate('*/',comment_text)+1)) > 30 and locate('[[WP:AES|',comment_text)=0)) AND locate('[[Special:Contributions',comment_text)=0) and locate('[[Category:',comment_text)!=1 and rc_new_len > 1400 and rc_namespace = 0 ORDER BY rc_timestamp DESC LIMIT 300;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...