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/mike_repeat_visit | |
| parent | bf1adece8aeb48e136085233d2f5ff2f9600eaf5 (diff) | |
changed symlinks
Diffstat (limited to 'queries/mike_repeat_visit')
| -rw-r--r-- | queries/mike_repeat_visit | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/queries/mike_repeat_visit b/queries/mike_repeat_visit new file mode 100644 index 0000000..c0bfbfd --- /dev/null +++ b/queries/mike_repeat_visit @@ -0,0 +1,23 @@ +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 name_formatted, + experimental_data.assay AS assay, + experimental_data.data AS data +FROM donors + LEFT JOIN donor_visits + ON donors.id = donor_visits.donor_id + 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 + AND donor_visits.visit_type_hai = "pre" + AND donor_visits.visit_id != 1 +ORDER BY donors.study_donor_id DESC |