Untitled query #67982

SQL

SELECT DISTINCT(CONCAT("Wikipedia:",page_title)) AS title, page_id, actor_name, actor_id, user_editcount, date
FROM (
  	SELECT page_id, page_title, LEFT(rev_timestamp, 8) as date
    FROM page
	JOIN revision ON rev_page = page_id AND rev_parent_id = 0
	WHERE page_namespace = 4
    AND page_title LIKE "Articles_for_deletion/%"
    AND page_title NOT LIKE "Articles_for_deletion/Log/%"
    AND rev_timestamp > date_add(now(), interval -1 day)
) AS AfD
JOIN revision ON rev_page = page_id
JOIN actor ON actor_id = rev_actor
JOIN user ON actor_user = user_id
WHERE user_editcount > 1000
AND NOT EXISTS (SELECT 1 FROM user_groups WHERE user_id=ug_user AND ug_group = 'sysop') -- administrator
AND NOT EXISTS (SELECT 1 FROM user_groups WHERE user_id=ug_user AND ug_group = 'patroller') -- new page patroller
SQL

Checking query status...
