CommentLink

dbo.ui_listSearchSermon @Search_Key = ' AND Title > ''ㄱ'' and Title < ''ㄴ'' AND CD.GroupID NOT in (125) AND (S.FileNum1>0 or S.FileNum2>0 or S.FileNum3>0 or S.FileNum7>0 or S.FileNum8>0) ',@SermonType = '0'



dbo.ui_listSearchSermon @Search_Key = ' AND Title > ''ㄴ'' and Title < ''ㄷ'' AND CD.GroupID NOT in (125) AND (S.FileNum1>0 or S.FileNum2>0 or S.FileNum3>0 or S.FileNum7>0 or S.FileNum8>0) ',@SermonType = '0'



dbo.ui_listSearchSermon @Search_Key = ' AND Title > ''ㄷ'' and Title < ''ㄹ'' AND CD.GroupID NOT in (125) AND (S.FileNum1>0 or S.FileNum2>0 or S.FileNum3>0 or S.FileNum7>0 or S.FileNum8>0) ',@SermonType = '0'



dbo.ui_listSearchSermon @Search_Key = ' AND Title > ''ㄹ'' and Title < ''ㅁ'' AND CD.GroupID NOT in (125) AND (S.FileNum1>0 or S.FileNum2>0 or S.FileNum3>0 or S.FileNum7>0 or S.FileNum8>0) ',@SermonType = '0'



dbo.ui_listSearchSermon @Search_Key = ' AND Title > ''ㅁ'' and Title < ''ㅂ'' AND CD.GroupID NOT in (125) AND (S.FileNum1>0 or S.FileNum2>0 or S.FileNum3>0 or S.FileNum7>0 or S.FileNum8>0) ',@SermonType = '0'



dbo.ui_listSearchSermon @Search_Key = ' AND Title > ''ㅂ'' and Title < ''ㅅ'' AND CD.GroupID NOT in (125) AND (S.FileNum1>0 or S.FileNum2>0 or S.FileNum3>0 or S.FileNum7>0 or S.FileNum8>0) ',@SermonType = '0'



dbo.ui_listSearchSermon @Search_Key = ' AND Title > ''ㅅ'' and Title < ''ㅇ'' AND CD.GroupID NOT in (125) AND (S.FileNum1>0 or S.FileNum2>0 or S.FileNum3>0 or S.FileNum7>0 or S.FileNum8>0) ',@SermonType = '0'



dbo.ui_listSearchSermon @Search_Key = ' AND Title > ''ㅇ'' and Title < ''ㅈ'' AND CD.GroupID NOT in (125) AND (S.FileNum1>0 or S.FileNum2>0 or S.FileNum3>0 or S.FileNum7>0 or S.FileNum8>0) ',@SermonType = '0'



dbo.ui_listSearchSermon @Search_Key = ' AND Title > ''ㅈ'' and Title < ''ㅊ'' AND CD.GroupID NOT in (125) AND (S.FileNum1>0 or S.FileNum2>0 or S.FileNum3>0 or S.FileNum7>0 or S.FileNum8>0) ',@SermonType = '3'



dbo.ui_listSearchSermon @Search_Key = ' AND Title > ''ㅊ'' and Title < ''ㅋ'' AND CD.GroupID NOT in (125) AND (S.FileNum1>0 or S.FileNum2>0 or S.FileNum3>0 or S.FileNum7>0 or S.FileNum8>0) ',@SermonType = '0'



dbo.ui_listSearchSermon @Search_Key = ' AND Title > ''ㅋ'' and Title < ''ㅌ'' AND CD.GroupID NOT in (125) AND (S.FileNum1>0 or S.FileNum2>0 or S.FileNum3>0 or S.FileNum7>0 or S.FileNum8>0) ',@SermonType = '0'



dbo.ui_listSearchSermon @Search_Key = ' AND Title > ''ㅌ'' and Title < ''ㅍ'' AND CD.GroupID NOT in (125) AND (S.FileNum1>0 or S.FileNum2>0 or S.FileNum3>0 or S.FileNum7>0 or S.FileNum8>0) ',@SermonType = '0'



dbo.ui_listSearchSermon @Search_Key = ' AND Title > ''ㅍ'' and Title < ''ㅎ'' AND CD.GroupID NOT in (125) AND (S.FileNum1>0 or S.FileNum2>0 or S.FileNum3>0 or S.FileNum7>0 or S.FileNum8>0) ',@SermonType = '0'



dbo.ui_listSearchSermon @Search_Key = ' AND Title > ''ㅎ'' AND CD.GroupID NOT in (125) AND (S.FileNum1>0 or S.FileNum2>0 or S.FileNum3>0 or S.FileNum7>0 or S.FileNum8>0) ',@SermonType = '0'



dbo.ui_listSearchSermon @Search_Key = ' AND CD.GroupID NOT in (124) AND (substring( Title ,1,1) in (''0'',''1'',''2'',''3'',''4'',''5'',''6'',''7'',''8'',''9'')) AND CD.GroupID NOT in (125) AND (S.FileNum1>0 or S.FileNum2>0 or S.FileNum3>0 or S.FileNum7>0 or S.FileNum8>0) ',@SermonType = '0'



dbo.ui_listSearchSermon @Search_Key = ' AND ( Title >= ''a'' and Title <= ''z'') AND (substring( Title ,1,1) not in (''0'',''1'',''2'',''3'',''4'',''5'',''6'',''7'',''8'',''9'')) AND CD.GroupID NOT in (125) AND (S.FileNum1>0 or S.FileNum2>0 or S.FileNum3>0 or S.FileNum7>0 or S.FileNum8>0) ',@SermonType = '0'