Árva szócikkek

SQL

USE huwiki_p;
SELECT * FROM page lonely
WHERE lonely.page_namespace = 0
  AND lonely.page_is_redirect = 0
  AND NOT EXISTS (
    SELECT * FROM templatelinks
    WHERE tl_from = lonely.page_id AND tl_namespace = 10 AND tl_title = 'Egyért'
  )
  AND NOT EXISTS (
    SELECT * FROM templatelinks
    WHERE tl_from = lonely.page_id AND tl_namespace = 10 AND tl_title = 'Összevon'
  )
  AND NOT EXISTS (
    SELECT * FROM templatelinks
    WHERE tl_from = lonely.page_id AND tl_namespace = 10 AND tl_title = 'Bedolgoz'
  )
  AND NOT EXISTS (
    SELECT page_id FROM page referer
      JOIN pagelinks ON referer.page_id = pl_from AND referer.page_namespace = 0
    WHERE lonely.page_title = pl_title AND lonely.page_namespace = 0 AND pl_namespace = 0
  )
ORDER BY page_title ASC;
SQL

Checking query status...
