- Fixed the inconsitency bug lately introduced. Adding networks is now

[quassel.git] / src / core / SQL / SQLite / 2 / select_messages.sql

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 b9596e7..4514d94 100644 (file)
--- 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