LISTE POUR : King Princess

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

April

King Princess
The Fillmore - San Francisco San Francisco San Francisco, CA
Apr 22, 8:00 pm 2019
Monday
Apr 22
8:00 pm
King Princess
The Fillmore - San Francisco, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 4059
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
King Princess
Wonder Ballroom Portland Portland, OR
Apr 24, 8:00 pm 2019
Wednesday
Apr 24
8:00 pm
King Princess
Wonder Ballroom, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 1692
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
King Princess
Vogue Theatre Vancouver Vancouver, BC
Apr 25, 7:00 pm 2019
Thursday
Apr 25
7:00 pm
King Princess
Vogue Theatre, Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 1419
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
King Princess
The Showbox Seattle Seattle, WA
Apr 26, 8:30 pm 2019
Friday
Apr 26
8:30 pm
King Princess
The Showbox, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 18123
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'

May

King Princess
Corona Theatre Montreal Montreal, QC
May 24, 8:00 pm 2019
Friday
May 24
8:00 pm
King Princess
Corona Theatre, Montreal, QC
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football