summaryrefslogtreecommitdiffstats
path: root/sql/message_get_unread_by_clientid.sql
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--sql/message_get_unread_by_clientid.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/message_get_unread_by_clientid.sql b/sql/message_get_unread_by_clientid.sql
new file mode 100644
index 0000000..e084dd8
--- /dev/null
+++ b/sql/message_get_unread_by_clientid.sql
@@ -0,0 +1 @@
+select count(*) as unread from messages where message_to_client_id= :message_to_client_id: and message_flag_read= 0;