From a2e7df3cffc6fa931288fcebb4145042c81b7c5d Mon Sep 17 00:00:00 2001 From: Marcus Eggenberger Date: Sun, 30 Nov 2008 14:53:16 +0100 Subject: [PATCH] Uncrapificating some queries... I must have been above ballmer peak when I wrote them... o_O --- src/core/SQL/SQLite/11/select_messages.sql | 3 +-- src/core/SQL/SQLite/11/select_messagesNew.sql | 3 +-- 2 files changed, 2 insertions(+), 4 deletions(-) diff --git a/src/core/SQL/SQLite/11/select_messages.sql b/src/core/SQL/SQLite/11/select_messages.sql index dcadad95..641179f2 100644 --- a/src/core/SQL/SQLite/11/select_messages.sql +++ b/src/core/SQL/SQLite/11/select_messages.sql @@ -1,8 +1,7 @@ SELECT messageid, time, type, flags, sender, message FROM backlog -JOIN buffer ON backlog.bufferid = buffer.bufferid JOIN sender ON backlog.senderid = sender.senderid -WHERE buffer.bufferid = :bufferid +WHERE bufferid = :bufferid AND backlog.messageid >= :firstmsg AND backlog.messageid < :lastmsg ORDER BY messageid DESC diff --git a/src/core/SQL/SQLite/11/select_messagesNew.sql b/src/core/SQL/SQLite/11/select_messagesNew.sql index e549252a..69d948d6 100644 --- a/src/core/SQL/SQLite/11/select_messagesNew.sql +++ b/src/core/SQL/SQLite/11/select_messagesNew.sql @@ -1,8 +1,7 @@ SELECT messageid, time, type, flags, sender, message FROM backlog -JOIN buffer ON backlog.bufferid = buffer.bufferid JOIN sender ON backlog.senderid = sender.senderid -WHERE buffer.bufferid = :bufferid +WHERE bufferid = :bufferid AND backlog.messageid >= :firstmsg ORDER BY messageid DESC LIMIT :limit -- 2.20.1