Reviews for a named editor

SQL

select CONCAT('[[Draft:',page_title,']]') as title, comment_text
from revision_userindex 
left join actor on rev_actor = actor_id
left join comment on rev_comment_id = comment_id
left join page on rev_page = page_id
where (page_namespace = 118 or page_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'
  and (rev_timestamp >= DATE_ADD(NOW(), INTERVAL -7 DAY) )
  group by page_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...
