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 살아갈 힘을 어디서 얻습니까? 20141123 설교
1 나의 힘이 되신 여호와여/주께 가오니 20141123 찬양
2 예수님만이 유일한 구원자인가? 20141116 설교
3 한국교회 치유와 회복 위한 연합기도회 20140824 사역스토리
4 복음의 서진을 위해 사랑의교회 브라질교회와 손을 잡다 20140812 사역스토리
5 돌보심 20140215 책과 미디어
6 "거룩한 무력감으로 더욱 하나님만을 바라보게 하신 시간이었습니다" 20140906 사랑의 목장