Tewiki:Month-wise new user registrations

SQL

use tewiki_p;
SELECT
  substr(log_timestamp,1,6),count(substr(log_timestamp,1,6)) AS New_users
FROM
  logging
WHERE
  `log_type` = 'newusers' /* exclude proxy registrations */
AND
  `log_action` = 'create' /* only include self-created users, exclude attached and proxy-registered users */
/*AND
  substr(log_timestamp,1,4) ="2020" /* specify a datetime range */
group by substr(log_timestamp,1,6)
order by substr(log_timestamp,1,6)

AخA
 
use tewiki_p;SELECT  substr(log_timestamp,1,6),count(substr(log_timestamp,1,6)) AS New_usersFROM  loggingWHERE  `log_type` = 'newusers' /* exclude proxy registrations */AND  `log_action` = 'create' /* only include self-created users, exclude attached and proxy-registered users *//*AND  substr(log_timestamp,1,4) ="2020" /* specify a datetime range */group by substr(log_timestamp,1,6)order by substr(log_timestamp,1,6)

SQL

Checking query status...