Untitled query #85849

SQL

WITH talk_pages_projects AS (
    SELECT DISTINCT page_title, page_id
    FROM page
    JOIN categorylinks AS israel ON page_id = israel.cl_from AND israel.cl_to = "WikiProject_Israel_articles"
    JOIN categorylinks AS palestine ON page_id = palestine.cl_from AND palestine.cl_to = "WikiProject_Palestine_articles"
    WHERE page_namespace = 1
   	AND page_is_redirect = 0
),

talk_pages_templates AS (
 	SELECT DISTINCT page_title, page_id
  	FROM page
    JOIN templatelinks ON tl_from = page_id
    JOIN linktarget ON tl_target_id = lt_id
    WHERE page_namespace = 1
    AND page_is_redirect = 0
    AND lt_title in ('ArbCom_Arab-Israeli_enforcement', 'Contentious_topics/Arab-Israeli_talk_notice')
    AND lt_namespace = 10
    AND tl_from_namespace = 1
),

talk_pages AS (
  SELECT DISTINCT page_title, page_id
  FROM talk_pages_projects
  UNION
  SELECT DISTINCT page_title, page_id
  FROM talk_pages_templates
),

arbpia_pages 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
  UNION
  SELECT DISTINCT page_id, page_title
  FROM talk_pages
)

SELECT *
FROM arbpia_pages
SQL

Checking query status...
