Number of pages in ruwiki created by bots

Fork of Number of pages in ruwiki created by bots by Alex Blokha

This query is marked as a draft This query has been published by Estopedist1.

SQL

SELECT COUNT(1) as pages_by_bots
FROM etwiki_p.user_groups UG
  JOIN etwiki_p.revision R ON UG.ug_user = R.rev_user
  JOIN etwiki_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 etwiki_p.user_former_groups UFG
  JOIN etwiki_p.revision R2 ON UFG.ufg_user = R2.rev_user
  JOIN etwiki_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...