sql=select distinct top 199 premium,cast(datemmm+' '+datedd+' '+dateyyyy as datetime),ggevent.timeampm,ggevent.timehh,ggevent.timemm,genre,feature,ggevent.xid,groupname,longitudex as longitude,latitudex as latitude,ggevent.xid,timemm,timehh,timeampm,title,ggevent.zip,ggevent.city,ggevent.state,venue,location,datemmm,datedd,dateyyyy,groupname,ggevent.groupid,ggevent.areacode,ggevent.prefix,ggevent.suffix,ggevent.extension,description,ggevent.contact,ggevent.email,admission,cost,sqrt(power(69.1*(35.110055-latitudex),2)+power(53*(-89.945392-longitudex),2)) as miles from ggevent,gguser,zipcodes where approved='Y' and ggevent.title <> 'ggnew' and ggevent.title > ' ' and ggevent.groupid > ' ' and gguser.groupid=ggevent.groupid and zipcodes.zipcode=ggevent.zip and ggevent.xid=245735 order by cast(datemmm+' '+datedd+' '+dateyyyy as datetime)
Gospel Gigs - Event Details
Event Details

Triumphant Quartet
Christian Counselling Ottawa Presents Triumphant

Visit Triumphant Quartet Homepage

EVENT INFORMATION
   
Event Information:   For tickets info go to http://www.christiancounsellingottawa.ca
   
DATE AND TIME
   
Event Date:   Sep 22 2017
Event Start Time:   6:30 p.m
Admission:   Ticketed Event  
   
VENUE
   
Venue Name:   Cedarview Alliance Church
Venue Address:   2784 Cedarview Road
City:   Ottawa
State/Providence:   ON
Zip/Postal Code:   K2J 4J2
 
 View Map to this Location »
   
CONTACT INFORMATION
   
Contact Person:   David McKendry
Contact Phone:   (613)729-8454
Contact E-mail:   davidjmckendry@gmail.com