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=324508 order by cast(datemmm+' '+datedd+' '+dateyyyy as datetime)
General Admission - $7.00. (Children ages 10 and under admitted FREE.) Love offering received for the featured artist. Doors to auditorium open 90 minutes prior to the concert. Enjoy music by The Gospel Barn Band beginning 30 minutes prior to the concert. Full line of concessions at reasonable prices. For more information, please contact us by phone or email, or go to GospelBarn.com. You will also find "The Gospel Barn" on Facebook.
