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

January

Avenged Sevenfold with Breaking Benjamin
Bridgestone Arena Nashville Nashville, TN
Jan 12, 6:30 pm 2018
Friday
Jan 12
6:30 pm
Avenged Sevenfold with Breaking Benjamin
Bridgestone Arena, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 1663
SELECT * from toolcitypagelink WHERE cityname = 'Grand Rapids'
Avenged Sevenfold with Breaking Benjamin
Van Andel Arena Grand Rapids Grand Rapids, MI
Jan 14, 6:30 pm 2018
Sunday
Jan 14
6:30 pm
Avenged Sevenfold with Breaking Benjamin
Van Andel Arena, Grand Rapids, MI
SELECT * from toolvenuepagelink WHERE venueid = 8417
SELECT * from toolcitypagelink WHERE cityname = 'Reading'
Avenged Sevenfold with Breaking Benjamin
Santander Arena Reading Reading, PA
Jan 16, 6:30 pm 2018
Tuesday
Jan 16
6:30 pm
Avenged Sevenfold with Breaking Benjamin
Santander Arena, Reading, PA
SELECT * from toolvenuepagelink WHERE venueid = 196
SELECT * from toolcitypagelink WHERE cityname = 'State College'
Avenged Sevenfold with Breaking Benjamin
Bryce Jordan Center State College State College, PA
Jan 17, 6:30 pm 2018
Wednesday
Jan 17
6:30 pm
Avenged Sevenfold with Breaking Benjamin
Bryce Jordan Center, State College, PA
SELECT * from toolvenuepagelink WHERE venueid = 32366
SELECT * from toolcitypagelink WHERE cityname = 'Quebec'
Avenged Sevenfold with Breaking Benjamin
Centre Videotron Quebec Quebec, QC
Jan 19, 6:25 pm 2018
Friday
Jan 19
6:25 pm
Avenged Sevenfold with Breaking Benjamin
Centre Videotron, Quebec, QC
SELECT * from toolvenuepagelink WHERE venueid = 345
SELECT * from toolcitypagelink WHERE cityname = 'Kanata'
Avenged Sevenfold with Breaking Benjamin
Canadian Tire Centre Kanata Kanata, ON
Jan 21, 7:00 pm 2018
Sunday
Jan 21
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 33464
SELECT * from toolcitypagelink WHERE cityname = 'Hamilton'
Avenged Sevenfold with Breaking Benjamin
FirstOntario Concert Hall Hamilton Hamilton, ON
Jan 22, 7:00 pm 2018
Monday
Jan 22
7:00 pm
Avenged Sevenfold with Breaking Benjamin
FirstOntario Concert Hall, Hamilton, ON
SELECT * from toolvenuepagelink WHERE venueid = 2390
SELECT * from toolcitypagelink WHERE cityname = 'Green Bay'
Avenged Sevenfold with Breaking Benjamin
Resch Center Green Bay Green Bay, WI
Jan 24, 6:30 pm 2018
Wednesday
Jan 24
6:30 pm
Avenged Sevenfold with Breaking Benjamin
Resch Center, Green Bay, WI
SELECT * from toolvenuepagelink WHERE venueid = 1216
SELECT * from toolcitypagelink WHERE cityname = 'Peoria'
Avenged Sevenfold with Breaking Benjamin
Peoria Civic Center Peoria Peoria, IL
Jan 25, 8:30 pm 2018
Thursday
Jan 25
8:30 pm
Avenged Sevenfold with Breaking Benjamin
Peoria Civic Center, Peoria, IL
SELECT * from toolvenuepagelink WHERE venueid = 30766
SELECT * from toolcitypagelink WHERE cityname = 'Sioux Falls'
Avenged Sevenfold with Breaking Benjamin
Denny Sanford Premier Center Sioux Falls Sioux Falls, SD
Jan 27, 6:30 pm 2018
Saturday
Jan 27
6:30 pm
Avenged Sevenfold with Breaking Benjamin
Denny Sanford Premier Center, Sioux Falls, SD
SELECT * from toolvenuepagelink WHERE venueid = 5118
SELECT * from toolcitypagelink WHERE cityname = 'Tulsa'
Avenged Sevenfold
BOK Center Tulsa Tulsa, OK
Jan 29, 6:25 pm 2018
Monday
Jan 29
6:25 pm
Avenged Sevenfold
BOK Center, Tulsa, OK
SELECT * from toolvenuepagelink WHERE venueid = 1025
SELECT * from toolcitypagelink WHERE cityname = 'Biloxi'
Avenged Sevenfold with Breaking Benjamin
Mississippi Coast Coliseum Biloxi Biloxi, MS
Jan 31, 6:30 pm 2018
Wednesday
Jan 31
6:30 pm
Avenged Sevenfold with Breaking Benjamin
Mississippi Coast Coliseum, Biloxi, MS
SELECT * from toolvenuepagelink WHERE venueid = 34
SELECT * from toolcitypagelink WHERE cityname = 'North Little Rock'

