Query Run
select * from revision where left(rev_timestamp, 4)=2024; 6 months ago