X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FSQLite%2F1%2Fselect_messagesSince.sql;fp=src%2Fcore%2FSQL%2FSQLite%2F1%2Fselect_messagesSince.sql;h=0000000000000000000000000000000000000000;hp=9776b58a3ae8228e9bc424d9cc34023b5ab8b56a;hb=23ebdc0a422294764ff3be3f8d7e56cc2b323185;hpb=92bc51670686fe3e2c7077e7114389d25cbbfe13 diff --git a/src/core/SQL/SQLite/1/select_messagesSince.sql b/src/core/SQL/SQLite/1/select_messagesSince.sql deleted file mode 100644 index 9776b58a..00000000 --- a/src/core/SQL/SQLite/1/select_messagesSince.sql +++ /dev/null @@ -1,8 +0,0 @@ -SELECT messageid, time, type, flags, sender, message, displayname -FROM backlog -JOIN buffer ON backlog.bufferid = buffer.bufferid -JOIN sender ON backlog.senderid = sender.senderid -LEFT JOIN buffergroup ON buffer.groupid = buffergroup.groupid -WHERE (buffer.bufferid = :bufferid OR buffer.groupid = (SELECT groupid FROM buffer WHERE bufferid = :bufferid2)) AND backlog.time >= :since -ORDER BY messageid DESC -LIMIT -1 OFFSET :offset