public function conversationQuery($ViewingUserID, $Join = '')
{
$this->SQL->select('c.*')->select('lm.InsertUserID', '', 'LastMessageUserID')->select('lm.DateInserted', '', 'DateLastMessage')->select('lm.Body', '', 'LastMessage')->select('lm.Format')->select('lmu.Name', '', 'LastMessageName')->select('lmu.Photo', '', 'LastMessagePhoto')->from('Conversation c');
if ($ViewingUserID) {
$this->SQL->select('c.CountMessages - uc.CountReadMessages', '', 'CountNewMessages')->select('uc.LastMessageID, uc.CountReadMessages, uc.DateLastViewed, uc.Bookmarked')->join('UserConversation uc', "c.ConversationID = uc.ConversationID and uc.UserID = {$ViewingUserID}")->join('ConversationMessage lm', 'uc.LastMessageID = lm.MessageID')->join('User lmu', 'lm.InsertUserID = lmu.UserID')->where('uc.Deleted', 0);
} else {
$this->SQL->select('0', '', 'CountNewMessages')->select('c.CountMessages', '', 'CountReadMessages')->select('lm.DateInserted', '', 'DateLastViewed')->select('0', '', 'Bookmarked')->join('ConversationMessage lm', 'c.LastMessageID = lm.MessageID')->join('User lmu', 'lm.InsertUserID = lmu.UserID');
}
}