Untitled query #50064

SQL

use fiwiki_p;
select 
	actor_name, 
    SUM(page_namespace=0) as pages,
    count(distinct(rev_id)) as edits,     
    SUM(page_namespace=0) as page_talk,
    SUM(page_namespace=3) as user_talk,
    SUM(page_namespace IN (1,3,5,7,9,11,13,15,107,829) OR (page_namespace=4 AND page_title LIKE "%Kahvihuone%") ) as total_talk,    
    SUM(page_namespace=4) as wikipedia, 
    SUM(page_namespace=106) as wikiprojekti,
    SUM(page_namespace=12) as ohje,   
    SUM(page_namespace=6) as tiedosto,
    SUM(page_namespace=14) as kategoria,    
    SUM(page_namespace=10) as malline,    
    SUM(page_namespace=8) as mediawiki,     
    SUM(page_namespace=828) as moduuli
    
   
from 
	page, 
    revision_userindex, 
    actor_revision 
where 
	page_id=rev_page 
    and rev_actor=actor_id 
    and rev_timestamp > 20200000000000 
    and (actor_name NOT LIKE "%Bot" AND actor_name NOT LIKE "%BOT" AND actor_name NOT LIKE "%bot")
group by rev_actor 
order by edits 
desc limit 100
SQL

Checking query status...
