Untitled query #82343

SQL

SELECT mainpage.page_title
FROM page mainpage
INNER JOIN page talkpage ON mainpage.page_title = talkpage.page_title
INNER JOIN categorylinks talkcat ON talkcat.cl_from = talkpage.page_id
INNER JOIN categorylinks maincat ON maincat.cl_from = mainpage.page_id
WHERE mainpage.page_namespace = 0
AND talkpage.page_namespace = 1
AND talkcat.cl_to = 'Science_and_academia_work_group_articles'
AND maincat.cl_to = 'Living_people'
AND mainpage.page_id NOT IN (
  SELECT cl_from FROM categorylinks WHERE cl_to = 'Articles_with_ORCID_identifiers'
)
LIMIT 10
SQL

Checking query status...
