diff options
| author | Joas Schilling <coding@schilljs.com> | 2022-09-29 20:27:53 +0300 |
|---|---|---|
| committer | backportbot-nextcloud[bot] <backportbot-nextcloud[bot]@users.noreply.github.com> | 2022-09-29 20:45:31 +0300 |
| commit | d6a05a4ea81308f2319049e4fa96b341809666e7 (patch) | |
| tree | 18699597f4434b370796ad274adf5ee221c65ab7 /lib | |
| parent | bdc9e7f707c5dac7f2a8d58e1fd7c1e1579baf02 (diff) | |
Fix group by
Signed-off-by: Joas Schilling <coding@schilljs.com>
Diffstat (limited to 'lib')
| -rw-r--r-- | lib/Command/Monitor/Calls.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/Command/Monitor/Calls.php b/lib/Command/Monitor/Calls.php index 2998d2ba3..25527d058 100644 --- a/lib/Command/Monitor/Calls.php +++ b/lib/Command/Monitor/Calls.php @@ -54,13 +54,13 @@ class Calls extends Base { ->from('talk_sessions') ->where($subQuery->expr()->gt('in_call', $query->createNamedParameter(Participant::FLAG_DISCONNECTED))) ->andWhere($subQuery->expr()->gt('last_ping', $query->createNamedParameter(time() - 60))) - ->addGroupBy('attendee_id'); + ->groupBy('attendee_id'); $query->select('r.token', $query->func()->count('*', 'num_attendees')) ->from('talk_attendees', 'a') ->leftJoin('a', 'talk_rooms', 'r', $query->expr()->eq('a.room_id', 'r.id')) ->where($query->expr()->in('a.id', $query->createFunction('(' . $subQuery->getSQL() . ')'))) - ->groupBy('a.room_id'); + ->groupBy('r.token'); $data = []; $result = $query->executeQuery(); |