use zhwiki_p;

-- select user_name, count(*) from revision join page on rev_page = page_id 

-- join user_groups on ug_user = revision.rev_user join user on user_id = ug_user

  -- where ug_group = 'patroller' and page_namespace = 4 and page_title like '頁面存廢討論/記錄/%' 

  --    group by revision.rev_user order by count(*) desc;

  select user_id, user_name, user_editcount, user_registration from user 

    where user_registration >= 20200501000000 and user_editcount >= 10 order by user_editcount desc;

​

​

-- select user_id, user_name, ug_group from user join user_groups on user_name = ug_group

    -- where user_name like '%wql%' order by user_id desc;