AfC daily - Declined then deleted - very ish

SQL

select DATE(rc_timestamp) AS date, SUM(comment_text like "% has been declined (%") + SUM(comment_text like "% has been rejected (%") - SUM(comment_text like "Declining submission:%") - SUM(comment_text like "Rejecting submission:%") as declined_then_deleted
from recentchanges_userindex
left join comment on rc_comment_id = comment_id
where (rc_namespace = 118 or rc_namespace = 2 or rc_namespace = 3) and (rc_type < 5) 
  and (comment_text like "Declining submission:%" or comment_text like "Rejecting submission:%" or comment_text like '% has been declined (%'  or comment_text like '% has been rejected (%')
group by date desc;

SQL

Checking query status...