enwiki: Editors of WikiProject Archaeology articles

Fork of enwiki: Revisions to WikiProject Archaeology articles by Joe Roe

This query is marked as a draft This query has been published by Joe Roe.

Lists unique actors (registered users and IPs) that have made edits to articles tagged as of interest to WikiProject Archaeology (excluding redirects).

SQL

USE enwiki_p;

/* 
-- pa_project_id for WikiProject Archaeology:
SELECT pap_project_id FROM page_assessments_projects WHERE pap_project_title = "Archaeology");
-- 406
*/

SELECT
  actor.actor_id,
  actor.actor_name,
  user.user_id,
  user.user_name,
  user.user_real_name,
  user.user_touched,
  user.user_editcount
FROM
  actor
  LEFT JOIN user ON user.user_id = actor.actor_user
WHERE
  actor.actor_id IN (
    SELECT
      DISTINCT rev_actor
    FROM
      revision
    WHERE
      rev_page IN (
        SELECT
          page.page_id
        FROM
          page_assessments AS ass
          INNER JOIN page ON page.page_id = ass.pa_page_id
        WHERE
          ass.pa_project_id = 406
          AND page.page_namespace = 0
          AND page.page_is_redirect = 0
      )
  );

SQL

Checking query status...