Query Run
USE fawiki_p; select substr(rev_timestamp,1,6) as dated,... 1 year ago
USE tewiki_p; select substr(rev_timestamp,1,6) as dated,... 1 year ago