LISTE POUR : The Darkness

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

March

The Darkness
Henry Fonda Theatre Los Angeles Los Angeles, CA
Mar 29, 9:00 pm 2018
Thursday
Mar 29
9:00 pm
The Darkness
Henry Fonda Theatre, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 30602
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'
The Darkness
Brooklyn Bowl Las Vegas at The LINQ Las Vegas Las Vegas, NV
Mar 30, 7:00 pm 2018
Friday
Mar 30
7:00 pm
The Darkness
Brooklyn Bowl Las Vegas at The LINQ, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 3226
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
The Darkness
Regency Ballroom - Social Hall San Francisco San Francisco, CA
Mar 31, 8:00 pm 2018
Saturday
Mar 31
8:00 pm
The Darkness
Regency Ballroom - Social Hall, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 2395
SELECT * from toolcitypagelink WHERE cityname = 'Portland'

April

The Darkness
McMenamins Crystal Ballroom Portland Portland, OR
Apr 2, 8:00 pm 2018
Monday
Apr 2
8:00 pm
The Darkness
McMenamins Crystal Ballroom, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 1419
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
The Darkness
The Showbox Seattle Seattle, WA
Apr 3, 8:00 pm 2018
Tuesday
Apr 3
8:00 pm
The Darkness
The Showbox, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 1692
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
The Darkness
Vogue Theatre Vancouver Vancouver, BC
Apr 4, 7:00 pm 2018
Wednesday
Apr 4
7:00 pm
The Darkness
Vogue Theatre, Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 2040
SELECT * from toolcitypagelink WHERE cityname = 'Englewood'
The Darkness
Gothic Theatre Englewood Englewood, CO
Apr 7, 8:00 pm 2018
Saturday
Apr 7
8:00 pm
The Darkness
Gothic Theatre, Englewood, CO
SELECT * from toolvenuepagelink WHERE venueid = 33547
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
The Darkness
The Truman Kansas City Kansas City, MO
Apr 8, 8:00 pm 2018
Sunday
Apr 8
8:00 pm
The Darkness
The Truman, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 1199
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
The Darkness
Park West Chicago Chicago, IL
Apr 11, 8:00 pm 2018
Wednesday
Apr 11
8:00 pm
The Darkness
Park West, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 905
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
The Darkness
Majestic Theatre Detroit Detroit Detroit, MI
Apr 13, 7:00 pm 2018
Friday
Apr 13
7:00 pm
The Darkness
Majestic Theatre Detroit, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 15
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
The Darkness
Agora Theatre Cleveland Cleveland, OH
Apr 14, 7:00 pm 2018
Saturday
Apr 14
7:00 pm
The Darkness
Agora Theatre, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 2885
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
The Darkness
Phoenix Concert Theatre Toronto Toronto, ON
Apr 15, 7:00 pm 2018
Sunday
Apr 15
7:00 pm
The Darkness
Phoenix Concert Theatre, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 18123
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
The Darkness
Corona Theatre Montreal Montreal, QC
Apr 17, 8:00 pm 2018
Tuesday
Apr 17
8:00 pm
The Darkness
Corona Theatre, Montreal, QC
SELECT * from toolvenuepagelink WHERE venueid = 1603
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
The Darkness
Trocadero Philadelphia Philadelphia, PA
Apr 18, 8:00 pm 2018
Wednesday
Apr 18
8:00 pm
The Darkness
Trocadero, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 33405
SELECT * from toolcitypagelink WHERE cityname = 'Brooklyn'
The Darkness
Brooklyn Steel Brooklyn Brooklyn, NY
Apr 20, 8:00 pm 2018
Friday
Apr 20
8:00 pm
The Darkness
Brooklyn Steel, Brooklyn, NY
SELECT * from toolvenuepagelink WHERE venueid = 2925
SELECT * from toolcitypagelink WHERE cityname = 'Sayreville'
The Darkness
Starland Ballroom Sayreville Sayreville, NJ
Apr 21, 7:00 pm 2018
Saturday
Apr 21
7:00 pm
The Darkness
Starland Ballroom, Sayreville, NJ
SELECT * from toolvenuepagelink WHERE venueid = 3427
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
The Darkness
Royale Boston Boston Boston, MA
Apr 22, 8:00 pm 2018
Sunday
Apr 22
8:00 pm
The Darkness
Royale Boston, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 3508
SELECT * from toolcitypagelink WHERE cityname = 'Baltimore'
The Darkness
Rams Head Live Baltimore Baltimore, MD
Apr 24, 8:00 pm 2018
Tuesday
Apr 24
8:00 pm
The Darkness
Rams Head Live, Baltimore, MD
SELECT * from toolvenuepagelink WHERE venueid = 2232
SELECT * from toolcitypagelink WHERE cityname = 'Norfolk'
The Darkness
The Norva Norfolk Norfolk, VA
Apr 25, 8:00 pm 2018
Wednesday
Apr 25
8:00 pm
The Darkness
The Norva, Norfolk, VA
SELECT * from toolvenuepagelink WHERE venueid = 6693
SELECT * from toolcitypagelink WHERE cityname = 'Charlotte'
The Darkness
The Underground - Fillmore Charlotte Charlotte Charlotte, NC
Apr 27, 8:00 pm 2018
Friday
Apr 27
8:00 pm
The Darkness
The Underground - Fillmore Charlotte, Charlotte, NC
SELECT * from toolvenuepagelink WHERE venueid = 28994
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
The Darkness
Terminal West Atlanta Atlanta, GA
Apr 28, 8:00 pm 2018
Saturday
Apr 28
8:00 pm
The Darkness
Terminal West, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 30261
SELECT * from toolcitypagelink WHERE cityname = 'New Orleans'
The Darkness
The Civic Theatre New Orleans New Orleans, LA
Apr 30, 8:00 pm 2018
Monday
Apr 30
8:00 pm
The Darkness
The Civic Theatre, New Orleans, LA
SELECT * from toolvenuepagelink WHERE venueid = 2171
SELECT * from toolcitypagelink WHERE cityname = 'Austin'

May

The Darkness
Emo's East Austin Austin, TX
May 1, 7:00 pm 2018
Tuesday
May 1
7:00 pm
The Darkness
Emo's East, Austin, TX
SELECT * from toolvenuepagelink WHERE venueid = 3504
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
The Darkness
Gilleys Dallas Dallas Dallas, TX
May 2, 8:00 pm 2018
Wednesday
May 2
8:00 pm
The Darkness
Gilleys Dallas, Dallas, TX
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football