User:Bookofjude/headerless/sql

use enwikisource_p;
select page_title
from page
where page_id not in
(select tl_from from templatelinks where tl_title like '%eader%' or
tl_title like '%DNB%' or
tl_title like '%oft%redir' or
tl_title like '%homonymy%' or
tl_title like '%NSRW%' or
tl_title like '%isambi%' or
tl_title like '%ishnah%' or
tl_title like '%anakh%' or
tl_title like '%ible%' or
tl_title like '%ax%avel%' or
tl_title like '%UK%Act%' or
tl_title like '%ersion%' or
tl_title like '%non%' or
tl_title like '%ongress%' or
tl_title like '%EB1911%' or
tl_title like '%DNB%' or
tl_title like '%EAm06%' or
tl_title like '%Collier%' or
tl_title like '%CAB03%' or
tl_title like '%EB11%'
)
and page_id not in
(select cl_from from categorylinks where cl_to like 'Soft_redirects%')
and page_title not in
(select pl_title from pagelinks where pl_from=416787)
and page_namespace = 0 and page_is_redirect = 0;