path: root/sql/message_get_unread_by_clientid.sql

select count(*) as unread from messages where message_to_client_id= :message_to_client_id: and message_flag_read= 0;