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=251729 order by cast(datemmm+' '+datedd+' '+dateyyyy as datetime)
The Southaven Police Wives Auxiliary is sponsoring a Gospel Singing Benefit "Support the Peacemakers." The proceeds will go to medical and travel expenses for Southaven Police Sgt. Todd Pierce. Sgt.. Pierce is awaiting a double lung transplant. All proceeds over and above his expenses will be donated to the Southaven Police Chaplain`s Benevolence Fund. There will be 6 groups singing throughout the afternoon. The event begins at 1:00 p.m. until 6:00 p.m. A love offering will be taken at the door. Make your plans now to attend! Other featured groups are Vessel, Servants Heart, Overjoyed, Living Proof, and The Gatewoods.