LISTE POUR : Snail Mail

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

January

Snail Mail
Metropolis Montreal Montreal, QC
Jan 17, 9:00 pm 2019
Thursday
Jan 17
9:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 2164
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Snail Mail
Metro Smart Bar Chicago Chicago, IL
Jan 17, 9:00 pm 2019
Thursday
Jan 17
9:00 pm
Snail Mail
Metro Smart Bar, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 9067
SELECT * from toolcitypagelink WHERE cityname = 'Austin'
Snail Mail
Mohawk Austin Austin, TX
Jan 19, 8:00 pm 2019
Saturday
Jan 19
8:00 pm
Snail Mail
Mohawk, Austin, TX
SELECT * from toolvenuepagelink WHERE venueid = 492
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Snail Mail
The Fillmore - San Francisco San Francisco San Francisco, CA
Jan 24, 8:00 pm 2019
Thursday
Jan 24
8:00 pm
Snail Mail
The Fillmore - San Francisco, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 8412
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Snail Mail
Aladdin Theater Portland Portland, OR
Jan 26, 9:00 pm 2019
Saturday
Jan 26
9:00 pm
Snail Mail
Aladdin Theater, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 31647
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Snail Mail
Imperial (Vancouver) Vancouver Vancouver, BC
Jan 27, 8:00 pm 2019
Sunday
Jan 27
8:00 pm
Snail Mail
Imperial (Vancouver), Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 7836
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Snail Mail
The Neptune Theatre Seattle Seattle, WA
Jan 28, 8:00 pm 2019
Monday
Jan 28
8:00 pm
Snail Mail
The Neptune Theatre, 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