diff options
Diffstat (limited to 'lib')
| -rw-r--r-- | lib/Service/ParticipantService.php | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/lib/Service/ParticipantService.php b/lib/Service/ParticipantService.php index cf78aff27..2904e750a 100644 --- a/lib/Service/ParticipantService.php +++ b/lib/Service/ParticipantService.php @@ -629,13 +629,13 @@ class ParticipantService { $helper = new SelectHelper(); $helper->selectAttendeesTable($query); $helper->selectSessionsTable($query); - $query->from('talk_sessions', 's') + $query->from('talk_attendees', 'a') ->leftJoin( - 's', 'talk_attendees', 'a', + 'a', 'talk_sessions', 's', $query->expr()->eq('s.attendee_id', 'a.id') ) ->where($query->expr()->eq('a.room_id', $query->createNamedParameter($room->getId(), IQueryBuilder::PARAM_INT))) - ->andWhere($query->expr()->eq('notification_level', $query->createNamedParameter($notificationLevel, IQueryBuilder::PARAM_INT))); + ->andWhere($query->expr()->eq('a.notification_level', $query->createNamedParameter($notificationLevel, IQueryBuilder::PARAM_INT))); return $this->getParticipantsFromQuery($query, $room); } @@ -687,9 +687,9 @@ class ParticipantService { $query = $this->connection->getQueryBuilder(); $query->select('a.actor_id') - ->from('talk_sessions', 's') + ->from('talk_attendees', 'a') ->leftJoin( - 's', 'talk_attendees', 'a', + 'a', 'talk_sessions', 's', $query->expr()->eq('s.attendee_id', 'a.id') ) ->where($query->expr()->eq('a.room_id', $query->createNamedParameter($room->getId(), IQueryBuilder::PARAM_INT))) |