number

0

Query Template: /CFusion/RestApi/Test/TestMessageBadge.cfm:3 Execution Time: 0.731 ms Record Count: 0 Cached: No Datasource: yourvoyce Lazy: No SQL: Select * From engine4_dm_chats Where (user_a = 128 OR user_b = 128 OR (Select Find_in_set('128', room_users))) and chat_active = 1 and last_message_sent_by <> 128 and (Find_in_set('128', last_message_seen_by) = 0)

chat_id

room_id

last_message

last_message_sent_by

last_message_time

last_message_seen_by

user_a

user_b

room_users

user_a_last_clear_time

user_b_last_clear_time

chat_active

user_a_notifications_active

user_b_notifications_active