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