Query Run
USE jawiki_p; SELECT substr(log_timestamp, 1, 8) AS date, COUNT(*) FROM... 10 years ago
use jawiki_p; select substr(log_timestamp, 1, 8) as date, count(*) from... 10 years ago