Wikidata stats

SQL

select 
	rc_timestamp, 
    rc_user_text, 
    rc_source,
    count(distinct(rc_this_oldid)) as c, 
    sum(rc_source="mw.edit") as edits, 
    sum(rc_source="mw.new") as creation, 
    count(distinct(user_id*(user_editcount>99))) as uc100, 
    count(distinct(user_id*(user_editcount>10)))-count(distinct(user_id*(user_editcount>100))) as uc10, 
    count(distinct(user_id*(user_editcount>0)))-count(distinct(user_id*(user_editcount>10))) as uc1  
from 
	user, 
    wb_items_per_site,
    page, 
    recentchanges_compat 
where 
	ips_site_id="fiwiki" 
    and concat("Q", ips_item_id)=page_title 
    AND page_namespace=0 
    AND rc_cur_id=page_id 
    AND rc_source IN ('mw.edit', 'mw.new') 
    AND rc_bot=0 
    AND rc_user=user_id;
SQL

Checking query status...
