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 = 496
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'

January

King Princess
First Avenue Minneapolis Minneapolis, MN
Jan 17, 7:00 pm 2019
Thursday
Jan 17
7:00 pm
King Princess
First Avenue, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 2164
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
King Princess
Metro Smart Bar Chicago Chicago, IL
Jan 18, 8:00 pm 2019
Friday
Jan 18
8:00 pm
King Princess
Metro Smart Bar, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 2992
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
King Princess
Danforth Music Hall Toronto Toronto, ON
Jan 20, 7:00 pm 2019
Sunday
Jan 20
7:00 pm
King Princess
Danforth Music Hall, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 18123
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
King Princess
Corona Theatre Montreal Montreal, QC
Jan 21, 8:00 pm 2019
Monday
Jan 21
8:00 pm
King Princess
Corona Theatre, Montreal, QC
SELECT * from toolvenuepagelink WHERE venueid = 28442
SELECT * from toolcitypagelink WHERE cityname = 'Brooklyn'
King Princess
Warsaw Brooklyn Brooklyn, NY
Jan 23, 8:00 pm 2019
Wednesday
Jan 23
8:00 pm
King Princess
Warsaw, Brooklyn, NY
SELECT * from toolvenuepagelink WHERE venueid = 725
SELECT * from toolcitypagelink WHERE cityname = 'New York'
King Princess
Irving Plaza New York New York, NY
Jan 24, 7:00 pm 2019
Thursday
Jan 24
7:00 pm
King Princess
Irving Plaza, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 3427
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
King Princess
Royale Boston Boston Boston, MA
Jan 25, 7:00 pm 2019
Friday
Jan 25
7:00 pm
King Princess
Royale Boston, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 1959
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
King Princess
9:30 Club Washington Washington, DC
Jan 27, 7:00 pm 2019
Sunday
Jan 27
7:00 pm
King Princess
9:30 Club, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 856
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
King Princess
Theatre of Living Arts Philadelphia Philadelphia, PA
Jan 28, 8:00 pm 2019
Monday
Jan 28
8:00 pm
King Princess
Theatre of Living Arts, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 28994
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
King Princess
Terminal West Atlanta Atlanta, GA
Jan 30, 8:00 pm 2019
Wednesday
Jan 30
8:00 pm
King Princess
Terminal West, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 2483
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
King Princess
Exit/In Nashville Nashville, TN
Jan 31, 8:00 pm 2019
Thursday
Jan 31
8:00 pm
King Princess
Exit/In, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 2329
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'

February

King Princess
Granada Theater - TX Dallas Dallas, TX
Feb 2, 8:00 pm 2019
Saturday
Feb 2
8:00 pm
King Princess
Granada Theater - TX, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 2171
SELECT * from toolcitypagelink WHERE cityname = 'Austin'
King Princess
Emo's East Austin Austin, TX
Feb 3, 7:30 pm 2019
Sunday
Feb 3
7:30 pm
King Princess
Emo's East, Austin, TX
SELECT * from toolvenuepagelink WHERE venueid = 28863
SELECT * from toolcitypagelink WHERE cityname = 'Phoenix'
King Princess
Crescent Ballroom - AZ Phoenix Phoenix, AZ
Feb 6, 8:00 pm 2019
Wednesday
Feb 6
8:00 pm
King Princess
Crescent Ballroom - AZ, Phoenix, AZ
SELECT * from toolvenuepagelink WHERE venueid = 651
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
King Princess
Henry Fonda Theatre Los Angeles Los Angeles, CA
Feb 7, 8:00 pm 2019
Thursday
Feb 7
8:00 pm
King Princess
Henry Fonda Theatre, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 651
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
King Princess
Henry Fonda Theatre Los Angeles Los Angeles, CA
Feb 8, 8:00 pm 2019
Friday
Feb 8
8:00 pm
King Princess
Henry Fonda Theatre, Los Angeles, CA
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
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football