select DATE_FORMAT(rc_timestamp, "%Y-%m-%d") as day, sum(rc_title = "Tim_Kaine") as kaine, sum(rc_title = "Elizabeth_Warren") as warren,

sum(rc_title = "Tom_Vilsack") as vilsack, sum(rc_title = "Thomas_Perez") as perez, sum(rc_title = "Julian_Castro") as castro,

sum(rc_title = "John_Hickenlooper") as hickenlooper, sum(rc_title = "James_Stavridis") as stavridis, 

sum(rc_title = "Cory Booker") as booker, sum(rc_title = "Sherrod_Brown") as brown,

count(*) as total

from recentchanges

where rc_namespace = 0

AND rc_title IN ("Tim_Kaine", "Tom_Vilsack", "Elizabeth_Warren", "Thomas_Perez", "Julian_Castro", "John_Hickenlooper", "James_Stavridis", "Cory Booker", "Sherrod_Brown")

GROUP BY day;

​

SELECT NOW() as query_last_run_at, "utc" as timezone;