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, 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 gt_type <=> 'event'
    AND afl_timestamp > @year_ago
GROUP BY page_title
ORDER BY afl_count DESC;
SQL

Checking query status...
