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