Untitled query #66441

SQL

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

Checking query status...
