How can we monitor the conversations between members on the site??
SELECT
#_social_conversations_participants.id,
#_social_conversations_participants.conversation_id,
#_social_conversations_participants.user_id,
#_social_conversations_participants.state,
#_social_conversations_message.id,
#_social_conversations_message.conversation_id,
#_social_conversations_message.type,
#_social_conversations_message.message,
#_social_conversations_message.created,
#_social_conversations_message.created_by
FROM
#_social_conversations_message
INNER JOIN #_social_conversations_participants ON #_social_conversations_participants.conversation_id = #_social_conversations_message.conversation_id