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