LISTE POUR : Avenged Sevenfold

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

July

Avenged Sevenfold
Harbour Station St John St John, NB
Jul 17, 7:30 pm 2018
Tuesday
Jul 17
7:30 pm
Avenged Sevenfold
Harbour Station, St John, NB
SELECT * from toolvenuepagelink WHERE venueid = 32674
SELECT * from toolcitypagelink WHERE cityname = 'Syracuse'
Avenged Sevenfold
Lakeview Amphitheater Syracuse Syracuse, NY
Jul 21, 8:00 pm 2018
Saturday
Jul 21
8:00 pm
Avenged Sevenfold
Lakeview Amphitheater, Syracuse, NY
SELECT * from toolvenuepagelink WHERE venueid = 1618
SELECT * from toolcitypagelink WHERE cityname = 'Mansfield'
Avenged Sevenfold with Prophets of Rage
Xfinity Center (Formerly Comcast Center) Mansfield Mansfield, MA
Jul 22, 5:30 pm 2018
Sunday
Jul 22
5:30 pm
Avenged Sevenfold with Prophets of Rage
Xfinity Center (Formerly Comcast Center), Mansfield, MA
SELECT * from toolvenuepagelink WHERE venueid = 756
SELECT * from toolcitypagelink WHERE cityname = 'Wantagh'
Avenged Sevenfold
Northwell Health at Jones Beach Theater Wantagh Wantagh, NY
Jul 25, 5:30 pm 2018
Wednesday
Jul 25
5:30 pm
Avenged Sevenfold
Northwell Health at Jones Beach Theater, Wantagh, NY
SELECT * from toolvenuepagelink WHERE venueid = 966
SELECT * from toolcitypagelink WHERE cityname = 'Hartford'
Avenged Sevenfold and Prophet of Rage
Xfinity Theatre Hartford Hartford, CT
Jul 26, 5:30 pm 2018
Thursday
Jul 26
5:30 pm
Avenged Sevenfold and Prophet of Rage
Xfinity Theatre, Hartford, CT
SELECT * from toolvenuepagelink WHERE venueid = 1243
SELECT * from toolcitypagelink WHERE cityname = 'Holmdel'
Avenged Sevenfold
PNC Bank Arts Center Holmdel Holmdel, NJ
Jul 31, 5:30 pm 2018
Tuesday
Jul 31
5:30 pm
Avenged Sevenfold
PNC Bank Arts Center, Holmdel, NJ
SELECT * from toolvenuepagelink WHERE venueid = 1113
SELECT * from toolcitypagelink WHERE cityname = 'Bristow'

August

