diff options
Diffstat (limited to 'modules-available/statistics_reporting/inc')
-rw-r--r-- | modules-available/statistics_reporting/inc/queries.inc.php | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/modules-available/statistics_reporting/inc/queries.inc.php b/modules-available/statistics_reporting/inc/queries.inc.php index f389cfb1..47a07375 100644 --- a/modules-available/statistics_reporting/inc/queries.inc.php +++ b/modules-available/statistics_reporting/inc/queries.inc.php @@ -373,7 +373,8 @@ class Queries $return = []; $eres = Database::simpleQuery("SELECT starttime, endtime, GROUP_CONCAT(exl.locationid) AS `locs` FROM exams LEFT JOIN exams_x_location exl USING (examid) - WHERE starttime < $to AND endtime > $from"); + WHERE starttime < $to AND endtime > $from + GROUP BY examid"); while ($row = $eres->fetch(PDO::FETCH_ASSOC)) { // Get all boot events $data = ['from' => $row['starttime'], 'to' => $row['endtime']]; |