Äänioikeutettujen käyttäjien lukumäärä

SQL

use fiwiki_p;
select 
  rev_user_text, 
  namespace_0_edits, 
  floor(daydiff_seconds/(60*60*24)) as age_in_days,
  max_timestamp as last_edit
from (
    select 
       tmp.*, 
       TIMESTAMPDIFF(
          SECOND, 
          str_to_date(min(rev_timestamp), "%Y%m%d%H%i%s"), 
          str_to_date(max(rev_timestamp), "%Y%m%d%H%i%s")) as daydiff_seconds, 
       str_to_date(max(rev_timestamp), "%Y%m%d%H%i%s") as max_timestamp 
     from (
        select 
           sum(1) as namespace_0_edits, 
           rev_user, 
           rev_user_text 
       from page, revision,user 
       where 
          page_id=rev_page 
          and page_namespace=0 
          and rev_user=user_id 
          and user_editcount>50 group by rev_user) as tmp, revision 
     where 
       tmp.rev_user=revision.rev_user 
       and namespace_0_edits>=100 
     group by rev_user) as tmp2 
where daydiff_seconds > (60*60*24*7);
SQL

Checking query status...
