X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FSQLite%2Fselect_messagesAll_filtered.sql;h=b4f91f2b5ab9687a096fa953200ae9e91fa01fb9;hp=c09be6b387cea9716f5e4bb70d83e70050f13908;hb=85087a839d89dc53ed71b41e12244e57f21f67b1;hpb=3c910a417a72dfa529ad514d9a616139b7d57bab diff --git a/src/core/SQL/SQLite/select_messagesAll_filtered.sql b/src/core/SQL/SQLite/select_messagesAll_filtered.sql index c09be6b3..b4f91f2b 100644 --- a/src/core/SQL/SQLite/select_messagesAll_filtered.sql +++ b/src/core/SQL/SQLite/select_messagesAll_filtered.sql @@ -5,6 +5,6 @@ WHERE backlog.bufferid IN (SELECT bufferid FROM buffer WHERE userid = :userid) AND backlog.messageid >= :firstmsg AND backlog.messageid < :lastmsg AND backlog.type & :type != 0 - AND (:flags = 0 OR backlog.flags & :flags != 0) + AND (:flags = 0 OR backlog.flags & :flagsDup1 != 0) ORDER BY messageid DESC LIMIT :limit