From e1266eaf4bdad8c9eac68ca2751d2316025752cd Mon Sep 17 00:00:00 2001
From: David Monllao <davidm@moodle.com>
Date: Mon, 12 Nov 2018 16:26:14 +0100
Subject: [PATCH] MDL-63724 messaging: Prefix field with the table alias

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

diff --git a/lib/classes/message/manager.php b/lib/classes/message/manager.php
index 5630ac4bce0..4ffc62ece5e 100644
--- a/lib/classes/message/manager.php
+++ b/lib/classes/message/manager.php
@@ -86,7 +86,7 @@ class manager {
                   FROM {message_conversation_members} mcm
                   JOIN {user} u
                     ON (mcm.conversationid = :convid AND u.id = mcm.userid)
-              ORDER BY id desc";
+              ORDER BY u.id desc";
         $members = $DB->get_records_sql($sql, ['convid' => $eventdata->convid]);
         if (empty($members)) {
             throw new \moodle_exception("Conversation has no members or does not exist.");
-- 
2.17.1