AfC review total counts, last month

SQL

use enwiki_p;

select DATE(rev_timestamp) AS date,count(rev_id) as reviews, SUM(comment_text like "%Publishing accepted%") as accepts,
                                                             SUM(comment_text like "Declining submission:%") as declines,
                                                             SUM(comment_text like "Rejecting submission:%") as rejects
from revision
left join comment on revcomment_comment_id = comment_id
where (rev_actor = 262)
  and (comment_text like "Declining submission:%" or comment_text like "Rejecting submission:%" or comment_text like "%Publishing accepted%")
group by date desc;
SQL

Checking query status...
