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(*),
       page_is_redirect,
       (EXISTS (SELECT 1 FROM categorylinks WHERE cl_from = rev_page AND cl_to = 'All_stub_articles')) AS is_stub,
       (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')) AS is_disambig_or_set_index,
       0 AS is_deleted
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
GROUP BY page_is_redirect, is_stub, is_disambig_or_set_index

UNION

SELECT COUNT(*), '?', '?', '?', 1
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...