LISTE POUR : The Coathangers

SELECT tbproductions.*, ttvenues.city,ttvenues.state, CONCAT(ttvenues.city,', ',ttvenues.state) as Region FROM tbproductions,ttvenues , tevoEventPerformers WHERE tbEventsID = 32731 AND tevoEventPerformers.performerId = 32731 AND tevoEventPerformers.isPrimary = 1 AND tbproductions.tbVenuesID = ttvenues.id AND tbproductions.tbVenuesID = ttvenues.id AND tevoEventPerformers.eventId = tbproductions.ID ORDER BY tbproductions.Eventdate
DATES
ÉVÉNEMENT
SELECT * from toolvenuepagelink WHERE venueid = 32290
SELECT * from toolcitypagelink WHERE cityname = 'Birmingham'

April

The Coathangers
Saturn Birmingham Birmingham, AL
Apr 4, 9:00 pm 2019
Thursday
Apr 4
9:00 pm
The Coathangers
Saturn, Birmingham, AL
SELECT * from toolvenuepagelink WHERE venueid = 2483
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
The Coathangers
Exit/In Nashville Nashville, TN
Apr 5, 9:00 pm 2019
Friday
Apr 5
9:00 pm
The Coathangers
Exit/In, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 4745
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
The Coathangers
The Record Bar Kansas City Kansas City, MO
Apr 7, 9:00 pm 2019
Sunday
Apr 7
9:00 pm
The Coathangers
The Record Bar, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 33149
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
The Coathangers
El Club Detroit Detroit, MI
Apr 11, 9:00 pm 2019
Thursday
Apr 11
9:00 pm
The Coathangers
El Club, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 610
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
The Coathangers
Grog Shop Cleveland Cleveland, OH
Apr 12, 9:00 pm 2019
Friday
Apr 12
9:00 pm
The Coathangers
Grog Shop, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 5832
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
The Coathangers
Horseshoe Tavern Toronto Toronto, ON
Apr 13, 9:00 pm 2019
Saturday
Apr 13
9:00 pm
The Coathangers
Horseshoe Tavern, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 6102
SELECT * from toolcitypagelink WHERE cityname = 'Allston'
The Coathangers
Great Scott Allston Allston, MA
Apr 15, 9:15 pm 2019
Monday
Apr 15
9:15 pm
The Coathangers
Great Scott, Allston, MA
SELECT * from toolvenuepagelink WHERE venueid = 5559
SELECT * from toolcitypagelink WHERE cityname = 'Asbury Park'
The Coathangers
Asbury Lanes Asbury Park Asbury Park, NJ
Apr 17, 8:00 pm 2019
Wednesday
Apr 17
8:00 pm
The Coathangers
Asbury Lanes, Asbury Park, NJ
SELECT * from toolvenuepagelink WHERE venueid = 31586
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
The Coathangers
DC9 Nightclub Washington Washington, DC
Apr 19, 8:00 pm 2019
Friday
Apr 19
8:00 pm
The Coathangers
DC9 Nightclub, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 28913
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
The Coathangers
Underground Arts Philadelphia Philadelphia, PA
Apr 20, 9:00 pm 2019
Saturday
Apr 20
9:00 pm
The Coathangers
Underground Arts, Philadelphia, PA
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football