diff options
| author | Mike Vink <mike1994vink@gmail.com> | 2021-05-02 17:46:19 +0200 |
|---|---|---|
| committer | Mike Vink <mike1994vink@gmail.com> | 2021-05-02 17:46:19 +0200 |
| commit | db35b461da9db8c1b4cc6a09245a9771fd956eeb (patch) | |
| tree | 858171bcd369bb9189b3857478ba7ba6b93d32bb /queries/simon_data_extra | |
| parent | bf1adece8aeb48e136085233d2f5ff2f9600eaf5 (diff) | |
changed symlinks
Diffstat (limited to 'queries/simon_data_extra')
| -rw-r--r-- | queries/simon_data_extra | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/queries/simon_data_extra b/queries/simon_data_extra new file mode 100644 index 0000000..ea97abb --- /dev/null +++ b/queries/simon_data_extra @@ -0,0 +1,22 @@ +SELECT donors.id AS donor_id, + donors.study_id AS study, + donor_visits.age AS age, + donor_visits.vaccine_resp AS outcome, + donor_visits.visit_year AS year, + donor_visits.visit_type_hai as type, + donor_visits.d_geo_mean as hai_response, + experimental_data.name AS name, + experimental_data.name_formatted AS data_name, + experimental_data.assay AS assay, + 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 |