use ptwiki_p;

​

SELECT from_unixtime(UNIX_TIMESTAMP(SUBSTR(r.rev_timestamp, 1, 8)), '%Y-%m-%d') dia,

count(*) as revertidas

​

FROM revision r INNER JOIN revision rp ON  r.rev_parent_id = rp.rev_id  INNER JOIN revision rpp ON rp.rev_parent_id = rpp.rev_id INNER JOIN page 

ON r.rev_page = page_id

WHERE r.rev_sha1  = rpp.rev_sha1

AND page_title = "Rodrigo_Maia"

AND  page_namespace = 0

 GROUP BY dia

 ORDER BY dia;