Query Run
use shwiki_p; select substr(rev_timestamp, 1, 8) as Datee, ... 1 year ago
use tewiki_p; select substr(rev_timestamp, 1, 8) as Datee, ... 1 year ago