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=252455 order by cast(datemmm+' '+datedd+' '+dateyyyy as datetime)
HOMECOMING COMING AT MT. PISGAH CHURCH ON APRIL 9,2017..WORSHIP SERVICE AT 11 AM, LUNCH FOLLOWING WORSHIP SERVICE AND SINGING WITH THE DISCIPLES AFTER LUNCH..COME JOIN US FOR FELLOWSHIP AND WORSHIOING OUR LORD AND SAVIOR JESUS CHRIST