cswiki analytics

SQL

SELECT LEFT(rev_timestamp, 8) AS day, COUNT(rev_id),
	SUM(IF(actor_user IS NULL, 1, IF(DATE_ADD(rev_timestamp, INTERVAL -7 DAY) < log_timestamp, 1, 0))) AS is_new
FROM revision
JOIN page ON page_id = rev_page
JOIN actor_revision ON actor_id = rev_actor
LEFT JOIN user ON actor_user IS NOT NULL AND actor_user = user_id
LEFT JOIN logging_logindex
	ON actor_user IS NOT NULL
    AND log_type = 'newusers' AND log_action = 'create' AND log_namespace = 2 AND log_title = REPLACE(actor_name, ' ', '_')
    AND log_timestamp < rev_timestamp
WHERE page_namespace = 0
AND page_is_redirect = 0
AND rev_timestamp > '2020'
GROUP BY LEFT(rev_timestamp, 8);
SQL

Checking query status...
