WITH article AS (

  SELECT *

  FROM page

  JOIN categorylinks ON page_id = cl_from AND cl_to = "Living_people"

  WHERE page_namespace = 0

  AND page_is_redirect = 0

),

​

no_ext AS (

  SELECT DISTINCT(page_title), page_len

  FROM article

  LEFT JOIN externallinks ON page_id = el_from

  WHERE el_id IS NULL

),

​

no_cite AS (

  SELECT DISTINCT(page_title), page_len

  FROM article

  JOIN templatelinks ON page_id = tl_from 

  JOIN linktarget ON lt_id = tl_target_id AND lt_title = "Citation/CS1"

),

​

reflist AS (

  SELECT DISTINCT(page_title), page_len

  FROM article

  JOIN templatelinks ON page_id = tl_from 

  JOIN linktarget ON lt_id = tl_target_id AND lt_title = "Reflist"

),

​

isbn AS (

  SELECT DISTINCT(page_title), page_len

  FROM article

  JOIN templatelinks ON page_id = tl_from 

  JOIN linktarget ON lt_id = tl_target_id AND lt_title = "ISBN"

)

​

SELECT * FROM no_ext

EXCEPT

SELECT * FROM no_cite

EXCEPT

SELECT * FROM reflist

EXCEPT

SELECT * FROM isbn