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

April

The National
Sprint Pavilion Charlottesville Charlottesville, VA
Apr 30, 7:00 pm 2018
Monday
Apr 30
7:00 pm
The National
Sprint Pavilion, Charlottesville, VA
SELECT * from toolvenuepagelink WHERE venueid = 7333
SELECT * from toolcitypagelink WHERE cityname = 'Raleigh'

May

The National
Red Hat Amphitheatre (Formerly Raleigh Amphitheatre) Raleigh Raleigh, NC
May 1, 7:30 pm 2018
Tuesday
May 1
7:30 pm
The National
Red Hat Amphitheatre (Formerly Raleigh Amphitheatre), Raleigh, NC
SELECT * from toolvenuepagelink WHERE venueid = 32385
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
The National
Ascend Amphitheater Nashville Nashville, TN
May 3, 7:30 pm 2018
Thursday
May 3
7:30 pm
The National
Ascend Amphitheater, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 1808
SELECT * from toolcitypagelink WHERE cityname = 'Milwaukee'
The National
US Cellular Arena Milwaukee Milwaukee, WI
May 4, 7:30 pm 2018
Friday
May 4
7:30 pm
The National
US Cellular Arena, Milwaukee, WI
SELECT * from toolvenuepagelink WHERE venueid = 1564
SELECT * from toolcitypagelink WHERE cityname = 'Asheville'
The National
Thomas Wolfe Auditorium at US Cellular Center Asheville Asheville, NC
May 4, 8:00 pm 2018
Friday
May 4
8:00 pm
The National
Thomas Wolfe Auditorium at US Cellular Center, Asheville, NC
SELECT * from toolvenuepagelink WHERE venueid = 5369
SELECT * from toolcitypagelink WHERE cityname = 'St Augustine'
The National
St Augustine Amphitheatre St Augustine St Augustine, FL
May 5, 7:30 pm 2018
Saturday
May 5
7:30 pm
The National
St Augustine Amphitheatre, St Augustine, FL
SELECT * from toolvenuepagelink WHERE venueid = 1785
SELECT * from toolcitypagelink WHERE cityname = 'Berkeley'

September

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 = 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