Reviews for a named editor

SQL

select CONCAT('[[Draft:',page_title,']]') as title
from revision_userindex 
left join actor on rev_actor = actor_id
left join comment_revision 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 = 'Akevsharma'
  and (rev_timestamp >= DATE_ADD(NOW(), INTERVAL -120 DAY) )
  group by page_title
  order by rev_timestamp;
  

select CONCAT('[[Draft:',page_title,']]') as title
from revision_userindex 
left join actor on rev_actor = actor_id
left join comment_revision 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 "%Publishing accepted%"
  and actor_name = 'Akevsharma'
  and (rev_timestamp >= DATE_ADD(NOW(), INTERVAL -120 DAY) )
  group by page_title
  order by rev_timestamp;
SQL

Checking query status...
