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

WHERE a.actor_name = 'SeroBOT'

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

    AND rc_type = 0

    AND rc_namespace = 0

GROUP BY 1

HAVING count(1) > 2

ORDER BY 2 DESC

LIMIT 50;