Users active in Village_pump and Discussions

SQL

SELECT actor_name, rev_timestamp
FROM revision
JOIN page ON page_id = rev_page
JOIN actor_revision ON actor_id = rev_actor
JOIN user ON actor_user = user_id
WHERE page_namespace IN (4, 5)
  AND page_title LIKE 'Village\_pump%'
  AND (page_title NOT LIKE '%rchive%'
       OR page_title = 'Village_pump_archive_2004-09-26')
AND user_editcount = 1

and actor_name not like "%Bot%"
and actor_name not like "%bot%"
and actor_name not like "%Awb%"
and actor_name not like "%AWB%"
                      group by actor_name)
                      -- having count(rev_actor) >99
WHERE user_editcount >= 1
AND edits_after >= "1"
ORDER BY edits_after DESC

SQL

Checking query status...