Untitled query #3208

SQL

USE enwiki_p;
select
	DATABASE() AS wiki,
	COUNT(*)/7 AS registrations_per_day,
	SUM(user_editcount > 0)/7 AS new_editors_per_day
from logging 
inner join user ON log_user = user_id 
where 
	log_type = "newusers" and 
	log_action = "create" and 
	log_timestamp between "20150407" AND "20150414";

USE eswiki_p;
select
	DATABASE() AS wiki,
	COUNT(*)/7 AS registrations_per_day,
	SUM(user_editcount > 0)/7 AS new_editors_per_day
from logging 
inner join user ON log_user = user_id 
where 
	log_type = "newusers" and 
	log_action = "create" and 
	log_timestamp between "20150407" AND "20150414";

USE nlwiki_p;
select
	DATABASE() AS wiki,
	COUNT(*)/7 AS registrations_per_day,
	SUM(user_editcount > 0)/7 AS new_editors_per_day
from logging 
inner join user ON log_user = user_id 
where 
	log_type = "newusers" and 
	log_action = "create" and 
	log_timestamp between "20150407" AND "20150414";
SQL

Checking query status...
