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
),

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

WITH biography_dabs AS (
  SELECT DISTINCT(distinct_dabs.page_title), page_id
  FROM distinct_dabs
  JOIN pagelinks ON pl_from = 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
)

SELECT distinct_dabs.page_title, pl_title
FROM distinct_dabs
WHERE page_id NOT IN (SELECT page_id FROM biography_dabs)
SQL

Checking query status...
