All ns0 articles with 0 incoming links

SQL

SELECT
  page_namespace,
  page_title
FROM page
WHERE page_namespace = 0 -- Limit to the main namespace (ns0)
  AND page_id NOT IN (
    SELECT pl_from
    FROM pagelinks
    WHERE pl_namespace = 0 -- Limit to the main namespace (ns0)
  )
  AND page_id NOT IN (
    SELECT tl_from
    FROM templatelinks
    WHERE tl_namespace = 10 -- Template namespace
      AND tl_title = 'Orphan' -- Check for the Orphan template
  )
  AND page_is_redirect = 0 -- Exclude redirects
  AND NOT EXISTS (
    SELECT 1
    FROM categorylinks
    WHERE cl_from = page_id
      AND cl_to = 'All_orphaned_articles' -- Exclude articles in the Orphan category
  )
  AND NOT EXISTS (
    SELECT 1
    FROM categorylinks
    WHERE cl_from = page_id
      AND cl_to IN ('All_set_index_articles', 'All_disambiguation_pages') -- Exclude set index and disambiguation pages
  )
LIMIT 100;
SQL

Checking query status...
