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
)

SELECT dabs.page_title, pl_title
FROM dabs
JOIN pagelinks ON pl_from = page_id
JOIN page ON pl_title = page.page_title AND page_namespace = 1 AND page_is_redirect = 0
LEFT JOIN categorylinks ON cl_from = page_id AND cl_to LIKE '%iography%'
WHERE pl_namespace = 0
AND cl_to IS NULL
SQL

Checking query status...
