use eswiki_p;

SELECT rc_title page, count(1) as reverted 

FROM recentchanges rc

INNER JOIN actor a ON rc.rc_actor = a.actor_id

INNER JOIN page ON rc_page_id = page_id

WHERE a.actor_name = 'SeroBOT'

    AND rc_timestamp BETWEEN date_add(rc_timestamp, INTERVAL -25 HOUR) AND NOW()

    AND rc_type = 0

    AND page_namespace = 0

GROUP BY 1

HAVING count(1) > 2

ORDER BY 2

LIMIT 50;