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=277638 order by cast(datemmm+' '+datedd+' '+dateyyyy as datetime)
Sat. April 27 – 20th ANNUAL STGMA CONVENTION & GOSPEL CONCERT - Live Oak First Baptist Church – 11560 Toepperwein Rd. – Live Oak, TX 78233 - 10 AM to 6 PM - Free Concert starts at 1 PM following STGMA Convention banquet. STGMA Artists & Groups scheduled to perform include: APPOINTED BY GRACE of Brazoria, TX - JACOB AUSTIN BAND of Anderson, TX - THE BAGGY BOTTOM BOYS of Granbury, TX - BIRTHRIGHT of Dallas, TX - BLUE CREEK of La Vernia, TX - BOUND FOR GLORY of San Antonio, TX - CROSS TIMBERS of Seguin, TX - THE EUBANKS of Bismarck, AR - FAITHFUL II of Channelview, TX - MARSHA FISHER of Barker, TX - HARMONY QUARTET of Dallas, TX - CASEY HEADRICK of Bertram, TX - HEARTS OF GRACE of Brazoria, TX - THE HENDRIX TRIO of Texarkana, TX - LILLY HUTTON of Comfort, TX - CLIFTON JANSKY of San Antonio, TX - JENNA FAITH of La Vernia, TX - JOYFUL SOUND of Midlothian, TX - MERCY SONG REVIVAL of Burleson, TX - THE MILBURNS & MOUNTAIN GRASS of Batesville, TX - BILLY MILLERof San Antonio, TX - THE SOUTHERN PLAINSMEN of Hornbeck, LA - THE PATHFINDERS QUARTET of Midlothian, TX - For more information, visit the STGMA website (stgma.org) or South Texas Gospel Music Association`s Facebook page.
