since 4 years ago patient 52647 had received a procedure?
select count(*)>0 from procedures_icd where procedures_icd.hadm_id in ( select admissions.hadm_id from admissions where admissions.subject_id = 52647 ) and datetime(procedures_icd.charttime) >= datetime(current_time,'-4 year')