use arwiki_p;

select distinct ct_tag from change_tag;

/*

select rev_user_text , count(*) from change_tag 

inner join revision

on rev_id = ct_rev_id

where ct_tag like "contenttranslation"

and rev_user not in (select ug_user from user_groups where ug_user= rev_user and ug_group like "%rollbacker%")

and rev_user not in (select ug_user from user_groups where ug_user= rev_user and ug_group like "%sysop%")

group by rev_user_text

order by count(*) desc

limit 100;*/