From db35b461da9db8c1b4cc6a09245a9771fd956eeb Mon Sep 17 00:00:00 2001 From: Mike Vink Date: Sun, 2 May 2021 17:46:19 +0200 Subject: changed symlinks --- queries/simon_initial | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 queries/simon_initial (limited to 'queries/simon_initial') diff --git a/queries/simon_initial b/queries/simon_initial new file mode 100644 index 0000000..f7ae18a --- /dev/null +++ b/queries/simon_initial @@ -0,0 +1,16 @@ +SELECT donors.id AS donor_id, + donor_visits.age AS age, + donor_visits.vaccine_resp AS outcome, + experimental_data.name_formatted AS data_name, + experimental_data.data AS data +FROM donors + LEFT JOIN donor_visits + ON donors.id = donor_visits.donor_id + AND donor_visits.visit_id = 1 + INNER JOIN experimental_data + ON donor_visits.id = experimental_data.donor_visits_id + AND experimental_data.donor_id = donor_visits.donor_id +WHERE donors.gender IS NOT NULL + AND donor_visits.vaccine_resp IS NOT NULL + AND donor_visits.vaccine = 4 +ORDER BY donors.study_donor_id DESC -- cgit v1.2.3