Query Run
#select rc_timestamp, rc_title, max(case when oresm_name="damaging" then... 3 years ago
#select rc_timestamp, rc_title, max(case when oresm_name="damaging" then... 3 years ago