Recent Changes 10K

SQL

select rc_timestamp, rc_title, rc_type, rc_source, rc_bot, rc_patrolled, rc_params
	, actor_name
	, comment_text, comment_data -- rc.rc_title
from recentchanges as rc
join comment as c on c.comment_id = rc.rc_comment_id
join actor as a on a.actor_id = rc.rc_actor
-- where rc.rc_namespace = 2 and not (rc_log_type = 'newusers' and rc_log_action = 'create') and rc_bot = 0 -- user page changes; new user creations are not interesting 
-- where rc.rc_namespace = 4 	-- meta changes
-- 	and not rc_title like 'Articles_for_deletion%' and not rc_title like 'WikiProject_Deletion_sorting%'
-- 	and comment_text like 'Undid revision%' -- namespace 4
/*
where rc.rc_namespace = 0	-- default article namespace
 	and rc_bot = 0
    and rc_source <> 'wb' -- wikibase-repo-change -- 'mw.new' = new article creation -- 'mw.edit' = existing article edit
--    and rc_params not like 'a:1:{s:20:"wikibase-repo-change";a:14:%' -- wikibase-repo-change
*/
where rc_type = 0 and comment_text like 'Revert%' -- '% vandalism %' -- '% nonconstructive %' -- '%unconstructive%'
order by rc.rc_id desc limit 10000;
SQL

Checking query status...
