LISTE POUR : Nightwish

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

March

Nightwish
The Tabernacle Atlanta Atlanta, GA
Mar 9, 8:30 pm 2018
Friday
Mar 9
8:30 pm
Nightwish
The Tabernacle, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 6693
SELECT * from toolcitypagelink WHERE cityname = 'Charlotte'
Nightwish
The Underground - Fillmore Charlotte Charlotte Charlotte, NC
Mar 10, 8:00 pm 2018
Saturday
Mar 10
8:00 pm
Nightwish
The Underground - Fillmore Charlotte, Charlotte, NC
SELECT * from toolvenuepagelink WHERE venueid = 2232
SELECT * from toolcitypagelink WHERE cityname = 'Norfolk'
Nightwish
The Norva Norfolk Norfolk, VA
Mar 12, 8:00 pm 2018
Monday
Mar 12
8:00 pm
Nightwish
The Norva, Norfolk, VA
SELECT * from toolvenuepagelink WHERE venueid = 2019
SELECT * from toolcitypagelink WHERE cityname = 'Baltimore'
Nightwish
Modell Performing Arts Center At The Lyric Baltimore Baltimore, MD
Mar 13, 8:15 pm 2018
Tuesday
Mar 13
8:15 pm
Nightwish
Modell Performing Arts Center At The Lyric, Baltimore, MD
SELECT * from toolvenuepagelink WHERE venueid = 3649
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Nightwish
Playstation Theater New York New York, NY
Mar 14, 8:00 pm 2018
Wednesday
Mar 14
8:00 pm
Nightwish
Playstation Theater, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 443
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
Nightwish
Electric Factory Philadelphia Philadelphia, PA
Mar 16, 8:30 pm 2018
Friday
Mar 16
8:30 pm
Nightwish
Electric Factory, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 28291
SELECT * from toolcitypagelink WHERE cityname = 'Worcester'
Nightwish
The Palladium - MA Worcester Worcester, MA
Mar 17, 7:00 pm 2018
Saturday
Mar 17
7:00 pm
Nightwish
The Palladium - MA, Worcester, MA
SELECT * from toolvenuepagelink WHERE venueid = 2650
SELECT * from toolcitypagelink WHERE cityname = 'Albany'
Nightwish
The Egg Albany Albany, NY
Mar 18, 8:15 pm 2018
Sunday
Mar 18
8:15 pm
Nightwish
The Egg, Albany, NY
SELECT * from toolvenuepagelink WHERE venueid = 2823
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Nightwish
Metropolis Montreal Montreal, QC
Mar 20, 8:00 pm 2018
Tuesday
Mar 20
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 940
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Nightwish
Massey Hall Toronto Toronto, ON
Mar 21, 8:00 pm 2018
Wednesday
Mar 21
8:00 pm
Nightwish
Massey Hall, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 7221
SELECT * from toolcitypagelink WHERE cityname = 'Niagara Falls'
Nightwish
The Rapids Theatre Niagara Falls Niagara Falls, NY
Mar 23, 8:30 pm 2018
Friday
Mar 23
8:30 pm
Nightwish
The Rapids Theatre, Niagara Falls, NY
SELECT * from toolvenuepagelink WHERE venueid = 15
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
Nightwish
Agora Theatre Cleveland Cleveland, OH
Mar 24, 6:00 pm 2018
Saturday
Mar 24
6:00 pm
Nightwish
Agora Theatre, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 7725
SELECT * from toolcitypagelink WHERE cityname = 'Pittsburgh'
Nightwish
Stage AE Pittsburgh Pittsburgh, PA
Mar 25, 6:00 pm 2018
Sunday
Mar 25
6:00 pm
Nightwish
Stage AE, Pittsburgh, PA
SELECT * from toolvenuepagelink WHERE venueid = 3523
SELECT * from toolcitypagelink WHERE cityname = 'Covington'
Nightwish
Madison Theater Covington Covington, KY
Mar 26, 8:00 pm 2018
Monday
Mar 26
8:00 pm
Nightwish
Madison Theater, Covington, KY
SELECT * from toolvenuepagelink WHERE venueid = 1491
SELECT * from toolcitypagelink WHERE cityname = 'Kalamazoo Township'
Nightwish
State Theatre-MI Kalamazoo Kalamazoo Township Kalamazoo Township, MI
Mar 28, 8:00 pm 2018
Wednesday
Mar 28
8:00 pm
Nightwish
State Theatre-MI Kalamazoo, Kalamazoo Township, MI
SELECT * from toolvenuepagelink WHERE venueid = 3734
SELECT * from toolcitypagelink WHERE cityname = 'St Paul'
Nightwish
Myth St Paul St Paul, MN
Mar 30, 8:30 pm 2018
Friday
Mar 30
8:30 pm
Nightwish
Myth, St Paul, MN
SELECT * from toolvenuepagelink WHERE venueid = 56
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Nightwish
Aragon Ballroom Chicago Chicago, IL
Mar 31, 8:00 pm 2018
Saturday
Mar 31
8:00 pm
Nightwish
Aragon Ballroom, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 1443
SELECT * from toolcitypagelink WHERE cityname = 'Omaha'

