All ns0 articles with 0 incoming links

SQL

SELECT
  p.page_namespace,
  p.page_title
FROM page p
LEFT JOIN pagelinks pl ON p.page_id = pl.pl_from
LEFT JOIN templatelinks tl ON p.page_id = tl.tl_from
WHERE p.page_namespace = 0 -- Limit to the main namespace (ns0)
  AND pl.pl_from IS NULL -- Check if there are no incoming links
  AND tl.tl_namespace = 10 -- Template namespace
  AND tl.tl_title = 'Orphan' -- Check for the Orphan template
  AND p.page_is_redirect = 0 -- Exclude redirects
  AND NOT EXISTS (
    SELECT 1
    FROM categorylinks
    WHERE cl_from = p.page_id
      AND cl_to = 'All_orphaned_articles' -- Exclude articles in the Orphan category
  )
  AND NOT EXISTS (
    SELECT 1
    FROM categorylinks
    WHERE cl_from = p.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...
