Waray Wikipedia editors who logged for the first time from July to August 2019

SQL

SET @row_number = 0; 
SELECT
  (@row_number:=@row_number + 1) AS rank, 
  (SELECT ug_group FROM user
   JOIN user_groups
   ON user_id = ug_user) user_group
  user_id,
  user_name,
  user_editcount,
  user_registration
FROM user
WHERE user_editcount > 0 AND
     (user_name NOT IN (SELECT
                         user_name
                       FROM user
                       JOIN user_groups
                       ON user_id = ug_user
                       WHERE ug_group = 'bot') 
      AND user_name NOT LIKE '%bot%' AND user_name NOT LIKE '%Bot%'
      AND user_name NOT IN ('CommonsDelinker', 'CommonsTicker', 'TXiKiBoT', 'Kolega2357'))
      AND (user_registration > '20190630235959' AND user_registration < '20190901000101')
ORDER BY user_editcount DESC
LIMIT 1000;

SQL

Checking query status...