LISTE POUR : Iron Maiden

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

July

Iron Maiden
BB&T Center Sunrise Sunrise, FL
Jul 18, 7:00 pm 2019
Thursday
Jul 18
7:00 pm
Iron Maiden
BB&T Center, Sunrise, FL
SELECT * from toolvenuepagelink WHERE venueid = 816
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Iron Maiden
Lakewood Amphitheatre Atlanta Atlanta, GA
Jul 20, 7:30 pm 2019
Saturday
Jul 20
7:30 pm
Iron Maiden
Lakewood Amphitheatre, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 1953
SELECT * from toolcitypagelink WHERE cityname = 'Charlotte'
Iron Maiden
PNC Music Pavilion - Charlotte Charlotte Charlotte, NC
Jul 22, 7:00 pm 2019
Monday
Jul 22
7:00 pm
Iron Maiden
PNC Music Pavilion - Charlotte, Charlotte, NC
SELECT * from toolvenuepagelink WHERE venueid = 1113
SELECT * from toolcitypagelink WHERE cityname = 'Bristow'
Iron Maiden
Jiffy Lube Live Bristow Bristow, VA
Jul 24, 7:30 pm 2019
Wednesday
Jul 24
7:30 pm
Iron Maiden
Jiffy Lube Live, Bristow, VA
SELECT * from toolvenuepagelink WHERE venueid = 27950
SELECT * from toolcitypagelink WHERE cityname = 'Brooklyn'
Iron Maiden
Barclays Center Brooklyn Brooklyn, NY
Jul 26, 7:00 pm 2019
Friday
Jul 26
7:00 pm
Iron Maiden
Barclays Center, Brooklyn, NY
SELECT * from toolvenuepagelink WHERE venueid = 27950
SELECT * from toolcitypagelink WHERE cityname = 'Brooklyn'
Iron Maiden
Barclays Center Brooklyn Brooklyn, NY
Jul 27, 7:00 pm 2019
Saturday
Jul 27
7:00 pm
Iron Maiden
Barclays Center, Brooklyn, NY
SELECT * from toolvenuepagelink WHERE venueid = 499
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
Iron Maiden
Wells Fargo Center Philadelphia Philadelphia, PA
Jul 30, 7:30 pm 2019
Tuesday
Jul 30
7:30 pm
Iron Maiden
Wells Fargo Center, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 1618
SELECT * from toolcitypagelink WHERE cityname = 'Mansfield'

August

Iron Maiden
Xfinity Center Mansfield Mansfield, MA
Aug 1, 7:30 pm 2019
Thursday
Aug 1
7:30 pm
Iron Maiden
Xfinity Center, Mansfield, MA
SELECT * from toolvenuepagelink WHERE venueid = 966
SELECT * from toolcitypagelink WHERE cityname = 'Hartford'
Iron Maiden
Xfinity Theatre Hartford Hartford, CT
Aug 3, 7:30 pm 2019
Saturday
Aug 3
7:30 pm
Iron Maiden
Xfinity Theatre, Hartford, CT
SELECT * from toolvenuepagelink WHERE venueid = 1036
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Iron Maiden
Bell Centre Montreal Montreal, QC
Aug 5, 7:30 pm 2019
Monday
Aug 5
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 32366
SELECT * from toolcitypagelink WHERE cityname = 'Quebec'
Iron Maiden
Centre Videotron Quebec Quebec, QC
Aug 7, 7:30 pm 2019
Wednesday
Aug 7
7:30 pm
Iron Maiden
Centre Videotron, Quebec, QC
SELECT * from toolvenuepagelink WHERE venueid = 1035
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Iron Maiden
Budweiser Stage Toronto Toronto, ON
Aug 9, 7:30 pm 2019
Friday
Aug 9
7:30 pm
Iron Maiden
Budweiser Stage, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 1035
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Iron Maiden
Budweiser Stage Toronto Toronto, ON
Aug 10, 7:30 pm 2019
Saturday
Aug 10
7:30 pm
Iron Maiden
Budweiser Stage, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 1786
SELECT * from toolcitypagelink WHERE cityname = 'Buffalo'
Iron Maiden
KeyBank Center Buffalo Buffalo, NY
Aug 13, 7:30 pm 2019
Tuesday
Aug 13
7:30 pm
Iron Maiden
KeyBank Center, Buffalo, NY
SELECT * from toolvenuepagelink WHERE venueid = 1315
SELECT * from toolcitypagelink WHERE cityname = 'Cincinnati'
Iron Maiden
Riverbend Music Center Cincinnati Cincinnati, OH
Aug 15, 7:30 pm 2019
Thursday
Aug 15
7:30 pm
Iron Maiden
Riverbend Music Center, Cincinnati, OH
SELECT * from toolvenuepagelink WHERE venueid = 7329
SELECT * from toolcitypagelink WHERE cityname = 'Pittsburgh'
Iron Maiden
PPG Paints Arena Pittsburgh Pittsburgh, PA
Aug 17, 7:30 pm 2019
Saturday
Aug 17
7:30 pm
Iron Maiden
PPG Paints Arena, Pittsburgh, PA
SELECT * from toolvenuepagelink WHERE venueid = 1080
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
Iron Maiden
Bridgestone Arena Nashville Nashville, TN
Aug 19, 7:00 pm 2019
Monday
Aug 19
7:00 pm
Iron Maiden
Bridgestone Arena, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 1105
SELECT * from toolcitypagelink WHERE cityname = 'Tinley Park'
Iron Maiden
Hollywood Casino Amphitheatre - IL Tinley Park Tinley Park, IL
Aug 22, 7:30 pm 2019
Thursday
Aug 22
7:30 pm
Iron Maiden
Hollywood Casino Amphitheatre - IL, Tinley Park, IL
SELECT * from toolvenuepagelink WHERE venueid = 1937
SELECT * from toolcitypagelink WHERE cityname = 'Noblesville'
Iron Maiden
Ruoff Home Mortgage Music Center Noblesville Noblesville, IN
Aug 24, 7:30 pm 2019
Saturday
Aug 24
7:30 pm
Iron Maiden
Ruoff Home Mortgage Music Center, Noblesville, IN
SELECT * from toolvenuepagelink WHERE venueid = 1811
SELECT * from toolcitypagelink WHERE cityname = 'St Paul'
Iron Maiden
Xcel Energy Center St Paul St Paul, MN
Aug 26, 7:00 pm 2019
Monday
Aug 26
7:00 pm
Iron Maiden
Xcel Energy Center, St Paul, MN
SELECT * from toolvenuepagelink WHERE venueid = 3316
SELECT * from toolcitypagelink WHERE cityname = 'Winnipeg'
Iron Maiden
Bell MTS Place Winnipeg Winnipeg, MB
Aug 28, 7:30 pm 2019
Wednesday
Aug 28
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 33142
SELECT * from toolcitypagelink WHERE cityname = 'Edmonton'
Iron Maiden
Rogers Place Edmonton Edmonton, AB
Aug 30, 7:30 pm 2019
Friday
Aug 30
7:30 pm
Iron Maiden
Rogers Place, Edmonton, AB
SELECT * from toolvenuepagelink WHERE venueid = 1367
SELECT * from toolcitypagelink WHERE cityname = 'Calgary'
Iron Maiden
Scotiabank Saddledome Calgary Calgary, AB
Aug 31, 7:30 pm 2019
Saturday
Aug 31
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 557
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'