Avenged Sevenfold
Jiffy Lube Live Bristow Bristow, VA
Aug 1, 5:30 pm 2018
Wednesday
Aug 1
5:30 pm
Avenged Sevenfold
Jiffy Lube Live, Bristow, VA
SELECT * from toolvenuepagelink WHERE venueid = 33414
SELECT * from toolcitypagelink WHERE cityname = 'Burgettstown '
Avenged Sevenfold
KeyBank Pavilion Burgettstown Burgettstown , PA
Aug 3, 5:30 pm 2018
Friday
Aug 3
5:30 pm
Avenged Sevenfold
KeyBank Pavilion, Burgettstown , PA
SELECT * from toolvenuepagelink WHERE venueid = 1315
SELECT * from toolcitypagelink WHERE cityname = 'Cincinnati'
Avenged Sevenfold
Riverbend Music Center Cincinnati Cincinnati, OH
Aug 4, 5:30 pm 2018
Saturday
Aug 4
5:30 pm
Avenged Sevenfold
Riverbend Music Center, Cincinnati, OH
SELECT * from toolvenuepagelink WHERE venueid = 156
SELECT * from toolcitypagelink WHERE cityname = 'Cuyahoga Falls'
Avenged Sevenfold
Blossom Music Center Cuyahoga Falls Cuyahoga Falls, OH
Aug 6, 5:30 pm 2018
Monday
Aug 6
5:30 pm
Avenged Sevenfold
Blossom Music Center, Cuyahoga Falls, OH
SELECT * from toolvenuepagelink WHERE venueid = 1963
SELECT * from toolcitypagelink WHERE cityname = 'Clarkston'
Avenged Sevenfold
DTE Energy Music Theatre Clarkston Clarkston, MI
Aug 7, 5:30 pm 2018
Tuesday
Aug 7
5:30 pm
Avenged Sevenfold
DTE Energy Music Theatre, Clarkston, MI
SELECT * from toolvenuepagelink WHERE venueid = 1035
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Avenged Sevenfold
Budweiser Stage Toronto Toronto, ON
Aug 9, 5:30 pm 2018
Thursday
Aug 9
5:30 pm
Avenged Sevenfold
Budweiser Stage, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 1105
SELECT * from toolcitypagelink WHERE cityname = 'Tinley Park'
Avenged Sevenfold
Hollywood Casino Amphitheatre - IL Tinley Park Tinley Park, IL
Aug 11, 5:30 pm 2018
Saturday
Aug 11
5:30 pm
Avenged Sevenfold
Hollywood Casino Amphitheatre - IL, Tinley Park, IL
SELECT * from toolvenuepagelink WHERE venueid = 1937
SELECT * from toolcitypagelink WHERE cityname = 'Noblesville'
Avenged Sevenfold
Ruoff Home Mortgage Music Center Noblesville Noblesville, IN
Aug 12, 5:30 pm 2018
Sunday
Aug 12
5:30 pm
Avenged Sevenfold
Ruoff Home Mortgage Music Center, Noblesville, IN
SELECT * from toolvenuepagelink WHERE venueid = 403
SELECT * from toolcitypagelink WHERE cityname = 'Phoenix'
Avenged Sevenfold
Ak-Chin Pavilion Phoenix Phoenix, AZ
Aug 16, 5:30 pm 2018
Thursday
Aug 16
5:30 pm
Avenged Sevenfold
Ak-Chin Pavilion, Phoenix, AZ
SELECT * from toolvenuepagelink WHERE venueid = 32725
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'
Avenged Sevenfold
T-Mobile Arena Las Vegas Las Vegas, NV
Aug 17, 7:00 pm 2018
Friday
Aug 17
7:00 pm
Avenged Sevenfold
T-Mobile Arena, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 1940
SELECT * from toolcitypagelink WHERE cityname = 'Albuquerque'
Avenged Sevenfold
Isleta Amphitheater Albuquerque Albuquerque, NM
Aug 19, 5:30 pm 2018
Sunday
Aug 19
5:30 pm
Avenged Sevenfold
Isleta Amphitheater, Albuquerque, NM
SELECT * from toolvenuepagelink WHERE venueid = 338
SELECT * from toolcitypagelink WHERE cityname = 'Chula Vista'
Avenged Sevenfold
Mattress Firm Amphitheatre Chula Vista Chula Vista, CA
Aug 21, 5:30 pm 2018
Tuesday
Aug 21
5:30 pm
Avenged Sevenfold
Mattress Firm Amphitheatre, Chula Vista, CA
SELECT * from toolvenuepagelink WHERE venueid = 602
SELECT * from toolcitypagelink WHERE cityname = 'Inglewood'
Avenged Sevenfold
The Forum Inglewood Inglewood, CA
Aug 22, 5:30 pm 2018
Wednesday
Aug 22
5:30 pm
Avenged Sevenfold
The Forum, Inglewood, CA
SELECT * from toolvenuepagelink WHERE venueid = 1780
SELECT * from toolcitypagelink WHERE cityname = 'Concord'
Avenged Sevenfold
Concord Pavilion Concord Concord, CA
Aug 24, 5:30 pm 2018
Friday
Aug 24
5:30 pm
Avenged Sevenfold
Concord Pavilion, Concord, CA
SELECT * from toolvenuepagelink WHERE venueid = 2573
SELECT * from toolcitypagelink WHERE cityname = 'West Valley City'
Avenged Sevenfold
Usana Amphitheatre West Valley City West Valley City, UT
Aug 28, 5:30 pm 2018
Tuesday
Aug 28
5:30 pm
Avenged Sevenfold
Usana Amphitheatre, West Valley City, UT
SELECT * from toolvenuepagelink WHERE venueid = 1219
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Avenged Sevenfold
Pepsi Center Denver Denver, CO
Aug 30, 5:30 pm 2018
Thursday
Aug 30
5:30 pm
Avenged Sevenfold
Pepsi Center, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 1815
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'

September

Avenged Sevenfold
Dos Equis Pavilion Dallas Dallas, TX
Sep 1, 5:30 pm 2018
Saturday
Sep 1
5:30 pm
Avenged Sevenfold
Dos Equis Pavilion, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 1760
SELECT * from toolcitypagelink WHERE cityname = 'Spring'
Avenged Sevenfold
The Cynthia Woods Mitchell Pavilion Spring Spring, TX
Sep 2, 5:30 pm 2018
Sunday
Sep 2
5:30 pm
Avenged Sevenfold
The Cynthia Woods Mitchell Pavilion, Spring, TX
SELECT * from toolvenuepagelink WHERE venueid = 155
SELECT * from toolcitypagelink WHERE cityname = 'Camden'

October

Papa Roach with Avenged Sevenfold and Bullet For My Valentine
BB&T Pavilion Camden Camden, NJ
Oct 6, 12:00 pm 2018
Saturday
Oct 6
12:00 pm
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football