select substr(rev_timestamp,1,8) as itime, count(*) from revision
where... |
1 year ago |
select substr(rev_timestamp,1,8) as itime, count(itime) from revision
where... |
1 year ago |
select substr(rev_timestamp,1,8) as itime from revision
where rev_timestamp... |
1 year ago |
select substr(rev_timestamp,1,8) as itime from revision
where rev_timestamp... |
1 year ago |
select substr(rev_timestamp,1,8) from revision
where rev_timestamp > 2023
group by |
1 year ago |
select substr(rev_timestamp,1,8) from revision
limit 1 |
1 year ago |
select substr(rev_timestamp,0,8) from revision
limit 1 |
1 year ago |
select substr(rev_timestamp,8) from revision
limit 1 |
1 year ago |
select rev_timestamp from revision
limit 1 |
1 year ago |