SELECT COUNT(*) AS 'count',

       st AS 'status'

FROM

(SELECT page_id,

        CASE WHEN page_is_redirect = 1 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 'disambiguation page/set-index article'

             WHEN (EXISTS (SELECT 1 FROM categorylinks WHERE cl_from = rev_page AND cl_to = 'All_stub_articles')) THEN 'stub'

             ELSE 'non-stub/dab/sia article'

        END AS st

 FROM revision_userindex

 JOIN actor_revision ON actor_id = rev_actor

 JOIN page ON page_id = rev_page

 WHERE actor_name = 'DatGuy'

   AND page_namespace = 0

   AND rev_parent_id = 0) sq

GROUP BY st

​

UNION

​

SELECT COUNT(*), 'deleted'

FROM archive_userindex AS a1

JOIN actor_archive ON actor_id = a1.ar_actor

WHERE actor_name = 'DatGuy'

  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);