Query Run
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