Mother/PTME 30-49

select patient_code, first_name, last_name, timestampdiff(year, dob, now()) as age, address, telephone, telephone2, id_patient from tracking_motherbasicinfo
left join patient on patient.id=id_patient
 where
 id_patient in (select id_patient from session) and
 timestampdiff(year, dob, now()) between 30 and 49
 group by patient_code