Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select count(*) from (
- select * from (select id_patient as id from tracking_infant where eid_pcr_program=1 and (positive_pcr_1!='0000-00-00' or positive_pcr_2!='0000-00-00'
- or comments like '%Added via bulk upload%'
- )
- ) a
- union
- select id_patient as id from testing_specimen where pcr_result=1
- union select id_patient as id from testing_result where result=1
- ) r
- where id not in (select id from patient where linked_to_id_patient!=0)
- and id not in (select id_patient from tracking_infant where is_dead=1 or is_abandoned=1)
- and id in (select id_patient from tracking_infant)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement