Canes 

select t1.*,t2.*,t3.*, t1.id as idshow,t2.name as venuename, t2.address_city as venuelocation, t3.country as state, t3.iso as isostate, t3.usa as country,t1.all_ages as allages from shows t1 left join show_venue t2 on t2.id=t1.idvenue left join countrylist t3 on t1.idcountry=t3.id where t1.id=1704User 'fishbonelive' has exceeded the 'max_questions' resource (current value: 40000)select t1.*,t2.*,t3.*, t1.id as idshow,t2.name as venuename, t2.address_city as venuelocation, t3.country as state, t3.iso as isostate, t3.usa as country,t1.all_ages as allages from shows t1 left join show_venue t2 on t2.id=t1.idvenue left join countrylist t3 on t1.idcountry=t3.id where t1.id=1804User 'fishbonelive' has exceeded the 'max_questions' resource (current value: 40000)

Fishbone played already at Canes 9 times.
>December 18, 1997
>April 21, 2000
>April 10, 2004
>December 30, 2004
>July 09, 2005
>December 30, 2005
>September 09, 2006
>November ,
>November ,
Fishbone is not scheduled to play Canes anytime soon.