Chestnut Cabaret 

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=2863User '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=2876User '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=2877User '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=3071User 'fishbonelive' has exceeded the 'max_questions' resource (current value: 40000)

Fishbone played already at Chestnut Cabaret 5 times.
>May 08, 1986
>November ,
>November ,
>November ,
>November ,
Fishbone is not scheduled to play Chestnut Cabaret anytime soon.