Untitled query #52434

SQL

use tewiki_p;
select substr(user_registration,1,4) as yeare, count(substr(user_registration,1,4)) from user
group by substr(user_registration,1,4)
order by substr(user_registration,1,4);
select substr(log_timestamp,1,4), count(substr(log_timestamp,1,4)) from logging 
	where `log_type` = 'newusers' /* exclude proxy registrations */
	AND `log_action` = 'create' /* only include self-created users, exclude attached and proxy-registered users */
group by substr(log_timestamp,1,4)
order by substr(log_timestamp,1,4)
SQL

Checking query status...
