Most frequently vandalized high school articles

High school articles at the English Wikipedia sorted by the number of times edit filters (abuse filters) have been triggered for each article within the past year. It is assumed that the rate at which edit filters are triggered generally correlates to the prevalence of vandalism in a given article’s revision history.

SQL

USE enwiki_p;
SET @year_ago = DATE_SUB(NOW(), INTERVAL 1 YEAR);
SELECT page_title, page_len, COUNT(DISTINCT afl_id) AS afl_count, gt_lat, gt_lon
FROM page
JOIN categorylinks
	ON page_namespace = 0
    AND page_id = cl_from
JOIN abuse_filter_log
	ON page_namespace = afl_namespace
    AND page_title = afl_title
LEFT JOIN geo_tags
	ON page_id = gt_page_id
WHERE (cl_to LIKE '%igh_schools%' OR cl_to LIKE '%econdary_schools%')
	AND cl_to NOT LIKE 'Former_high_schools%'
	AND afl_action = 'edit'
    AND afl_actions IS NOT NULL
    AND afl_timestamp > @year_ago
    AND (gt_type IS NULL OR gt_type <> 'event')
GROUP BY page_title
ORDER BY afl_count DESC;

SQL

Checking query status...