Replicas browser and optimizer
This query is marked as a draft
This query has been published
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.
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;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Propose a Feature
Report a bug
Wikimedia Cloud VPS
, written in