SQL
AخA
use eswiki_p;
SELECT rc_title page, pr_expiry, count(1) as reverted
FROM recentchanges rc
INNER JOIN change_tag ON rc_id = ct_rc_id
LEFT JOIN page_restrictions ON pr_page = rc_cur_id
WHERE ct_tag_id = 6
AND rc_timestamp BETWEEN date_add(now(), INTERVAL -6 HOUR) AND NOW()
AND rc_type = 0
AND rc_namespace = 0
GROUP BY 1, 2
ORDER BY 3 DESC, 2
LIMIT 50;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.