LISTE POUR : Within Temptation

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

February

Within Temptation with In Flames
Rams Head Live Baltimore Baltimore, MD
Feb 28, 7:00 pm 2019
Thursday
Feb 28
7:00 pm
Within Temptation with In Flames
Rams Head Live, Baltimore, MD
SELECT * from toolvenuepagelink WHERE venueid = 32474
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'

March

Within Temptation
The Fillmore Philadelphia Philadelphia Philadelphia, PA
Mar 1, 7:00 pm 2019
Friday
Mar 1
7:00 pm
Within Temptation
The Fillmore Philadelphia, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 3649
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Within Temptation
Playstation Theater New York New York, NY
Mar 2, 7:00 pm 2019
Saturday
Mar 2
7:00 pm
Within Temptation
Playstation Theater, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 6064
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Within Temptation
House of Blues - Boston Boston Boston, MA
Mar 3, 7:00 pm 2019
Sunday
Mar 3
7:00 pm
Within Temptation
House of Blues - Boston, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 26239
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Within Temptation
Olympia Theatre - Montreal Montreal Montreal, QC
Mar 5, 7:00 pm 2019
Tuesday
Mar 5
7:00 pm
Within Temptation
Olympia Theatre - Montreal, Montreal, QC
SELECT * from toolvenuepagelink WHERE venueid = 18146
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Within Temptation
Rebel Toronto Toronto, ON
Mar 6, 7:00 pm 2019
Wednesday
Mar 6
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 680
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Within Temptation
House of Blues - Chicago Chicago Chicago, IL
Mar 8, 12:00 am 2019
Friday
Mar 8
12:00 am
Within Temptation
House of Blues - Chicago, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 3266
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
Within Temptation
House of Blues - Cleveland Cleveland Cleveland, OH
Mar 8, 6:00 pm 2019
Friday
Mar 8
6:00 pm
Within Temptation
House of Blues - Cleveland, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 30137
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
Within Temptation
Skyway Theater Minneapolis Minneapolis, MN
Mar 9, 6:00 pm 2019
Saturday
Mar 9
6:00 pm
Within Temptation
Skyway Theater, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 7810
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Within Temptation with In Flames
Summit Music Hall Denver Denver, CO
Mar 11, 6:00 pm 2019
Monday
Mar 11
6:00 pm
Within Temptation with In Flames
Summit Music Hall, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 9539
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
Within Temptation
The Complex Salt Lake City Salt Lake City, UT
Mar 12, 6:00 pm 2019
Tuesday
Mar 12
6:00 pm
Within Temptation
The Complex, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 9539
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
Within Temptation
The Complex Salt Lake City Salt Lake City, UT
Mar 12, 6:00 pm 2019
Tuesday
Mar 12
6:00 pm
Within Temptation
The Complex, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 2135
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Within Temptation
Roseland Theater Portland Portland, OR
Mar 14, 7:00 pm 2019
Thursday
Mar 14
7:00 pm
Within Temptation
Roseland Theater, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 1692
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Within Temptation
Vogue Theatre Vancouver Vancouver, BC
Mar 15, 7:00 pm 2019
Friday
Mar 15
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 5085
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Within Temptation
Showbox SoDo Seattle Seattle, WA
Mar 16, 7:00 pm 2019
Saturday
Mar 16
7:00 pm
Within Temptation
Showbox SoDo, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 1708
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Within Temptation
The Warfield San Francisco San Francisco, CA
Mar 18, 7:00 pm 2019
Monday
Mar 18
7:00 pm
Within Temptation
The Warfield, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 1752
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Within Temptation
Wiltern Theatre Los Angeles Los Angeles, CA
Mar 19, 7:00 pm 2019
Tuesday
Mar 19
7:00 pm
Within Temptation
Wiltern Theatre, Los Angeles, CA
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football