Untitled query #70482

SQL

select count(*), rev_page, rev_actor, rev_id, rev_timestamp,
	case
    	when rev_timestamp < 20100101000000 then 1
        when rev_timestamp > 20100101000000 and rev_timestamp < 20120101000000 then 2
        when rev_timestamp > 20120101000000 and rev_timestamp < 20140101000000 then 3
        when rev_timestamp > 20140101000000 and rev_timestamp < 20160101000000 then 4
        when rev_timestamp > 20160101000000 and rev_timestamp < 20180101000000 then 5
        when rev_timestamp > 20180101000000 and rev_timestamp < 20200101000000 then 6
        else 7
    end as year_bin
from revision
where rev_page = 25646758
group by year_bin
order by year_bin
SQL

Checking query status...
