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/visit_multiple_21 | |
| parent | bf1adece8aeb48e136085233d2f5ff2f9600eaf5 (diff) | |
changed symlinks
Diffstat (limited to 'queries/visit_multiple_21')
| -rw-r--r-- | queries/visit_multiple_21 | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/queries/visit_multiple_21 b/queries/visit_multiple_21 new file mode 100644 index 0000000..d8a16fa --- /dev/null +++ b/queries/visit_multiple_21 @@ -0,0 +1,11 @@ +SELECT * from `donor_visits` +join( +select donor_visits.donor_id +from donor_visits +group by donor_visits.donor_id +having count(*) > 1) s on donor_visits.donor_id = s.donor_id +join donors +on donors.id = donor_visits.donor_id +where study_id = 21 +and donor_visits.donor_id = 166 +order by donor_visits.donor_id, visit_id |