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
group by start_year
order by start_year;




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
SQL

Checking query status...
