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

July

The National
Riverside Theatre - WI Milwaukee Milwaukee, WI
Jul 30, 8:00 pm 2018
Monday
Jul 30
8:00 pm
The National
Riverside Theatre - WI, Milwaukee, WI
SELECT * from toolvenuepagelink WHERE venueid = 28355
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'

August

The National with Father John Misty
Historic Fort York Toronto Toronto, ON
Aug 4, 2:30 pm 2018
Saturday
Aug 4
2:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 670
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'

September

The National
Hollywood Palladium Los Angeles Los Angeles, CA
Sep 20, 8:00 pm 2018
Thursday
Sep 20
8:00 pm
The National
Hollywood Palladium, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 670
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
The National
Hollywood Palladium Los Angeles Los Angeles, CA
Sep 21, 8:00 pm 2018
Friday
Sep 21
8:00 pm
The National
Hollywood Palladium, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 1785
SELECT * from toolcitypagelink WHERE cityname = 'Berkeley'
The National (Rescheduled from 10/14/17)
Greek Theatre - Berkeley Berkeley Berkeley, CA
Sep 24, 7:30 pm 2018
Monday
Sep 24
7:30 pm
The National (Rescheduled from 10/14/17)
Greek Theatre - Berkeley, Berkeley, CA
SELECT * from toolvenuepagelink WHERE venueid = 1785
SELECT * from toolcitypagelink WHERE cityname = 'Berkeley'
The National (Rescheduled from 10/15/17)
Greek Theatre - Berkeley Berkeley Berkeley, CA
Sep 25, 6:30 pm 2018
Tuesday
Sep 25
6:30 pm
The National (Rescheduled from 10/15/17)
Greek Theatre - Berkeley, Berkeley, CA
SELECT * from toolvenuepagelink WHERE venueid = 917
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
The National
Mann Center for the Performing Arts Philadelphia Philadelphia, PA
Sep 27, 7:00 pm 2018
Thursday
Sep 27
7:00 pm
The National
Mann Center for the Performing Arts, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 984
SELECT * from toolcitypagelink WHERE cityname = 'Columbia'
The National
Merriweather Post Pavilion Columbia Columbia, MD
Sep 28, 7:00 pm 2018
Friday
Sep 28
7:00 pm
The National
Merriweather Post Pavilion, Columbia, MD
SELECT * from toolvenuepagelink WHERE venueid = 1290
SELECT * from toolcitypagelink WHERE cityname = 'Morrison'

October

The National
Red Rocks Amphitheatre Morrison Morrison, CO
Oct 9, 7:30 pm 2018
Tuesday
Oct 9
7:30 pm
The National
Red Rocks Amphitheatre, Morrison, CO
SELECT * from toolvenuepagelink WHERE venueid = 1785
SELECT * from toolcitypagelink WHERE cityname = 'Berkeley'
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