LISTE POUR : Carpenter Brut

SELECT tbproductions.*, ttvenues.city,ttvenues.state, CONCAT(ttvenues.city,', ',ttvenues.state) as Region FROM tbproductions,ttvenues , tevoEventPerformers WHERE tbEventsID = 51536 AND tevoEventPerformers.performerId = 51536 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 = 3226
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'

April

Carpenter Brut
Regency Ballroom - Social Hall San Francisco San Francisco, CA
Apr 14, 9:00 pm 2018
Saturday
Apr 14
9:00 pm
Carpenter Brut
Regency Ballroom - Social Hall, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 1419
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Carpenter Brut
The Showbox Seattle Seattle, WA
Apr 16, 8:00 pm 2018
Monday
Apr 16
8:00 pm
Carpenter Brut
The Showbox, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 4059
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Carpenter Brut
Wonder Ballroom Portland Portland, OR
Apr 18, 8:00 pm 2018
Wednesday
Apr 18
8:00 pm
Carpenter Brut
Wonder Ballroom, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 2040
SELECT * from toolcitypagelink WHERE cityname = 'Englewood'
Carpenter Brut
Gothic Theatre Englewood Englewood, CO
Apr 23, 8:00 pm 2018
Monday
Apr 23
8:00 pm
Carpenter Brut
Gothic Theatre, Englewood, CO
SELECT * from toolvenuepagelink WHERE venueid = 493
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
Carpenter Brut
Fine Line Music Cafe Minneapolis Minneapolis, MN
Apr 25, 8:00 pm 2018
Wednesday
Apr 25
8:00 pm
Carpenter Brut
Fine Line Music Cafe, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 30272
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Carpenter Brut
Concord Music Hall Chicago Chicago, IL
Apr 26, 8:00 pm 2018
Thursday
Apr 26
8:00 pm
Carpenter Brut
Concord Music Hall, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 2992
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Carpenter Brut
Danforth Music Hall Toronto Toronto, ON
Apr 27, 7:00 pm 2018
Friday
Apr 27
7:00 pm
Carpenter Brut
Danforth Music Hall, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 18123
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Carpenter Brut
Corona Theatre Montreal Montreal, QC
Apr 28, 8:00 pm 2018
Saturday
Apr 28
8:00 pm
Carpenter Brut
Corona Theatre, Montreal, QC
SELECT * from toolvenuepagelink WHERE venueid = 29821
SELECT * from toolcitypagelink WHERE cityname = 'Cambridge'
Carpenter Brut
Sinclair Music Hall Cambridge Cambridge, MA
Apr 30, 8:00 pm 2018
Monday
Apr 30
8:00 pm
Carpenter Brut
Sinclair Music Hall, Cambridge, MA
SELECT * from toolvenuepagelink WHERE venueid = 1959
SELECT * from toolcitypagelink WHERE cityname = 'Washington'

May

Carpenter Brut
9:30 Club Washington Washington, DC
May 1, 7:00 pm 2018
Tuesday
May 1
7:00 pm
Carpenter Brut
9:30 Club, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 7916
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
Carpenter Brut
Union Transfer Philadelphia Philadelphia, PA
May 4, 8:30 pm 2018
Friday
May 4
8:30 pm
Carpenter Brut
Union Transfer, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 725
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Carpenter Brut
Irving Plaza New York New York, NY
May 6, 7:00 pm 2018
Sunday
May 6
7:00 pm
Carpenter Brut
Irving Plaza, New York, NY
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football
NOUVELLES - SPORT