LISTE POUR : Delain

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

September

Delain with Amorphis
Theatre of Living Arts Philadelphia Philadelphia, PA
Sep 19, 8:00 pm 2019
Thursday
Sep 19
8:00 pm
Delain with Amorphis
Theatre of Living Arts, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 725
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Delain
Irving Plaza New York New York, NY
Sep 20, 7:30 pm 2019
Friday
Sep 20
7:30 pm
Delain
Irving Plaza, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 28291
SELECT * from toolcitypagelink WHERE cityname = 'Worcester'
Delain
The Palladium - MA Worcester Worcester, MA
Sep 21, 6:00 pm 2019
Saturday
Sep 21
6:00 pm
Delain
The Palladium - MA, Worcester, MA
SELECT * from toolvenuepagelink WHERE venueid = 1855
SELECT * from toolcitypagelink WHERE cityname = 'Clifton Park'
Delain and Amorphis
Upstate Concert Hall Clifton Park Clifton Park, NY
Sep 22, 7:00 pm 2019
Sunday
Sep 22
7:00 pm
Delain and Amorphis
Upstate Concert Hall, Clifton Park, NY
SELECT * from toolvenuepagelink WHERE venueid = 304
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Delain and Amorphis
Club Soda Montreal Montreal, QC
Sep 23, 7:00 pm 2019
Monday
Sep 23
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 1860
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Delain with Amorphis
The Opera House (Toronto) Toronto Toronto, ON
Sep 26, 6:30 pm 2019
Thursday
Sep 26
6:30 pm
Delain with Amorphis
The Opera House (Toronto), Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 15
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
Delain with Amorphis
Agora Theatre Cleveland Cleveland, OH
Sep 27, 7:00 pm 2019
Friday
Sep 27
7:00 pm
Delain with Amorphis
Agora Theatre, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 33573
SELECT * from toolcitypagelink WHERE cityname = 'Joliet'
Delain with Amorphis
The Forge Joliet Joliet, IL
Sep 28, 7:30 pm 2019
Saturday
Sep 28
7:30 pm
Delain with Amorphis
The Forge, Joliet, IL
SELECT * from toolvenuepagelink WHERE venueid = 5039
SELECT * from toolcitypagelink WHERE cityname = 'Milwaukee'
Delain and Amorphis
Turner Hall Ballroom Milwaukee Milwaukee, WI
Sep 29, 7:00 pm 2019
Sunday
Sep 29
7:00 pm
Delain and Amorphis
Turner Hall Ballroom, Milwaukee, WI
SELECT * from toolvenuepagelink WHERE venueid = 204
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
Delain and Amorphis
Cabooze Minneapolis Minneapolis, MN
Sep 30, 7:00 pm 2019
Monday
Sep 30
7:00 pm
Delain and Amorphis
Cabooze, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 32753
SELECT * from toolcitypagelink WHERE cityname = 'Calgary'

October

Delain with Amorphis
Dickens Calgary Calgary, AB
Oct 2, 7:00 pm 2019
Wednesday
Oct 2
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 25930
SELECT * from toolcitypagelink WHERE cityname = 'Edmonton'
Delain and Amorphis
Starlite Room Edmonton Edmonton, AB
Oct 3, 7:00 pm 2019
Thursday
Oct 3
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 4459
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Delain with Amorphis
El Corazon Seattle Seattle, WA
Oct 6, 7:30 pm 2019
Sunday
Oct 6
7:30 pm
Delain with Amorphis
El Corazon, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 9556
SELECT * from toolcitypagelink WHERE cityname = 'Sacramento'
Delain
Ace of Spades Sacramento Sacramento, CA
Oct 8, 6:00 pm 2019
Tuesday
Oct 8
6:00 pm
Delain
Ace of Spades, Sacramento, CA
SELECT * from toolvenuepagelink WHERE venueid = 1803
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Delain
Slim's San Francisco San Francisco, CA
Oct 9, 8:00 pm 2019
Wednesday
Oct 9
8:00 pm
Delain
Slim's, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 1352
SELECT * from toolcitypagelink WHERE cityname = 'West Hollywood'
Delain
The Roxy Theatre West Hollywood West Hollywood, CA
Oct 10, 9:00 pm 2019
Thursday
Oct 10
9:00 pm
Delain
The Roxy Theatre, West Hollywood, CA
SELECT * from toolvenuepagelink WHERE venueid = 2120
SELECT * from toolcitypagelink WHERE cityname = 'Anaheim'
Delain
City National Grove of Anaheim Anaheim Anaheim, CA
Oct 11, 8:00 pm 2019
Friday
Oct 11
8:00 pm
Delain
City National Grove of Anaheim, Anaheim, CA
SELECT * from toolvenuepagelink WHERE venueid = 2624
SELECT * from toolcitypagelink WHERE cityname = 'Tempe'
Delain
Marquee Theatre Tempe Tempe, AZ
Oct 12, 7:30 pm 2019
Saturday
Oct 12
7:30 pm
Delain
Marquee Theatre, Tempe, AZ
SELECT * from toolvenuepagelink WHERE venueid = 2040
SELECT * from toolcitypagelink WHERE cityname = 'Englewood'
Delain
Gothic Theatre Englewood Englewood, CO
Oct 14, 8:00 pm 2019
Monday
Oct 14
8:00 pm
Delain
Gothic Theatre, Englewood, CO
SELECT * from toolvenuepagelink WHERE venueid = 33547
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Delain with Amorphis
The Truman Kansas City Kansas City, MO
Oct 15, 8:00 pm 2019
Tuesday
Oct 15
8:00 pm
Delain with Amorphis
The Truman, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 1600
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Delain with Amorphis
Trees Dallas Dallas, TX
Oct 16, 8:00 pm 2019
Wednesday
Oct 16
8:00 pm
Delain with Amorphis
Trees, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 6313
SELECT * from toolcitypagelink WHERE cityname = 'Nassau Bay'
Delain with Amorphis
Scout Bar - Houston Nassau Bay Nassau Bay, TX
Oct 17, 7:30 pm 2019
Thursday
Oct 17
7:30 pm
Delain with Amorphis
Scout Bar - Houston, Nassau Bay, TX
SELECT * from toolvenuepagelink WHERE venueid = 8167
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Delain and Amorphis
The Orpheum - Tampa Tampa Tampa, FL
Oct 19, 8:00 pm 2019
Saturday
Oct 19
8:00 pm
Delain and Amorphis
The Orpheum - Tampa, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 1972
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Delain and Amorphis
Kennys Alley Atlanta Atlanta, GA
Oct 20, 7:00 pm 2019
Sunday
Oct 20
7:00 pm
Delain and Amorphis
Kennys Alley, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 16006
SELECT * from toolcitypagelink WHERE cityname = 'Baltimore'
Delain with Amorphis
Baltimore Soundstage Baltimore Baltimore, MD
Oct 21, 8:00 pm 2019
Monday
Oct 21
8:00 pm
Delain with Amorphis
Baltimore Soundstage, Baltimore, MD
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football