Untitled query #27845

SQL

USE skwiki_p;

SELECT
    rf.rev_user_text, COUNT(*) as 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 in (SELECT ug_user FROM user_groups WHERE ug_group = 'bot')
    -- ( rf.rev_user in (SELECT ug_user FROM user_groups WHERE ug_group = 'bot') or LOWER(CONVERT(rf.rev_user_text USING latin1)) RLIKE 'bot$|mediawiki message delivery|commonsdelinker|commonsticker|robotquistnix|loveless|klbot2')    
  GROUP BY
    rf.rev_user_text
  ORDER BY
    count desc
  ;
SQL

Checking query status...
