SQL
AخA
SELECT page_title, page_len, COUNT(afl_id) AS afl_count
FROM enwiki_p.page
JOIN enwiki_p.categorylinks ON page_id = cl_from
JOIN enwiki_p.abuse_filter_log ON afl_title = page_title
WHERE cl_to RLIKE '.*([Hh]igh|[Ss]econdary)_schools.*'
AND page_namespace = 0
AND afl_action = 'edit'
AND afl_timestamp > DATE_SUB(NOW(), INTERVAL 1 YEAR)
GROUP BY page_title
ORDER BY COUNT(afl_id) DESC;
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.