SELECT * FROM ccs WHERE pubDate LIKE #CreateODBCDate(FORM.date)#AND speaker LIKE '%#FORM.speaker#%' AND title LIKE '%#FORM.title#%'AND refBook LIKE '%#FORM.book#%'AND refChapter = '#FORM.chapter#' ORDER BY pubDate ASCDESC ORDER BY title DESC ORDER BY refBook DESC, refChapter DESC, refVerse DESC ORDER BY pubDate DESC SELECT * FROM books, verses WHERE books.bkid = verses.bookid SELECT bkid AS endBkid, book AS endBook, bookid AS endBookid, chapter AS endChapter, verse AS endVerse FROM books, verses WHERE books.bkid = verses.bookid SELECT * FROM ccs_messages_qu, bible_qu WHERE ccs_messages_qu.refChapter = bible_qu.chapter AND ccs_messages_qu.refBook = bible_qu.book SELECT * FROM ccs_messages_join_qu, endBible_qu WHERE ccs_messages_join_qu.refEndChapter = endBible_qu.endChapter AND ccs_messages_join_qu.refBook = endBible_qu.endBook SELECT * FROM books SELECT * FROM verses GROUP BY chapter SELECT * FROM verses GROUP BY verse Calvary Spokane Admin
My Account   |  Logout
511 W. HASTINGS RD. SPOKANE, WA 99218 509.467.2860 | MAP
Admin Broadcast Calendar Events Guest Ranch Messages Pictures Calvary Spokane Matters of the Heart XO Communications
CS MOTH Series MOTH MOTH UK Upcoming Events Event Items Users Logs
Calvary Spokane
Date Speaker Title Book Chapter
Messages Per-Page:
Date Tape ## Speaker Title Refrence MP3 MP4 Notes
#DateFormat(ccs_messages_output_qu.pubDate, "MMM D, YY")# #ccs_messages_output_qu.tapeNumber# #ccs_messages_output_qu.speaker# #ccs_messages_output_qu.title# #ccs_messages_output_qu.refBook# #ccs_messages_output_qu.refChapter#:#ccs_messages_output_qu.refVerse#--#ccs_messages_output_qu.refEndChapter#:#ccs_messages_output_qu.refEndVerse# MP3 MP4 Notes
Prev  #y#  #y#  Next 


© 2006-9 Calvary Spokane. All Rights Reserved. Contact Us