[previous_cml_monitoring]
select date(r.created_at) as 'registered', rrs.results_summary as 'result'
from requests r
join ( patient_case pc join patients p on pc.patient_id = p.id )
on r.patient_case_id = pc.id
join ( request_initial_screen ris join screens s on ris.screen_id = s.id )
on ris.request_id = r.id
join ( request_result_summaries rrs join lab_sections ls on rrs.lab_section_id = ls.id )
on rrs.request_id = r.id
where s.description = 'Follow-up CML (PB)'
and ls.section_name = 'Molecular'
and p.nhs_number = ?
order by r.created_at desc
limit 5
[referral_sources]
select rs.id, rs.display_name, rs.organisation_code
from referral_sources rs
join referral_types rt on rs.referral_type_id = rt.id
where rt.description = 'hospital'
and rs.is_active = 'yes'
and rs.display_name regexp ? /* sqlite can't do rlike, use 'regexp' */