Number of pages in ruwiki created by bots

Fork of Number of pages in ukwiki created by bots by Tohaomg

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

SQL

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