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 mkwiki_p.revision_userindex
         where rev_user_text = r.rev_user_text
         group by rev_user_text
         limit 1
        ) AS edits_in_timeframe,
        replace(up_value, NULL, "unknown"),
        user_id,
        gu_id
FROM mkwiki_p.revision_userindex r
JOIN mkwiki_p.user u
ON u.user_name = r.rev_user_text
LEFT JOIN mkwiki_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 AND rev_user_text IN (
  "Ehrlich91",
  "Bjankuloski06",
  "P.Nedelkovski"
)
GROUP BY rev_user_text
ORDER BY username ASC
SQL

Checking query status...
