Page MenuHomePhabricator
Paste P8193

(An Untitled Masterwork)
ActivePublic

Authored by Addshore on Mar 13 2019, 4:59 PM.
Tags
None
Referenced Files
F34637275: raw-paste-data.txt
Sep 8 2021, 8:31 PM
F28381911: raw.txt
Mar 13 2019, 4:59 PM
Subscribers
None
select CAST( SUBSTR(dt, 0, 4) AS int ) as year, SUM(value)
from wmf.mediawiki_metrics
where wiki_db = 'wikidatawiki'
and metric = 'daily_edits'
and snapshot = '2021-08'
group by CAST( SUBSTR(dt, 0, 4) AS int )
ORDER BY year ASC
LIMIT 100