LISTE POUR : The National

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

December

The National
Lyric Opera's Civic Opera House Chicago Chicago, IL
Dec 13, 7:00 pm 2017
Wednesday
Dec 13
7:00 pm
The National
Lyric Opera's Civic Opera House, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 633
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'

January

The National
The Joint – Hard Rock Hotel Las Vegas Las Vegas Las Vegas, NV
Jan 20, 8:00 pm 2018
Saturday
Jan 20
8:00 pm
The National
The Joint – Hard Rock Hotel Las Vegas, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 1785
SELECT * from toolcitypagelink WHERE cityname = 'Berkeley'

October

The National
Greek Theatre - Berkeley Berkeley Berkeley, CA
Oct 15, 3:30 pm 2018
Monday
Oct 15
3:30 pm
The National
Greek Theatre - Berkeley, Berkeley, CA
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football