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=93User 'fishbonelive' has exceeded the 'max_questions' resource (current value: 40000)
Catch The Year of the Dragon in a City Close to You
by Denis Jan 15 2010
The Year of the Dragon is finally getting out of LA. Rodcore & Dirty Walt's band will be performing in select cities (West Coast, Texas, Arizona, Nevada) in the next few months. An East Coast tour is in the works for the summer. Here are the dates:
Jan 29 - Blakes on Telegraph, Berkeley CA Feb 26 - Rockit, SF CA Mar 4 - Studio Seven, Seattle WA Mar 5 - Diablo's Downtown Lounge, Eugene OR Mar 6 - The Bank Club, San Jose CA Mar 19 - SXSW Showcase, Headhunter's Tiki Lounge, Austin, TX Apr 9 - Double Down Saloon, Las Vegas, NV Apr 10 - The Rogue, Scottsdale AZ
Headlines 
