LISTE POUR : Tokio Hotel

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

February

Tokio Hotel
House of Blues - Orlando Orlando Orlando, FL
Feb 3, 7:30 pm 2018
Saturday
Feb 3
7:30 pm
Tokio Hotel
House of Blues - Orlando, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 1972
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Tokio Hotel
Kennys Alley Atlanta Atlanta, GA
Feb 4, 7:00 pm 2018
Sunday
Feb 4
7:00 pm
Tokio Hotel
Kennys Alley, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 16006
SELECT * from toolcitypagelink WHERE cityname = 'Baltimore'
Tokio Hotel
Baltimore Soundstage Baltimore Baltimore, MD
Feb 6, 8:00 pm 2018
Tuesday
Feb 6
8:00 pm
Tokio Hotel
Baltimore Soundstage, Baltimore, MD
SELECT * from toolvenuepagelink WHERE venueid = 304
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Tokio Hotel
Club Soda Montreal Montreal, QC
Feb 8, 8:00 pm 2018
Thursday
Feb 8
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 2885
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Tokio Hotel
Phoenix Concert Theatre Toronto Toronto, ON
Feb 9, 7:30 pm 2018
Friday
Feb 9
7:30 pm
Tokio Hotel
Phoenix Concert Theatre, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 1603
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
Tokio Hotel
Trocadero Philadelphia Philadelphia, PA
Feb 11, 7:30 pm 2018
Sunday
Feb 11
7:30 pm
Tokio Hotel
Trocadero, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 725
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Tokio Hotel
Irving Plaza New York New York, NY
Feb 13, 7:00 pm 2018
Tuesday
Feb 13
7:00 pm
Tokio Hotel
Irving Plaza, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 15
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
Tokio Hotel
Agora Theatre Cleveland Cleveland, OH
Feb 14, 7:00 pm 2018
Wednesday
Feb 14
7:00 pm
Tokio Hotel
Agora Theatre, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 30272
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Tokio Hotel
Concord Music Hall Chicago Chicago, IL
Feb 16, 7:30 pm 2018
Friday
Feb 16
7:30 pm
Tokio Hotel
Concord Music Hall, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 204
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
Tokio Hotel
Cabooze Minneapolis Minneapolis, MN
Feb 17, 8:15 pm 2018
Saturday
Feb 17
8:15 pm
Tokio Hotel
Cabooze, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 5039
SELECT * from toolcitypagelink WHERE cityname = 'Milwaukee'
Tokio Hotel
Turner Hall Ballroom Milwaukee Milwaukee, WI
Feb 18, 8:00 pm 2018
Sunday
Feb 18
8:00 pm
Tokio Hotel
Turner Hall Ballroom, Milwaukee, WI
SELECT * from toolvenuepagelink WHERE venueid = 2040
SELECT * from toolcitypagelink WHERE cityname = 'Englewood'
Tokio Hotel
Gothic Theatre Englewood Englewood, CO
Feb 20, 8:00 pm 2018
Tuesday
Feb 20
8:00 pm
Tokio Hotel
Gothic Theatre, Englewood, CO
SELECT * from toolvenuepagelink WHERE venueid = 32970
SELECT * from toolcitypagelink WHERE cityname = 'Edmonton'
Tokio Hotel
The Ranch Roadhouse Edmonton Edmonton, AB
Feb 22, 8:00 pm 2018
Thursday
Feb 22
8:00 pm
Tokio Hotel
The Ranch Roadhouse, Edmonton, AB
SELECT * from toolvenuepagelink WHERE venueid = 1692
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Tokio Hotel
Vogue Theatre Vancouver Vancouver, BC
Feb 24, 8:00 pm 2018
Saturday
Feb 24
8:00 pm
Tokio Hotel
Vogue Theatre, Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 4336
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Tokio Hotel
Neumos Seattle Seattle, WA
Feb 25, 7:00 pm 2018
Sunday
Feb 25
7:00 pm
Tokio Hotel
Neumos, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 32934
SELECT * from toolcitypagelink WHERE cityname = 'Berkeley'
Tokio Hotel
The UC Theatre Berkeley Berkeley, CA
Feb 27, 8:00 pm 2018
Tuesday
Feb 27
8:00 pm
Tokio Hotel
The UC Theatre, Berkeley, CA
SELECT * from toolvenuepagelink WHERE venueid = 2120
SELECT * from toolcitypagelink WHERE cityname = 'Anaheim'

March

Tokio Hotel
City National Grove of Anaheim Anaheim Anaheim, CA
Mar 1, 8:00 pm 2018
Thursday
Mar 1
8:00 pm
Tokio Hotel
City National Grove of Anaheim, Anaheim, CA
SELECT * from toolvenuepagelink WHERE venueid = 442
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Tokio Hotel
El Rey Theatre Los Angeles Los Angeles, CA
Mar 2, 9:00 pm 2018
Friday
Mar 2
9:00 pm
Tokio Hotel
El Rey Theatre, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 2624
SELECT * from toolcitypagelink WHERE cityname = 'Tempe'
Tokio Hotel
Marquee Theatre Tempe Tempe, AZ
Mar 3, 8:00 pm 2018
Saturday
Mar 3
8:00 pm
Tokio Hotel
Marquee Theatre, Tempe, AZ
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football