LISTE POUR : The Interrupters

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

March

The Interrupters
Town Ballroom Buffalo Buffalo, NY
Mar 24, 6:30 pm 2019
Sunday
Mar 24
6:30 pm
The Interrupters
Town Ballroom, Buffalo, NY
SELECT * from toolvenuepagelink WHERE venueid = 3052
SELECT * from toolcitypagelink WHERE cityname = 'Millvale'
The Interrupters
Mr Smalls Theater Millvale Millvale, PA
Mar 28, 7:30 pm 2019
Thursday
Mar 28
7:30 pm
The Interrupters
Mr Smalls Theater, Millvale, PA
SELECT * from toolvenuepagelink WHERE venueid = 19289
SELECT * from toolcitypagelink WHERE cityname = 'Indianapolis'
The Interrupters
Deluxe at Old National Centre Indianapolis Indianapolis, IN
Mar 29, 8:00 pm 2019
Friday
Mar 29
8:00 pm
The Interrupters
Deluxe at Old National Centre, Indianapolis, IN
SELECT * from toolvenuepagelink WHERE venueid = 680
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
The Interrupters
House of Blues - Chicago Chicago Chicago, IL
Mar 30, 7:30 pm 2019
Saturday
Mar 30
7:30 pm
The Interrupters
House of Blues - Chicago, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 1862
SELECT * from toolcitypagelink WHERE cityname = 'St Louis'

April

The Interrupters
Delmar Hall St Louis St Louis, MO
Apr 1, 7:30 pm 2019
Monday
Apr 1
7:30 pm
The Interrupters
Delmar Hall, St Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 4092
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
The Interrupters
Varsity Theater - Minneapolis, MN Minneapolis Minneapolis, MN
Apr 3, 6:30 pm 2019
Wednesday
Apr 3
6:30 pm
The Interrupters
Varsity Theater - Minneapolis, MN, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 1131
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
The Interrupters
Ogden Theatre Denver Denver, CO
Apr 5, 8:00 pm 2019
Friday
Apr 5
8:00 pm
The Interrupters
Ogden Theatre, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 3946
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
The Interrupters
The Depot Salt Lake City Salt Lake City, UT
Apr 6, 7:00 pm 2019
Saturday
Apr 6
7:00 pm
The Interrupters
The Depot, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 4059
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
The Interrupters
Wonder Ballroom Portland Portland, OR
Apr 8, 7:30 pm 2019
Monday
Apr 8
7:30 pm
The Interrupters
Wonder Ballroom, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 1945
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
The Interrupters
Commodore Ballroom Vancouver Vancouver, BC
Apr 9, 7:00 pm 2019
Tuesday
Apr 9
7:00 pm
The Interrupters
Commodore Ballroom, Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 1419
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
The Interrupters with Masked Intruder
The Showbox Seattle Seattle, WA
Apr 10, 8:00 pm 2019
Wednesday
Apr 10
8:00 pm
The Interrupters with Masked Intruder
The Showbox, Seattle, WA
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football