From 88487dea6db31247b3629d7bcce62db6efc61460 Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Wed, 10 Sep 2003 13:28:27 +0000
Subject: [PATCH] One GROUP BY -> DISTINCT
---
lib/datalib.php | 5 ++---
1 file changed, 2 insertions(+), 3 deletions(-)
diff --git a/lib/datalib.php b/lib/datalib.php
index aea2739f67..4e53ec8672 100644
--- a/lib/datalib.php
+++ b/lib/datalib.php
@@ -1090,13 +1090,12 @@ function get_users_longtimenosee($cutofftime) {
global $CFG;
$db->debug = true;
- return get_records_sql("SELECT u.*
+ return get_records_sql("SELECT DISTINCT u.*
FROM {$CFG->prefix}user u,
{$CFG->prefix}user_students s
WHERE u.lastaccess > '0'
AND u.lastaccess < '$cutofftime'
- AND u.id = s.userid
- GROUP BY u.id");
+ AND u.id = s.userid ");
}
--
2.39.5