articles_in_which_there_is_a_link_to_user_pages

SQL

SELECT page.page_title AS ll_page_title,
       pagelinks.pl_title AS ll_page_to_title,
       pagelinks.pl_namespace AS ll_pl_namespace
FROM page
INNER JOIN pagelinks
ON pagelinks.pl_from = page.page_id
LEFT JOIN (
    SELECT tl_from
    FROM templatelinks
    JOIN linktarget ON linktarget.lt_id = templatelinks.tl_target_id
    WHERE linktarget.lt_title IN (
        SELECT pl_title
        FROM pagelinks
        WHERE pl_from = 9043549
    ) AND templatelinks.tl_from_namespace = 0
) AS excluded_pages ON page.page_id = excluded_pages.tl_from
WHERE page.page_namespace = 0
AND page.page_is_redirect = 0
AND pagelinks.pl_from_namespace = 0
AND (pagelinks.pl_namespace = 2 OR pagelinks.pl_namespace = 3)
AND excluded_pages.tl_from IS NULL
AND page.page_title NOT IN (
    SELECT pl_title
    FROM pagelinks
    WHERE pl_from = 9043549
);
SQL

Checking query status...
