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;