select 
			  ex.EXH_NM,
			  bbs.ntt_sj,
			  bbs.ATCH_FILE_ID,
			  bbs.MOVIE_SN,
			  bbs.THUM_SN,
			  fdd.FILE_STRE_COURS,
			  fd.STRE_FILE_NM AS movieNm,
			  fdd.STRE_FILE_NM AS imgNm,
			  bbs.VIDEO_URL as link,
			  bbs.MCOMPANY_ID,
			  bbs.FRST_REGIST_PNTTM,
			  bbs.LAST_UPDT_PNTTM
			from 
			  LETTNBBS bbs 
			  left OUTER JOIN LETTNFILEDETAIL fd ON (fd.ATCH_FILE_ID = bbs.ATCH_FILE_ID and bbs.MOVIE_SN=fd.FILE_SN)
			  LEFT OUTER JOIN LETTNFILEDETAIL fdd ON (fdd.ATCH_FILE_ID = bbs.ATCH_FILE_ID and bbs.THUM_SN=fdd.FILE_SN),
			  T_EXHIBITION ex
			where 
			  ex.EXH_ID = bbs.EXH_ID
			  and bbs.EXH_ID = #exhId# 
			  and bbs.NTT_ID = #bbsId#

function select_event_movie($exh_id,$ntt_id){
	
		$this->exhibit_db->select('ex.EXH_NM,  bbs.ntt_sj, bbs.ATCH_FILE_ID, bbs.MOVIE_SN, bbs.THUM_SN, fdd.FILE_STRE_COURS, fd.STRE_FILE_NM AS movieNm, fdd.STRE_FILE_NM AS imgNm,
			  bbs.VIDEO_URL as link, bbs.MCOMPANY_ID, bbs.FRST_REGIST_PNTTM, bbs.LAST_UPDT_PNTTM');
		$this->exhibit_db->from('T_EXHIBITION as ex');
		$this->exhibit_db->from('LETTNBBS as bbs');
		$this->exhibit_db->join("LETTNFILEDETAIL as fd", "fd.ATCH_FILE_ID = bbs.ATCH_FILE_ID and bbs.MOVIE_SN=fd.FILE_SN", "left outer");
		$this->exhibit_db->join("LETTNFILEDETAIL as fdd", "fdd.ATCH_FILE_ID = bbs.ATCH_FILE_ID and bbs.THUM_SN=fdd.FILE_SN", "left outer");
		$this->exhibit_db->where('ex.EXH_ID = bbs.EXH_ID');
		$this->exhibit_db->where('bbs.EXH_ID = ',$exh_id);
		$this->exhibit_db->where('bbs.NTT_ID = ',$ntt_id);
		
		$row = $this->exhibit_db->get()->row();
        return $row;
	}