select log_type, substring(log_timestamp,1,6) as month, count(*) from... |
5 years ago |
select log_type, substring(log_timestamp,1,10), count(*) from logging... |
5 years ago |
use enwiki_p;
select log_type, substring(log_timestamp,10,11), count(*) from... |
5 years ago |
use enwiki_p;
select log_type, substring(log_timestamp,6,7), count(*) from... |
5 years ago |