X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FSQLite%2F2%2Fselect_messages.sql;fp=src%2Fcore%2FSQL%2FSQLite%2F1%2Fselect_messages.sql;h=4514d9448cc6a7557bb393c430ac3b8537855cf9;hp=b9596e733d17d8eeeaf386abeae5fd3cd1cc3615;hb=23ebdc0a422294764ff3be3f8d7e56cc2b323185;hpb=92bc51670686fe3e2c7077e7114389d25cbbfe13

diff --git a/src/core/SQL/SQLite/1/select_messages.sql b/src/core/SQL/SQLite/2/select_messages.sql
similarity index 57%
rename from src/core/SQL/SQLite/1/select_messages.sql
rename to src/core/SQL/SQLite/2/select_messages.sql
index b9596e73..4514d944 100644
--- a/src/core/SQL/SQLite/1/select_messages.sql
+++ b/src/core/SQL/SQLite/2/select_messages.sql
@@ -2,7 +2,6 @@ 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)
+WHERE buffer.bufferid = :bufferid
 ORDER BY messageid DESC
 LIMIT :limit OFFSET :offset