Current status of Lugnuts' mainspace creations

Current status of pages created by Lugnuts, that are either currently in mainspace or were in mainspace when deleted.  Different statuses are non-overlapping.

It's not practical to determine the original namespace of a page (whether it was later deleted or not) in aggregate, so this won't see any pages created in mainspace and then moved to e.g. Draft: or userspace.

SQL

SELECT COUNT(*),
       CASE WHEN page_is_redirect THEN 'redirect'
            WHEN (EXISTS (SELECT 1 FROM page_props WHERE pp_page = rev_page AND pp_propname = 'disambiguation')
                  OR EXISTS (SELECT 1 FROM categorylinks WHERE cl_from = rev_page AND cl_to = 'All_set_index_articles'))
                 THEN 'disambig/set-index'
            WHEN (EXISTS (SELECT 1 FROM categorylinks WHERE cl_from = rev_page AND cl_to = 'All_stub_articles')) THEN 'stub'
            ELSE 'non-stub article'
       END AS status
FROM revision_userindex
JOIN actor_revision ON actor_id = rev_actor
JOIN page ON page_id = rev_page
WHERE actor_name = 'Lugnuts'
  AND page_namespace = 0
  AND rev_parent_id = 0

UNION

SELECT COUNT(*), 'deleted'
FROM archive_userindex AS a1
JOIN actor_archive ON actor_id = a1.ar_actor
WHERE actor_name = 'Lugnuts'
  AND a1.ar_namespace = 0
  AND NOT EXISTS (SELECT 1 FROM archive AS a2
                  WHERE a2.ar_namespace = 0
                    AND a2.ar_title = a1.ar_title
                    AND a1.ar_timestamp < a2.ar_timestamp);

SQL

Checking query status...