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 = 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 = 1388
SELECT * from toolcitypagelink WHERE cityname = 'Santa Barbara'
The National with Phoebe Bridgers
Santa Barbara Bowl Santa Barbara Santa Barbara, CA
Sep 22, 7:00 pm 2018
Saturday
Sep 22
7:00 pm
The National with Phoebe Bridgers
Santa Barbara Bowl, Santa Barbara, 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 = 520
SELECT * from toolcitypagelink WHERE cityname = 'Forest Hills'
The National - 2 Day Pass
Forest Hills Stadium Forest Hills Forest Hills, NY
Sep 29, 3:29 pm 2018
Saturday
Sep 29
3:29 pm
The National - 2 Day Pass
Forest Hills Stadium, Forest Hills, NY
SELECT * from toolvenuepagelink WHERE venueid = 520
SELECT * from toolcitypagelink WHERE cityname = 'Forest Hills'
The National - Saturday
Forest Hills Stadium Forest Hills Forest Hills, NY
Sep 29, 3:30 pm 2018
Saturday
Sep 29
3:30 pm
The National - Saturday
Forest Hills Stadium, Forest Hills, NY
SELECT * from toolvenuepagelink WHERE venueid = 520
SELECT * from toolcitypagelink WHERE cityname = 'Forest Hills'
The National - Sunday
Forest Hills Stadium Forest Hills Forest Hills, NY
Sep 30, 3:30 pm 2018
Sunday
Sep 30
3:30 pm
The National - Sunday
Forest Hills Stadium, Forest Hills, NY
SELECT * from toolvenuepagelink WHERE venueid = 4402
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'

October

The National with Alvvays
Palladium Ballroom Dallas Dallas, TX
Oct 6, 8:00 pm 2018
Saturday
Oct 6
8:00 pm
The National with Alvvays
Palladium Ballroom, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 2013
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Christmas at The National
Starlight Theatre Kansas City Kansas City, MO
Oct 7, 7:00 pm 2018
Sunday
Oct 7
7:00 pm
Christmas at The National
Starlight Theatre, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 1290
SELECT * from toolcitypagelink WHERE cityname = 'Morrison'
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