Number of pages in ukwiki created by bots

SQL

SELECT COUNT(1) as pages_by_bots
FROM ukwiki_p.user_groups UG
  JOIN ukwiki_p.revision R ON UG.ug_user = R.rev_user
  JOIN ukwiki_p.page P ON R.rev_page=P.page_id
WHERE UG.ug_group = "bot"
  AND R.rev_parent_id = 0
  AND P.page_namespace = 0

UNION

SELECT COUNT(1) as pages_by_former_bots
FROM ukwiki_p.user_former_groups UFG
  JOIN ukwiki_p.revision R2 ON UFG.ufg_user = R2.rev_user
  JOIN ukwiki_p.page P2 ON R2.rev_page=P2.page_id
WHERE UFG.ufg_group = "bot"
  AND R2.rev_parent_id = 0
  AND P2.page_namespace = 0

SQL

Checking query status...