List the users with 30/500 edit count, excluding local bots in Cantonese Wikipedia

SQL

USE zh_yuewiki_p;

-- Date and time (UTC) to list users with 30/500 threshold.

SELECT @t := now();

SELECT
    user_name, user_registration, user_editcount
  FROM
    user
  WHERE
    (user_registration IS NULL OR user_registration < DATE_FORMAT(DATE_SUB(@t, INTERVAL 30 DAY), '%Y%m%d%H%i%s')) AND
      -- select for users with 4 days or more since registered AND
    user_editcount >= 500 AND
      -- more than 10 edits
    user_id NOT IN (SELECT ug_user FROM user_groups WHERE ug_group = 'bot') AND
      -- excluding bots
    user_name NOT IN ('CommonsDelinker', 'Xqbot')
      -- excluding non-flagged bots
  ORDER BY
    user_name
  ;

SQL

Checking query status...