use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp),... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp),... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp),... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp),... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp), count(r.*)/... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp), count(r.*)/... |
5 years ago |
use enwiki_p;
select EXTRACT(YEAR FROM r.rev_timestamp), count(r.*)/... |
5 years ago |
use enwiki_p;
select CAST(rev_timestamp AS DATE) from revision
limit 20 ; |
5 years ago |
use enwiki_p;
select CAST(rev_timestamp AS DATE) from revision
top 20 ; |
5 years ago |