select title,writeday,regis_dt,imgTop,imgMobile,img,db_idx,content,vod,aod,sc from ( select top 2 title,writeday,regis_dt,db_idx,'' as content,'' as imgTop,'' as imgMobile,'' as img,link_200 as vod,audio_link as aod,'A' as sc from tvdb where clergyman='JA' order by writeday desc,db_idx desc union all select top 1 title,convert(char(8),regdate,112) as writeday,regtime as regis_dt,idx db_idx,'' as content,'' as imgTop,'' as imgMobile,'' as img,filepath1 as vod,filepath3 as aod,'B' as sc from [222.239.253.146].sarangccm.dbo.ccm_vod where div1='chanyang' and div2='오정현목사' order by writeday desc,db_idx desc union all select top 2 title,writeday,'' as regis_dt,db_idx,content,main_filename as imgTop,mobile_filename as imgMobile,img_filename as img,'' as vod,'' as aod,'C' as sc from pastoroh.dbo.book where (flag='AA' or flag='AB') and main_flag='Y' order by writeday desc,db_idx desc union all select top 2 title,writeday,regis_dt,db_idx,content,main_filename as imgTop,sub_filename as imgMobile,img_filename as img,'' as vod,'' as aod,'D' as sc from pastoroh.dbo.oh_speech where tv_flag='O' and main_flag='Y' order by writeday desc,db_idx desc union all select top 3 title,writeday,'' as regis_dt,db_idx,content,image2 as imgTop,image4 as imgMobile,image5 as img,'' as vod,'' as aod,'E' as sc from [222.239.253.146].news.dbo.godpianews where division like '%B111%' order by writeday desc,db_idx desc ) as T order by writeday desc,regis_dt desc,db_idx desc
현재 메인 컨텐츠 리스트
리스트슬롯 제목 등록일 영역
TOP 새로운 미래를 위한 새로운 토대;복음적 팀웍 20160918 설교
1 주의 말씀 받은 그날 20160925 찬양
2 새로운 생명의 잎이 돋아나려면 20160911 설교
3 십자가를 기억하며 구원의 은혜에 벅차오르다 20160327 사역스토리
4 한국교회 치유와 회복 위한 연합기도회 20140824 사역스토리
5 돌보심 20140215 책과 미디어
6 "거룩한 무력감으로 더욱 하나님만을 바라보게 하신 시간이었습니다" 20140906 사랑의 목장