AfC deleted declined/rejected reviews, last month

SQL

select 'deleted', ar_title, comment_text
from recentchanges_userindex
left join revision on rc_this_oldid = rev_id
left join comment on rc_comment_id = comment_id
where (rc_namespace = 118 or rc_namespace = 2) and (rc_type < 5) 
  and (comment_text like "Declining submission:%" or comment_text like "Rejecting submission:%" or comment_text like "%Publishing accepted%")
  and rc_actor in (Select actor_id from actor where actor_name = 'Pahunkat');


select 'live', page_title , comment_text
from recentchanges_userindex
left join page on rc_this_oldid = page_id
left join comment on rc_comment_id = comment_id
where (rc_namespace = 118 or rc_namespace = 2) and (rc_type < 5) 
  and (comment_text like "Declining submission:%" or comment_text like "Rejecting submission:%" or comment_text like "%Publishing accepted%")
  and rc_actor in (Select actor_id from actor where actor_name = 'Pahunkat');
SQL

Checking query status...
