X-Git-Url: https://git.quassel-irc.org/?a=blobdiff_plain;f=src%2Fcore%2FSQL%2FSQLite%2F21%2Fselect_messagesNewestK.sql;fp=src%2Fcore%2FSQL%2FSQLite%2F21%2Fselect_messagesNewestK.sql;h=6f86e70b88cd1781b96fd799a1b323de7dd4d89e;hb=cbc57790069f3bc3e54c59e54cd3274abff536e6;hp=6cc81cc593a3d60c14bdc800655ff8102e431e3c;hpb=31c1e758654388b080ce1dee7065afa053efc1b8;p=quassel.git

diff --git a/src/core/SQL/SQLite/21/select_messagesNewestK.sql b/src/core/SQL/SQLite/21/select_messagesNewestK.sql
index 6cc81cc5..6f86e70b 100644
--- a/src/core/SQL/SQLite/21/select_messagesNewestK.sql
+++ b/src/core/SQL/SQLite/21/select_messagesNewestK.sql
@@ -2,5 +2,6 @@ SELECT messageid, time,  type, flags, sender, message
 FROM backlog
 JOIN sender ON backlog.senderid = sender.senderid
 WHERE bufferid = :bufferid
+AND backlog.messageid <= (SELECT buffer.lastmsgid FROM buffer WHERE buffer.bufferid = :bufferid)
 ORDER BY messageid DESC
 LIMIT :limit