Jazzyj 

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

16 May 1986	Palladium Los Angeles (CA)
28 Jun 1986	Verizon Wireless Amphi Irvine (CA)
28 Dec 1986	Kono Hawaii Santa Ana (CA)
30 Sep 1988	Ford Theater Hollywood (CA)
17 Dec 1988	Civic Auditorium Santa Monica (CA)
07 Aug 1993	Lollapalooza 93 Santa Fe Dam Recreation Area Irwindale (CA)
20 Mar 2003	()
02 Sep 2012	()