Untitled query #23439

SQL

USE skwiki_p;

SELECT 
    user_name, user_editcount, user_touched
  FROM
    user
  WHERE 
    user_editcount >= 200 and
    not LOWER(CONVERT(user_name USING latin1)) RLIKE '^bot|bot$|mediawiki message delivery|commonsdelinker|commonsticker|robotquistnix|loveless|klbot2' and
      -- @todo exclude bots via user_groups
    user_id in (SELECT rev_user FROM revision WHERE rev_timestamp > 20151201000000) and
    not user_id in (SELECT rev_user FROM revision WHERE rev_timestamp > 20171202000000)
  ORDER BY
    user_editcount desc, user_name
  ;
SQL

Checking query status...
