Koronaviruspandemia 2019 muokkaukset

SQL

use fiwiki_p;

select 	
    rev_user_text,
	count(distinct(rev_id)) as edits,
	count(distinct(floor(rev_timestamp/100000000))) as yearmonth,     
	min(floor(rev_timestamp/100000000)) as min_yearmonth,     
	max(floor(rev_timestamp/100000000)) as min_yearmonth,         
    
from 
	page, 
    categorylinks, 
    revision_compat 
where cl_to IN (
  				"Koronaviruspandemia_2019–", 
  				"Koronaviruspandemia_sijainneittain", 
  				"Koronaviruspandemiassa_kuolleet", 
  				"Koronaviruspandemia_Suomessa") 
	and page_namespace=0 
    and page_id=cl_from 
    and page_id=rev_page 
    and rev_timestamp > 20190600000000 
group by rev_user_text 
order by edits desc;
SQL

Checking query status...
