From a575ab151624c06af529c5f3962dc999c45b2d63 Mon Sep 17 00:00:00 2001 From: Michael Hawkins Date: Fri, 18 Oct 2019 12:35:53 +0800 Subject: [PATCH] MDL-66767 forumreport_summary: Improved groups only SQL --- mod/forum/report/summary/classes/summary_table.php | 12 +++++------- 1 file changed, 5 insertions(+), 7 deletions(-) diff --git a/mod/forum/report/summary/classes/summary_table.php b/mod/forum/report/summary/classes/summary_table.php index ac93572443f..0ac4d978e0a 100644 --- a/mod/forum/report/summary/classes/summary_table.php +++ b/mod/forum/report/summary/classes/summary_table.php @@ -333,13 +333,11 @@ class summary_table extends table_sql { // No joins required (handled by where to prevent data duplication). $this->sql->filterwhere .= " - AND u.id = ( - SELECT gm.userid - FROM {groups_members} gm - WHERE gm.userid = u.id - AND gm.groupid {$groupusersin} - GROUP BY gm.userid - LIMIT 1) + AND u.id IN ( + SELECT gm.userid + FROM {groups_members} gm + WHERE gm.groupid {$groupusersin} + ) AND d.groupid {$groupidin}"; $this->sql->params += $groupusersparams + $groupidparams; } -- 2.36.1