ConversationMessageModel::getCountByConversation PHP Method

    public function getCountByConversation($ConversationID, $ViewingUserID, $Wheres = '')
    {
        if (is_array($Wheres)) {
            $this->SQL->where($Wheres);
        }
        $Data = $this->SQL->select('cm.MessageID', 'count', 'Count')->from('ConversationMessage cm')->join('Conversation c', 'cm.ConversationID = c.ConversationID')->join('UserConversation uc', 'c.ConversationID = uc.ConversationID and uc.UserID = ' . $ViewingUserID)->beginWhereGroup()->where('uc.DateCleared is null')->orWhere('uc.DateCleared >', 'c.DateUpdated', true, false)->endWhereGroup()->groupBy('cm.ConversationID')->where('cm.ConversationID', $ConversationID)->get();
        if ($Data->numRows() > 0) {
            return $Data->firstRow()->Count;
        }
        return 0;
    }