Mean lifetime of reverted revision in featured articles @ ptwiki

SQL

use ptwiki_p;
select avg(HOUR(TIMEDIFF(CAST(r.rev_timestamp AS DATETIME),CAST(rp.rev_timestamp AS DATETIME)))), EXTRACT(MONTH FROM CAST(r.rev_timestamp AS DATETIME)) AS MES, EXTRACT(YEAR FROM CAST(r.rev_timestamp AS DATETIME)) AS ANO 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 WHERE r.rev_timestamp > 20140000000000 and r.rev_sha1  = rpp.rev_sha1 and r.rev_page IN (select distinct cl_from from categorylinks where cl_to = "!Artigos_destacados")
GROUP BY 2,3
ORDER BY 3,2
;

SQL

Checking query status...