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=331535 order by cast(datemmm+' '+datedd+' '+dateyyyy as datetime)
Get your tickets at https://www.quartetshow.com
ERNIE HAASE & SIGNATURE SOUND
with special guest DUANE ALLEN
MARK TRAMMELL QUARTET
BLACKWOOD BROTHERS
GOLD CITY
ERNIE HAASE & SIGNATURE SOUND
Live Album Recording
On Saturday, June 15, 2024, during the 6:00 pm concert, Ernie Haase & Signature Sound are planning to record a new LIVE album at the Memphis Quartet Show. We are excited that they chose Memphis for their new recording. This event is available for in person attendance only. It will not be live-streamed. Make your plans to be part of the crowd in a new live album recording by Ernie Haase & Signature Sound along with their live band!
Duane Allen of the Oak Ridge Boys will be singing on this live recording. Don`t miss it!
Doors open at 4:30 pm
