• Files
• Commits
• Log
• Graph
• Stats

[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