From 85edee26f369c6d5b1ac1a99f1bd4b3ff5fa9a41 Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Wed, 19 Mar 2008 07:49:40 +0000
Subject: [PATCH] MDL-13810 Merged from 1.9

---
 lib/accesslib.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/lib/accesslib.php b/lib/accesslib.php
index 04a4123599..60537a97a7 100755
--- a/lib/accesslib.php
+++ b/lib/accesslib.php
@@ -4525,7 +4525,7 @@ function get_users_by_capability($context, $capability, $fields='', $sort='',
     $sortby = $sort ? " ORDER BY $sort " : '';
 
     // User lastaccess JOIN
-    if (strpos($sort, 'ul.timeaccess') === FALSE) {  // user_lastaccess is not required MDL-13810
+    if ((strpos($sort, 'ul.timeaccess') === FALSE) and (strpos($fields, 'ul.timeaccess') === FALSE)) {  // user_lastaccess is not required MDL-13810
         $uljoin = '';
     } else {
         $uljoin = "LEFT OUTER JOIN {$CFG->prefix}user_lastaccess ul 
-- 
2.39.5