مقالات يوجد فيها وصلة إلى صفحات المستخدمين

SQL

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
    );

SQL

Checking query status...