Play - Quarry

SQL

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 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;
SQL

Checking query status...
