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