SELECT page.page_title AS ll_page_title,

       linktarget.lt_title AS ll_page_to_title,

       linktarget.lt_namespace AS ll_pl_namespace

FROM page

INNER JOIN pagelinks ON pagelinks.pl_from = page.page_id

inner join linktarget ON lt_id = pl_target_id

WHERE pagelinks.pl_from_namespace = 0

  AND (linktarget.lt_namespace = 2

       OR linktarget.lt_namespace = 3)

  AND page.page_namespace = 0

  AND page.page_is_redirect = 0

  AND page.page_id not in

    (SELECT templatelinks.tl_from

     FROM templatelinks

     JOIN linktarget ON linktarget.lt_id = templatelinks.tl_target_id

     WHERE linktarget.lt_title in

         (SELECT lt_title

          FROM pagelinks

          inner join linktarget ON lt_id = pl_target_id

          WHERE pl_from = 9043549)

       AND templatelinks.tl_from_namespace = 0 )

  AND page.page_title not in

    (SELECT lt_title

     FROM pagelinks

     inner join linktarget ON lt_id = pl_target_id

     WHERE pl_from = 9043549

    );