X-Git-Url: https://git.quassel-irc.org/?a=blobdiff_plain;ds=inline;f=src%2Fcore%2FSQL%2FSQLite%2F11%2Fselect_messages.sql;h=dcadad9501638acee1076c2084f9bab9a956aa46;hb=de1619ce11bf386490cdb38bc1be134a391eeaae;hp=343466702ce3d11d53cc92e059a2ac28556afdb6;hpb=e0464aa399c32231e5cc7879f8910c3ccd3b45e3;p=quassel.git

diff --git a/src/core/SQL/SQLite/11/select_messages.sql b/src/core/SQL/SQLite/11/select_messages.sql
index 34346670..dcadad95 100644
--- a/src/core/SQL/SQLite/11/select_messages.sql
+++ b/src/core/SQL/SQLite/11/select_messages.sql
@@ -1,6 +1,9 @@
 SELECT messageid, time,  type, flags, sender, message
 FROM backlog
+JOIN buffer ON backlog.bufferid = buffer.bufferid
 JOIN sender ON backlog.senderid = sender.senderid
-WHERE bufferid = :bufferid
+WHERE buffer.bufferid = :bufferid
+    AND backlog.messageid >= :firstmsg
+    AND backlog.messageid < :lastmsg
 ORDER BY messageid DESC
-LIMIT :limit OFFSET :offset
+LIMIT :limit