Untitled query #70814

SQL

WITH globalblocks AS (
    SELECT
    YEAR(logging.log_timestamp) y,
    MONTH(logging.log_timestamp) m,
    REPLACE(logging.log_title,'@global','') username
    FROM logging 
    WHERE log_type='globalauth' and log_action='setstatus'
) 
SELECT globalblocks.y, globalblocks.m, globaluser.gu_home_db wiki_db, count(*) globalblocks_count
FROM centralauth.globaluser globaluser JOIN globalblocks
ON globaluser.gu_name=globalblocks.username
AND globaluser.gu_home_db IS NOT NULL
GROUP BY globalblocks.y, globalblocks.m, globaluser.gu_home_db
SQL

Checking query status...
