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