list of noobs in eowiki by CEES MMXVI

SQL

SELECT	r.rev_user_text AS username,
		(select sum(case when rev_timestamp < 20160121000000 then 1 else 0 end)
         from eowiki_p.revision_userindex
         where rev_user_text = r.rev_user_text
         group by rev_user_text
         limit 1
        ) AS edits_in_timeframe,
        IFNULL(up_value, "unknown"),
        user_id,
        gu_id
FROM eowiki_p.revision_userindex r
JOIN eowiki_p.user u
ON u.user_name = r.rev_user_text
LEFT JOIN eowiki_p.user_properties pr
ON pr.up_user = u.user_id AND up_property = "gender" 
JOIN centralauth_p.globaluser gu
ON gu.gu_name = r.rev_user_text
WHERE rev_timestamp > 20160321000000
)
GROUP BY rev_user_text
ORDER BY username ASC
SQL

Checking query status...
