query_users <- "
SELECT wiki_db, user_id, user_name
FROM wmf_raw.mediawiki_user
WHERE snapshot='2023-02'
AND user_name  regexp '^[*]'
"
query_editors <- "
 SELECT wiki_db,
        event_user_text AS user_name,
        event_user_id AS user_id,
        count(revision_id) AS edits
    FROM wmf.mediawiki_history 
    WHERE
        snapshot='2023-02' AND
        event_entity = 'revision' AND
        event_type = 'create' AND
        --logged-in users
        event_user_is_anonymous = false 
        AND  event_user_text regexp '^[*]'
        AND substr(event_timestamp,1,10) BETWEEN '2021-03-01' AND '2023-02-28' 
GROUP BY wiki_db, event_user_text, event_user_id 

"