select SUBSTRING(rc_timestamp,1,10) as hour, count(*) as logactions, sum(rc_log_action="delete") as del, sum(rc_log_action="undelete") as undel, sum(rc_log_action="block") as block, sum(rc_log_action="unblock") as unblock, sum(rc_log_action="protect") as protect, sum(rc_log_action="unprotect") as unprotect, sum(rc_log_action="renameuser") as renameuser from recentchanges where rc_log_type IS NOT NULL group by 1;