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) ="2022" /* 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) ="2022" /* specify a datetime range*/ group by substr(log_timestamp,1,6)order by substr(log_timestamp,1,6)

SQL

Checking query status...