Fanch 

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

21 Oct 2002	Ubu Rennes (FR)
27 Jun 2003	Salle de la Cité Rennes (FR)
13 Jul 2003	Salle Jules Vernes Douarnenez (FR)
13 Aug 2003	Mondo Bizarro Rennes (FR)
09 Mar 2005	Ubu Rennes (FR)
30 Jul 2005	Au Pont du Rock festival Malestroit (FR)
06 Aug 2005	Les Vaches au Gallo Louvigné-du-Désert (FR)
02 Jun 2006	Art Rock Festival St Brieuc (FR)
16 Feb 2007	Festival des Hivernautes Quimper (FR)
10 Jun 2009	()
20 May 2011	()
24 Nov 2012	()