Edits to potential Clinton VP picks

SQL

SELECT CONCAT("Edits as of ", NOW());


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;
SQL

Checking query status...