September

Iron Maiden
Rogers Arena Vancouver Vancouver, BC
Sep 3, 7:30 pm 2019
Tuesday
Sep 3
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 1526
SELECT * from toolcitypagelink WHERE cityname = 'Tacoma'
Iron Maiden
Tacoma Dome Tacoma Tacoma, WA
Sep 5, 7:30 pm 2019
Thursday
Sep 5
7:30 pm
Iron Maiden
Tacoma Dome, Tacoma, WA
SELECT * from toolvenuepagelink WHERE venueid = 1343
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Iron Maiden
Moda Center Portland Portland, OR
Sep 6, 7:30 pm 2019
Friday
Sep 6
7:30 pm
Iron Maiden
Moda Center, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 32836
SELECT * from toolcitypagelink WHERE cityname = 'Sacramento'
Iron Maiden
Golden 1 Center Sacramento Sacramento, CA
Sep 9, 7:00 pm 2019
Monday
Sep 9
7:00 pm
Iron Maiden
Golden 1 Center, Sacramento, CA
SELECT * from toolvenuepagelink WHERE venueid = 1129
SELECT * from toolcitypagelink WHERE cityname = 'Oakland'
Iron Maiden
Oracle Arena Oakland Oakland, CA
Sep 10, 7:30 pm 2019
Tuesday
Sep 10
7:30 pm
Iron Maiden
Oracle Arena, Oakland, CA
SELECT * from toolvenuepagelink WHERE venueid = 996
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'
Iron Maiden
MGM Grand Garden Arena Las Vegas Las Vegas, NV
Sep 13, 7:30 pm 2019
Friday
Sep 13
7:30 pm
Iron Maiden
MGM Grand Garden Arena, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 33676
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Iron Maiden
Banc of California Stadium Los Angeles Los Angeles, CA
Sep 14, 7:00 pm 2019
Saturday
Sep 14
7:00 pm
Iron Maiden
Banc of California Stadium, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 43
SELECT * from toolcitypagelink WHERE cityname = 'Phoenix'
Iron Maiden
Talking Stick Resort Arena Phoenix Phoenix, AZ
Sep 17, 7:00 pm 2019
Tuesday
Sep 17
7:00 pm
Iron Maiden
Talking Stick Resort Arena, Phoenix, AZ
SELECT * from toolvenuepagelink WHERE venueid = 1940
SELECT * from toolcitypagelink WHERE cityname = 'Albuquerque'
Iron Maiden
Isleta Amphitheater Albuquerque Albuquerque, NM
Sep 19, 7:00 pm 2019
Thursday
Sep 19
7:00 pm
Iron Maiden
Isleta Amphitheater, Albuquerque, NM
SELECT * from toolvenuepagelink WHERE venueid = 1815
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Iron Maiden
Dos Equis Pavilion Dallas Dallas, TX
Sep 21, 7:30 pm 2019
Saturday
Sep 21
7:30 pm
Iron Maiden
Dos Equis Pavilion, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 1760
SELECT * from toolcitypagelink WHERE cityname = 'Spring'
Iron Maiden
The Cynthia Woods Mitchell Pavilion Spring Spring, TX
Sep 22, 7:30 pm 2019
Sunday
Sep 22
7:30 pm
Iron Maiden
The Cynthia Woods Mitchell Pavilion, Spring, TX
SELECT * from toolvenuepagelink WHERE venueid = 2259
SELECT * from toolcitypagelink WHERE cityname = 'San Antonio'
Iron Maiden
AT&T Center San Antonio San Antonio, TX
Sep 25, 7:00 pm 2019
Wednesday
Sep 25
7:00 pm
Iron Maiden
AT&T Center, San Antonio, TX
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football