SELECT
    wiki_db,
    COUNT(*) cnt
FROM
    mediawiki_history
WHERE
    snapshot='2018-11'
    AND event_entity='user'
    AND event_type='alterblocks'
    AND event_user_text=user_text
    AND date_format(event_timestamp, 'yyyy')=<year>
GROUP BY wiki_db
ORDER BY cnt DESC
LIMIT 1000;