/* specify a datetime range */

SET @start_date = '20221201000000';

SET @end_date = '20230101000000';

​

SELECT

  `log_user` AS user_id,

  REPLACE(`log_title`, '_', ' ') AS user_name,

  `log_timestamp` AS user_registration

FROM

  arwiki.logging

WHERE

  `log_type` = 'newusers' /* exclude proxy registrations */

AND

  `log_action` = 'create' /* only include self-created users, exclude attached and proxy-registered users */

AND

  `log_timestamp` BETWEEN @start_date AND @end_date;