UniqueCodes::getEpisodeIdFromCode PHP Method

    public function getEpisodeIdFromCode($code)
    {
        $episodeId = $this->dbConnection->createCommand()->select('episode_id')->from('event')->join('unique_codes_mapping ucm', 'ucm.event_id = event.id')->join('unique_codes uc', "ucm.unique_code_id = uc.id and uc.code ='{$code}'")->queryRow();
        return $episodeId;
    }