April

Nightwish
Sokol Auditorium Omaha Omaha, NE
Apr 2, 8:30 pm 2018
Monday
Apr 2
8:30 pm
Nightwish
Sokol Auditorium, Omaha, NE
SELECT * from toolvenuepagelink WHERE venueid = 1193
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Nightwish
Paramount Theatre - CO Denver Denver, CO
Apr 3, 9:00 pm 2018
Tuesday
Apr 3
9:00 pm
Nightwish
Paramount Theatre - CO, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 433
SELECT * from toolcitypagelink WHERE cityname = 'Edmonton'
Nightwish
Northern Alberta Jubilee Auditorium Edmonton Edmonton, AB
Apr 5, 8:00 pm 2018
Thursday
Apr 5
8:00 pm
Nightwish
Northern Alberta Jubilee Auditorium, Edmonton, AB
SELECT * from toolvenuepagelink WHERE venueid = 3015
SELECT * from toolcitypagelink WHERE cityname = 'Spokane'
Nightwish
Knitting Factory Concert House Spokane Spokane, WA
Apr 6, 8:00 pm 2018
Friday
Apr 6
8:00 pm
Nightwish
Knitting Factory Concert House, Spokane, WA
SELECT * from toolvenuepagelink WHERE venueid = 1272
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Nightwish
Queen Elizabeth Theatre - Vancouver Vancouver Vancouver, BC
Apr 7, 7:00 pm 2018
Saturday
Apr 7
7:00 pm
Nightwish
Queen Elizabeth Theatre - Vancouver, Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 2135
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Nightwish
Roseland Theater Portland Portland, OR
Apr 8, 8:00 pm 2018
Sunday
Apr 8
8:00 pm
Nightwish
Roseland Theater, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 30602
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'
Nightwish
Brooklyn Bowl Las Vegas at The LINQ Las Vegas Las Vegas, NV
Apr 10, 8:00 pm 2018
Tuesday
Apr 10
8:00 pm
Nightwish
Brooklyn Bowl Las Vegas at The LINQ, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 1677
SELECT * from toolcitypagelink WHERE cityname = 'Ventura'
Nightwish
Majestic Ventura Theater Ventura Ventura, CA
Apr 12, 8:00 pm 2018
Thursday
Apr 12
8:00 pm
Nightwish
Majestic Ventura Theater, Ventura, CA
SELECT * from toolvenuepagelink WHERE venueid = 31465
SELECT * from toolcitypagelink WHERE cityname = 'San Jose'
Nightwish
City National Civic San Jose San Jose, CA
Apr 13, 7:00 pm 2018
Friday
Apr 13
7:00 pm
Nightwish
City National Civic, San Jose, CA
SELECT * from toolvenuepagelink WHERE venueid = 2120
SELECT * from toolcitypagelink WHERE cityname = 'Anaheim'
Nightwish
City National Grove of Anaheim Anaheim Anaheim, CA
Apr 14, 8:00 pm 2018
Saturday
Apr 14
8:00 pm
Nightwish
City National Grove of Anaheim, Anaheim, CA
SELECT * from toolvenuepagelink WHERE venueid = 2624
SELECT * from toolcitypagelink WHERE cityname = 'Tempe'
Nightwish
Marquee Theatre Tempe Tempe, AZ
Apr 15, 8:00 pm 2018
Sunday
Apr 15
8:00 pm
Nightwish
Marquee Theatre, Tempe, AZ
SELECT * from toolvenuepagelink WHERE venueid = 31816
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Nightwish
Bomb Factory Dallas Dallas, TX
Apr 17, 8:00 pm 2018
Tuesday
Apr 17
8:00 pm
Nightwish
Bomb Factory, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 6178
SELECT * from toolcitypagelink WHERE cityname = 'Memphis'
Nightwish
Minglewood Hall Memphis Memphis, TN
Apr 18, 8:30 pm 2018
Wednesday
Apr 18
8:30 pm
Nightwish
Minglewood Hall, Memphis, TN
SELECT * from toolvenuepagelink WHERE venueid = 2976
SELECT * from toolcitypagelink WHERE cityname = 'Mobile'
Nightwish
Saenger Theatre - AL Mobile Mobile, AL
Apr 19, 8:15 pm 2018
Thursday
Apr 19
8:15 pm
Nightwish
Saenger Theatre - AL, Mobile, AL
SELECT * from toolvenuepagelink WHERE venueid = 744
SELECT * from toolcitypagelink WHERE cityname = 'St Petersburg'
Nightwish
Jannus Live St Petersburg St Petersburg, FL
Apr 21, 8:30 pm 2018
Saturday
Apr 21
8:30 pm
Nightwish
Jannus Live, St Petersburg, FL
SELECT * from toolvenuepagelink WHERE venueid = 615
SELECT * from toolcitypagelink WHERE cityname = 'Miami'
Nightwish
Gusman Center for the Performing Arts Miami Miami, FL
Apr 22, 11:59 pm 2018
Sunday
Apr 22
11:59 pm
Nightwish
Gusman Center for the Performing Arts, Miami, FL
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