February

Avenged Sevenfold with Breaking Benjamin
Verizon Arena North Little Rock North Little Rock, AR
Feb 2, 6:30 pm 2018
Friday
Feb 2
6:30 pm
Avenged Sevenfold with Breaking Benjamin
Verizon Arena, North Little Rock, AR
SELECT * from toolvenuepagelink WHERE venueid = 7992
SELECT * from toolcitypagelink WHERE cityname = 'Evansville'
Avenged Sevenfold with Breaking Benjamin
Ford Center - Evansville Evansville Evansville, IN
Feb 3, 6:25 pm 2018
Saturday
Feb 3
6:25 pm
Avenged Sevenfold with Breaking Benjamin
Ford Center - Evansville, Evansville, IN
SELECT * from toolvenuepagelink WHERE venueid = 7099
SELECT * from toolcitypagelink WHERE cityname = 'Wichita'
Avenged Sevenfold with Breaking Benjamin
INTRUST Bank Arena Wichita Wichita, KS
Feb 6, 6:30 pm 2018
Tuesday
Feb 6
6:30 pm
Avenged Sevenfold with Breaking Benjamin
INTRUST Bank Arena, Wichita, KS
SELECT * from toolvenuepagelink WHERE venueid = 30074
SELECT * from toolcitypagelink WHERE cityname = 'Lincoln'
Avenged Sevenfold with Breaking Benjamin
Pinnacle Bank Arena Lincoln Lincoln, NE
Feb 8, 8:00 pm 2018
Thursday
Feb 8
8:00 pm
Avenged Sevenfold with Breaking Benjamin
Pinnacle Bank Arena, Lincoln, NE
SELECT * from toolvenuepagelink WHERE venueid = 2524
SELECT * from toolcitypagelink WHERE cityname = 'Cedar Rapids'
Avenged Sevenfold with Breaking Benjamin
US Cellular Center Cedar Rapids Cedar Rapids, IA
Feb 9, 6:30 pm 2018
Friday
Feb 9
6:30 pm
Avenged Sevenfold with Breaking Benjamin
US Cellular Center, Cedar Rapids, IA
SELECT * from toolvenuepagelink WHERE venueid = 481
SELECT * from toolcitypagelink WHERE cityname = 'Fargo'
Avenged Sevenfold with Breaking Benjamin
Fargodome Fargo Fargo, ND
Feb 11, 6:30 pm 2018
Sunday
Feb 11
6:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 3316
SELECT * from toolcitypagelink WHERE cityname = 'Winnipeg'
Avenged Sevenfold with Breaking Benjamin
Bell MTS Place Winnipeg Winnipeg, MB
Feb 12, 6:00 pm 2018
Monday
Feb 12
6:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 3308
SELECT * from toolcitypagelink WHERE cityname = 'Saskatoon'
Avenged Sevenfold with Breaking Benjamin
SaskTel Centre Saskatoon Saskatoon, SK
Feb 14, 6:00 pm 2018
Wednesday
Feb 14
6:00 pm
Avenged Sevenfold with Breaking Benjamin
SaskTel Centre, Saskatoon, SK
SELECT * from toolvenuepagelink WHERE venueid = 33142
SELECT * from toolcitypagelink WHERE cityname = 'Edmonton'
Avenged Sevenfold with Breaking Benjamin
Rogers Place Edmonton Edmonton, AB
Feb 15, 6:00 pm 2018
Thursday
Feb 15
6:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 1173
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Avenged Sevenfold with Breaking Benjamin
Pacific Coliseum Vancouver Vancouver, BC
Feb 17, 6:00 pm 2018
Saturday
Feb 17
6: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
NOUVELLES - SPORT