SELECT p.page_title, pl.pl_namespace, pl.pl_title

FROM page p

INNER JOIN pagelinks pl ON p.page_id = pl.pl_from AND pl.pl_namespace = 2

WHERE p.page_namespace = 0

AND pl.pl_title != 'Citation_bot'

AND p.page_id NOT IN (SELECT tl.tl_from FROM templatelinks tl WHERE tl.tl_target_id IN (236264, 17233, 99384, 2139, 13870, 881, 658, 8718, 8187, 2308))

AND p.page_id NOT IN (SELECT cl.cl_from FROM categorylinks cl WHERE cl.cl_to IN 

    ('Candidates_for_speedy_deletion', 'Wikipedia_people', 'Wikimedia_Foundation_staff_members', 'American_Wikimedians', 'British_Wikimedians', 'Canadian_Wikimedians', 'French_Wikimedians', 

    'German_Wikimedians', 'Ghanaian_Wikimedians', 'Indian_Wikimedians', 'New_Zealand_Wikimedians', 'Polish_Wikimedians', 'Russian_Wikimedians', 'Ukrainian_Wikimedians', 'History_of_Wikipedia',

    'Wikipedia_controversies'))

AND p.page_is_redirect = 0

AND p.page_title NOT IN ('Main_Page', 'The_Signpost', 'Dirty_Politics')

AND p.page_title NOT LIKE '%Wiki%'