WP:NOTWEBHOST - Quarry

SQL

SELECT
    raw.actor_name,
    COUNT(raw.rc_actor) AS total_contribs,
    SUM(raw.in_userspace) AS userspace_contribs
FROM (
    SELECT
  		recentchanges_userindex.*,
  		actor.actor_name,
  		CASE
  			WHEN recentchanges_userindex.rc_namespace IN (2,3) THEN 1
  			ELSE 0
  		END AS in_userspace
    FROM recentchanges_userindex
  		JOIN actor ON recentchanges_userindex.rc_actor = actor.actor_id
 	WHERE recentchanges_userindex.rc_type IN (0,1)
  		AND recentchanges_userindex.rc_bot = 0
  	ORDER BY recentchanges_userindex.rc_timestamp DESC
) as raw
GROUP BY raw.rc_actor
LIMIT 100;
SQL

Checking query status...
