LISTE POUR : Dashboard Confessional

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

September

Dashboard Confessional with All Time Low
Mizner Park Amphitheater Boca Raton Boca Raton, FL
Sep 27, 7:00 pm 2018
Thursday
Sep 27
7:00 pm
Dashboard Confessional with All Time Low
Mizner Park Amphitheater, Boca Raton, FL
SELECT * from toolvenuepagelink WHERE venueid = 744
SELECT * from toolcitypagelink WHERE cityname = 'St Petersburg'
Dashboard Confessional with All Time Low
Jannus Live St Petersburg St Petersburg, FL
Sep 28, 6:00 pm 2018
Friday
Sep 28
6:00 pm
Dashboard Confessional with All Time Low
Jannus Live, St Petersburg, FL
SELECT * from toolvenuepagelink WHERE venueid = 2156
SELECT * from toolcitypagelink WHERE cityname = 'Houston'

October

Dashboard Confessional with All Time Low
Revention Music Center Houston Houston, TX
Oct 1, 6:00 pm 2018
Monday
Oct 1
6:00 pm
Dashboard Confessional with All Time Low
Revention Music Center, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 4402
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Dashboard Confessional with All Time Low
Palladium Ballroom Dallas Dallas, TX
Oct 2, 7:00 pm 2018
Tuesday
Oct 2
7:00 pm
Dashboard Confessional with All Time Low
Palladium Ballroom, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 2050
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Dashboard Confessional with All Time Low
Fillmore Auditorium Denver Denver, CO
Oct 6, 5:30 pm 2018
Saturday
Oct 6
5:30 pm
Dashboard Confessional with All Time Low
Fillmore Auditorium, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 33533
SELECT * from toolcitypagelink WHERE cityname = 'Phoenix'
Dashboard Confessional with All Time Low
The Van Buren Phoenix Phoenix, AZ
Oct 8, 7:00 pm 2018
Monday
Oct 8
7:00 pm
Dashboard Confessional with All Time Low
The Van Buren, Phoenix, AZ
SELECT * from toolvenuepagelink WHERE venueid = 682
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'
Dashboard Confessional with All Time Low
House of Blues - Las Vegas Las Vegas Las Vegas, NV
Oct 9, 6:00 pm 2018
Tuesday
Oct 9
6:00 pm
Dashboard Confessional with All Time Low
House of Blues - Las Vegas, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 2497
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Dashboard Confessional with All Time Low
The Masonic San Francisco San Francisco, CA
Oct 12, 7:00 pm 2018
Friday
Oct 12
7:00 pm
Dashboard Confessional with All Time Low
The Masonic, San Francisco, CA
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football