Some stats about GA process on fawiki

SQL

use fawiki_p;

select start_year, count(*) cases, avg(duration) avg_duration, min(duration) min_duration, max(duration) max_duration
from
(
  select
    page_title,
    left(min(rev_timestamp), 4) start_year,
    left(min(rev_timestamp), 8) start_date,
    left(max(rev_timestamp), 8) end_date,
    datediff(str_to_date(left(max(rev_timestamp), 8), '%Y%m%d'), str_to_date(left(min(rev_timestamp), 8), '%Y%m%d')) duration
  from page
  join revision
    on page_id = rev_page
    and rev_minor_edit = 0
  where
    page_title like 'گزیدن_مقاله‌های_خوب/%'
    and page_title not like '%بایگانی%'
    and page_namespace = 4
  group by page_id
) t
where
  duration > 0
  and duration < 365 -- beyond one year is probably due to later page moves and such
  and start_year > 2009 -- pre 2009 data is incomplete
  and start_year < 2020 -- 2020 has not started yet
group by start_year
order by start_year;
SQL

Checking query status...
