Untitled query #29523

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
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
WHERE (cl_to LIKE '%igh_schools%' OR cl_to LIKE '%econdary_schools%')
	AND cl_to NOT LIKE 'Former_%_schools%'
	AND afl_action = 'edit'
    AND afl_actions IS NOT NULL
    AND afl_timestamp > @year_ago
GROUP BY page_title
ORDER BY afl_count DESC;
SQL

Checking query status...
