use hiwiki_p;

/* specify a datetime range */

SET @start_date = '20051001000000';

SET @end_date = '20200501000000';

SELECT

  `log_user` AS user_id,

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

  `log_timestamp` AS user_registration

FROM

  logging

WHERE

  `log_type` = 'newusers'

AND

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

AND

  `log_timestamp` BETWEEN @start_date AND @end_date;

​