Fly me to the Moon 

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=1810User '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=1914User 'fishbonelive' has exceeded the 'max_questions' resource (current value: 40000)

Fishbone played already at Fly me to the Moon 7 times.
>February 24, 1997
>February 22, 1998
>February 10, 2001
>February 27, 2002
>February 13, 2003
>November ,
>November ,
Fishbone is not scheduled to play Fly me to the Moon anytime soon.