Untitled query #85681

SQL

WITH talk_pages AS (
    SELECT DISTINCT page_title, page_id
    FROM page
    JOIN categorylinks ON page_id = cl_from
    WHERE page_namespace = 1
   	AND page_is_redirect = 0
   	AND cl_to IN ('WikiProject_Israel_articles', 'WikiProject_Palestine_articles')
),

arbpia_articles AS (
  SELECT DISTINCT page.page_id, page.page_title
  FROM talk_pages
  JOIN page ON page.page_title = talk_pages.page_title
  WHERE page_namespace = 0
  AND page_is_redirect = 0
),

new_arbpia_articles AS (
 SELECT DISTINCT page_id, page_title
 FROM arbpia_articles
 JOIN revision ON page_id = rev_page
 WHERE rev_parent_id = 0
 AND rev_timestamp >= 20231007000000
),

revisions AS (
  SELECT DISTINCT page_id, page_title, rev_actor, rev_id
  FROM new_arbpia_articles
  JOIN revision ON page_id = rev_page
)

SELECT page_title, COUNT(DISTINCT rev_actor) as "Editor count", COUNT(*) as "Edit count"
FROM revisions
GROUP BY page_title
SQL

Checking query status...
