Incubator users (no of "wikis" edited)

SQL

WITH 
	base_table AS (
      SELECT DISTINCT 
        rev_id, 
        rev_actor,
        rev_timestamp, 
        rev_len, 
        rev_parent_id,
        page_namespace, 
        page_id,
        actor_id,
        REGEXP_SUBSTR(page_title, 'W[a-z]/[a-z]+') AS prefix
      FROM 
        revision rev
      JOIN 
        page p
        ON rev.rev_page = p.page_id
      JOIN 
        actor a
        ON rev.rev_actor = a.actor_id
      JOIN
      	user u
      	ON a.actor_user = u.user_id
      LEFT JOIN
      	user_groups ug
      	ON ug.ug_user = u.user_id
      WHERE 
        page_namespace IN (0, 1, 10, 11, 14, 15, 828, 829) AND
      	ug_group NOT IN ("bot") AND
      MONTH(rev_timestamp) = MONTH(NOW()) - 1 AND
      YEAR(rev_timestamp) = YEAR(NOW())
      HAVING 
        prefix <> '')

SELECT *
FROM base_table
SQL

Checking query status...
