use eswiki_p;

SELECT rc_title page, pr_expiry, count(1) as reverted 

FROM recentchanges rc

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

LEFT JOIN page_restrictions ON pr_page = rc_cur_id

WHERE a.actor_name = 'SeroBOT'

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

    AND rc_type = 0

    AND rc_namespace = 0

GROUP BY 1, 2

HAVING count(1) > 5

ORDER BY 3 DESC, 2

LIMIT 50;