LISTE POUR : Kamelot

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

April

Kamelot
Mercury Ballroom Louisville Louisville, KY
Apr 16, 8:00 pm 2018
Monday
Apr 16
8:00 pm
Kamelot
Mercury Ballroom, Louisville, KY
SELECT * from toolvenuepagelink WHERE venueid = 6693
SELECT * from toolcitypagelink WHERE cityname = 'Charlotte'
Kamelot
The Underground - Fillmore Charlotte Charlotte Charlotte, NC
Apr 17, 8:00 pm 2018
Tuesday
Apr 17
8:00 pm
Kamelot
The Underground - Fillmore Charlotte, Charlotte, NC
SELECT * from toolvenuepagelink WHERE venueid = 7900
SELECT * from toolcitypagelink WHERE cityname = 'Silver Spring'
Kamelot
The Fillmore Silver Spring Silver Spring Silver Spring, MD
Apr 18, 8:00 pm 2018
Wednesday
Apr 18
8:00 pm
Kamelot
The Fillmore Silver Spring, Silver Spring, MD
SELECT * from toolvenuepagelink WHERE venueid = 725
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Kamelot
Irving Plaza New York New York, NY
Apr 20, 7:30 pm 2018
Friday
Apr 20
7:30 pm
Kamelot
Irving Plaza, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 2823
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Kamelot with Battle Beast and Delain
Metropolis Montreal Montreal, QC
Apr 22, 7:30 pm 2018
Sunday
Apr 22
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 1860
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Kamelot
The Opera House (Toronto) Toronto Toronto, ON
Apr 23, 7:00 pm 2018
Monday
Apr 23
7:00 pm
Kamelot
The Opera House (Toronto), Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 1855
SELECT * from toolcitypagelink WHERE cityname = 'Clifton Park'
Kamelot
Upstate Concert Hall Clifton Park Clifton Park, NY
Apr 25, 7:00 pm 2018
Wednesday
Apr 25
7:00 pm
Kamelot
Upstate Concert Hall, Clifton Park, NY
SELECT * from toolvenuepagelink WHERE venueid = 30272
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Kamelot with Delain
Concord Music Hall Chicago Chicago, IL
Apr 27, 5:30 pm 2018
Friday
Apr 27
5:30 pm
Kamelot with Delain
Concord Music Hall, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 204
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
Kamelot with Delain
Cabooze Minneapolis Minneapolis, MN
Apr 28, 7:00 pm 2018
Saturday
Apr 28
7:00 pm
Kamelot with Delain
Cabooze, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 28856
SELECT * from toolcitypagelink WHERE cityname = 'Des Moines'
Kamelot
Wooly's Des Moines Des Moines, IA
Apr 29, 7:00 pm 2018
Sunday
Apr 29
7:00 pm
Kamelot
Wooly's, Des Moines, IA
SELECT * from toolvenuepagelink WHERE venueid = 1131
SELECT * from toolcitypagelink WHERE cityname = 'Denver'

May

Kamelot
Ogden Theatre Denver Denver, CO
May 1, 8:00 pm 2018
Tuesday
May 1
8:00 pm
Kamelot
Ogden Theatre, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 9539
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
Kamelot
The Complex Salt Lake City Salt Lake City, UT
May 2, 7:00 pm 2018
Wednesday
May 2
7:00 pm
Kamelot
The Complex, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 31465
SELECT * from toolcitypagelink WHERE cityname = 'San Jose'
Kamelot
City National Civic San Jose San Jose, CA
May 4, 8:00 pm 2018
Friday
May 4
8:00 pm
Kamelot
City National Civic, San Jose, CA
SELECT * from toolvenuepagelink WHERE venueid = 2120
SELECT * from toolcitypagelink WHERE cityname = 'Anaheim'
Kamelot
City National Grove of Anaheim Anaheim Anaheim, CA
May 5, 8:00 pm 2018
Saturday
May 5
8:00 pm
Kamelot
City National Grove of Anaheim, Anaheim, CA
SELECT * from toolvenuepagelink WHERE venueid = 2624
SELECT * from toolcitypagelink WHERE cityname = 'Tempe'
Kamelot
Marquee Theatre Tempe Tempe, AZ
May 6, 6:00 pm 2018
Sunday
May 6
6:00 pm
Kamelot
Marquee Theatre, Tempe, AZ
SELECT * from toolvenuepagelink WHERE venueid = 4568
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Kamelot
House of Blues - Dallas Dallas Dallas, TX
May 8, 7:00 pm 2018
Tuesday
May 8
7:00 pm
Kamelot
House of Blues - Dallas, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 5679
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
Kamelot
House of Blues - Houston Houston Houston, TX
May 9, 7:00 pm 2018
Wednesday
May 9
7:00 pm
Kamelot
House of Blues - Houston, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 2298
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Kamelot
Center Stage Theatre - GA Atlanta Atlanta, GA
May 11, 7:00 pm 2018
Friday
May 11
7:00 pm
Kamelot
Center Stage Theatre - GA, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 681
SELECT * from toolcitypagelink WHERE cityname = 'Orlando'
Kamelot
House of Blues - Orlando Orlando Orlando, FL
May 12, 7:30 pm 2018
Saturday
May 12
7:30 pm
Kamelot
House of Blues - Orlando, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 5552
SELECT * from toolcitypagelink WHERE cityname = 'Fort Lauderdale'
Kamelot
Revolution Live Fort Lauderdale Fort Lauderdale, FL
May 13, 7:30 pm 2018
Sunday
May 13
7:30 pm
Kamelot
Revolution Live, Fort Lauderdale, 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