Articles by year (all, bot-created) on skwiki

SQL

USE skwiki_p;

SELECT
    YEAR(rf.rev_timestamp), COUNT(*)
  FROM
    page p, revision rf
  WHERE
    rf.rev_page = p.page_id and rf.rev_parent_id = 0 and
    p.page_namespace = 0 and
    p.page_is_redirect = 0 and
    -- rf.rev_user_text = 'Wizzo-Bot'
    rf.rev_user_text RLIKE '^(Wizzo-Bot|IW-BOT|Atomobot|Liso-Bot|Rainbot|TeslaBot|Adrian-Bot)$'
    -- ( rf.rev_user in (SELECT ug_user FROM user_groups WHERE ug_group = 'bot') or rf.rev_user_text RLIKE '^(Wizzo-Bot|IW-BOT|Atomobot|Liso-Bot|Rainbot|TeslaBot|Adrian-Bot)$')
    -- LOWER(CONVERT(rf.rev_user_text USING latin1)) RLIKE '^bot|bot$|mediawiki message delivery|commonsdelinker|commonsticker|robotquistnix|loveless|klbot2'
  GROUP BY
    YEAR(rf.rev_timestamp)
  ORDER BY
    YEAR(rf.rev_timestamp)
  ;
SQL

Checking query status...
