Jump to content

'.'conversation_id', 'conversations'.'conversation_subject' ' at line 2


etsted

Recommended Posts

Maybe...

"SELECT   conversations.conversation_id,                     conversations.conversation_subject,                    MAX(conversation_messages.message_date) AS conversation_last_reply,                     MAX(conversation_messages.message_date) > conversation_members.conversations_last_view AS conversation_undread                    FROM conversations                     LEFT JOIN conversation_messages ON conversations.conversation_id = conversation_messages.conversation_id                     INNER JOIN conversation_members ON conversations.conversation_id = conversation_members.conversation_id                     WHERE conversation_members.user_id = 1                    AND conversation_members.conversation_deleted = 0                    GROUP BY conversations.conversation_id                    ORDER BY conversation_last_reply DESC;";
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...