Query Run
use guwiki_p; select substr(rev_timestamp,1,4) as... 1 year ago
use mrwiki_p; select substr(rev_timestamp,1,4) as... 1 year ago