use zhwiki_p;

select rev_user_text, count(*) from revision_userindex join page on rev_page = page_id join user_groups on ug_user = rev_user 

  where ug_group = 'patroller' and page_namespace = 4 and page_title like '頁面存廢討論/記錄/%' group by rev_user order by count(*) desc;