All ns0 articles with 0 incoming links

SQL

SELECT
  page_namespace,
  page_title
FROM page
LEFT JOIN templatelinks ON page_id = tl_from
WHERE page_namespace = 0
  AND page_title NOT IN (
    SELECT DISTINCT pl_title
    FROM pagelinks
    WHERE pl_namespace = 0
  )
  AND tl_namespace = 10 -- Template namespace
  AND tl_title = 'Orphan'
  AND page_is_redirect = 0
  AND NOT EXISTS (
    SELECT 1
    FROM categorylinks
    WHERE cl_from = page_id
      AND cl_to = 'All_orphaned_articles'
  )
  AND NOT EXISTS (
    SELECT 1
    FROM categorylinks
    WHERE cl_from = page_id
      AND cl_to IN ('All_set_index_articles', 'All_disambiguation_pages')
  )
LIMIT 100;
SQL

Checking query status...
