Untitled query #74016

SQL

WITH dabs AS (
  SELECT page_title, page_id, COUNT(*) as links
FROM page
JOIN pagelinks ON pl_from = page_id
JOIN categorylinks ON page_id = cl_from AND cl_to = "Human_name_disambiguation_pages"
WHERE page_namespace = 0
AND page_is_redirect = 0
AND pl_namespace = 0
GROUP BY page_title
HAVING links < 8
),

distinct_dabs AS (
  SELECT DISTINCT(page_title), page_id
  FROM dabs
),

biography_dabs AS (
  SELECT DISTINCT(distinct_dabs.page_title), distinct_dabs.page_id
  FROM distinct_dabs
  JOIN pagelinks ON pl_from = distinct_dabs.page_id
  JOIN page ON pl_title = page.page_title AND page_namespace = 1 AND page_is_redirect = 0
  JOIN categorylinks ON cl_from = page.page_id AND cl_to LIKE '%iography%'
  WHERE pl_namespace = 0
),

biography_dabs_redirects AS (
  SELECT DISTINCT(distinct_dabs.page_title), distinct_dabs.page_id
  FROM distinct_dabs
  JOIN pagelinks AS direct ON pl_from = distinct_dabs.page_id AND direct.pl_namespace = 0
  JOIN page AS redirects ON direct.pl_title = redirects.page_title AND redirects.page_namespace = 0 AND redirects.page_is_redirect = 1
  JOIN pagelinks AS indirect ON indirect.pl_from = redirects.page_id AND indirect.pl_namespace = 0
  JOIN page AS articles ON articles.page_title = indirect.pl_title AND articles.page_namespace = 1 AND articles.page_is_redirect = 0
  JOIN categorylinks ON cl_from = articles.page_id AND cl_to LIKE '%iography%'
)

SELECT page_title
FROM distinct_dabs
WHERE page_id NOT IN (SELECT page_id FROM biography_dabs)
AND page_id NOT IN (SELECT page_id FROM biography_dabs_redirects)
SQL

Checking query status...
