Reviews for a named editor

SQL

select CONCAT('[[Draft:',rev_title,']]') as title, comment_text
from revision
left join actor on rev_actor = actor_id
left join comment on rev_comment_id = comment_id
where (rev_namespace = 118 or rev_namespace = 2) and (rev_type < 5) 
  and (comment_text like "Declining submission:%" or comment_text like "Rejecting submission:%" or comment_text like "%Publishing accepted%")
  and actor_name = 'Félix An'
  group by rev_title
  order by rev_timestamp;
  
/*select CONCAT('[[Draft:',rc_title,']]') as title, comment_text
from recentchanges_userindex
left join actor on rc_actor = actor_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 actor_name = 'Félix An'
  group by rc_title
  order by rc_timestamp;*/
SQL

Checking query status...
