Query Run
use satwiki_p; select substr(rev_timestamp, 1, 8) as Datee, ... 1 year ago
use kswiki_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