LISTE POUR : Senses Fail

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

January

Senses Fail
The Palladium - MA Worcester Worcester, MA
Jan 19, 7:15 pm 2019
Saturday
Jan 19
7:15 pm
Senses Fail
The Palladium - MA, Worcester, MA
SELECT * from toolvenuepagelink WHERE venueid = 304
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Senses Fail with The Amity Affliction
Club Soda Montreal Montreal, QC
Jan 24, 7:00 pm 2019
Thursday
Jan 24
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 2885
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Senses Fail
Phoenix Concert Theatre Toronto Toronto, ON
Jan 25, 6:30 pm 2019
Friday
Jan 25
6:30 pm
Senses Fail
Phoenix Concert Theatre, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 30272
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Senses Fail and The Amity Affliction
Concord Music Hall Chicago Chicago, IL
Jan 30, 6:30 pm 2019
Wednesday
Jan 30
6:30 pm
Senses Fail and The Amity Affliction
Concord Music Hall, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 1419
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'

February

The Amity Affliction
The Showbox Seattle Seattle, WA
Feb 4, 7:00 pm 2019
Monday
Feb 4
7:00 pm
The Amity Affliction
The Showbox, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 2395
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Senses Fail with The Amity Affliction
McMenamins Crystal Ballroom Portland Portland, OR
Feb 5, 7:01 pm 2019
Tuesday
Feb 5
7:01 pm
Senses Fail with The Amity Affliction
McMenamins Crystal Ballroom, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 33248
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Senses Fail with The Amity Affliction
Regent Theater DTLA Los Angeles Los Angeles, CA
Feb 9, 7:15 pm 2019
Saturday
Feb 9
7:15 pm
Senses Fail with The Amity Affliction
Regent Theater DTLA, Los Angeles, CA
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football