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