Replicas browser and optimizer
This query is marked as a draft
This query has been published
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 < 2018 -- 2018 started only recently group by start_year order by start_year;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in