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