X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FSQLite%2Fselect_buffer_highlightcount.sql;fp=src%2Fcore%2FSQL%2FSQLite%2Fselect_buffer_highlightcount.sql;h=33058f8564c93b92493b4ca6efe9869b0b194d08;hp=0000000000000000000000000000000000000000;hb=88ce73ff525535c00cc979fff357fbe4cb8cdc2b;hpb=c382e0c11f80fb37307ecc42c487aa433c97ad8c

diff --git a/src/core/SQL/SQLite/select_buffer_highlightcount.sql b/src/core/SQL/SQLite/select_buffer_highlightcount.sql
new file mode 100644
index 00000000..33058f85
--- /dev/null
+++ b/src/core/SQL/SQLite/select_buffer_highlightcount.sql
@@ -0,0 +1,7 @@
+SELECT COALESCE(t.sum,0)
+FROM
+  (SELECT COUNT(*) AS sum FROM backlog
+   WHERE bufferid = :bufferid
+     AND flags & 2 != 0
+     AND flags & 1 = 0
+     AND messageid > :lastseenmsgid) t;