Untitled query #70482

SQL

select 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
order by year_bin

AخA
 
select 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_binfrom revisionwhere rev_page = 25646758order by year_bin

SQL

Checking query status...