LISTE POUR : Crash Test Dummies

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

January

Crash Test Dummies
Town Ballroom Buffalo Buffalo, NY
Jan 18, 7:00 pm 2019
Friday
Jan 18
7:00 pm
Crash Test Dummies
Town Ballroom, Buffalo, NY
SELECT * from toolvenuepagelink WHERE venueid = 33536
SELECT * from toolcitypagelink WHERE cityname = 'Warrendale'
Crash Test Dummies
Jergel's Rhythm Grille Warrendale Warrendale, PA
Jan 19, 8:00 pm 2019
Saturday
Jan 19
8:00 pm
Crash Test Dummies
Jergel's Rhythm Grille, Warrendale, PA
SELECT * from toolvenuepagelink WHERE venueid = 2426
SELECT * from toolcitypagelink WHERE cityname = 'Annapolis'
Crash Test Dummies
Rams Head On Stage Annapolis Annapolis, MD
Jan 21, 8:00 pm 2019
Monday
Jan 21
8:00 pm
Crash Test Dummies
Rams Head On Stage, Annapolis, MD
SELECT * from toolvenuepagelink WHERE venueid = 31550
SELECT * from toolcitypagelink WHERE cityname = 'Rocky MT'
Crash Test Dummies
Harvester Performance Center Rocky MT Rocky MT, VA
Jan 22, 8:00 pm 2019
Tuesday
Jan 22
8:00 pm
Crash Test Dummies
Harvester Performance Center, Rocky MT, VA
SELECT * from toolvenuepagelink WHERE venueid = 1670
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Crash Test Dummies
Variety Playhouse Atlanta Atlanta, GA
Jan 24, 8:00 pm 2019
Thursday
Jan 24
8:00 pm
Crash Test Dummies
Variety Playhouse, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 5075
SELECT * from toolcitypagelink WHERE cityname = 'Orlando'
Crash Test Dummies
The Plaza 'Live' Theatre Orlando Orlando, FL
Jan 25, 8:00 pm 2019
Friday
Jan 25
8:00 pm
Crash Test Dummies
The Plaza 'Live' Theatre, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 5552
SELECT * from toolcitypagelink WHERE cityname = 'Fort Lauderdale'
Crash Test Dummies
Revolution Live Fort Lauderdale Fort Lauderdale, FL
Jan 26, 7:00 pm 2019
Saturday
Jan 26
7:00 pm
Crash Test Dummies
Revolution Live, Fort Lauderdale, FL
SELECT * from toolvenuepagelink WHERE venueid = 9573
SELECT * from toolcitypagelink WHERE cityname = 'Ponte Vedra Beach'
Crash Test Dummies
Ponte Vedra Concert Hall Ponte Vedra Beach Ponte Vedra Beach, FL
Jan 28, 8:00 pm 2019
Monday
Jan 28
8:00 pm
Crash Test Dummies
Ponte Vedra Concert Hall, Ponte Vedra Beach, FL
SELECT * from toolvenuepagelink WHERE venueid = 5170
SELECT * from toolcitypagelink WHERE cityname = 'Kitchener'

March

Crash Test Dummies
Centre in the Square Kitchener Kitchener, ON
Mar 26, 8:00 pm 2019
Tuesday
Mar 26
8:00 pm
Crash Test Dummies
Centre in the Square, Kitchener, ON
SELECT * from toolvenuepagelink WHERE venueid = 2885
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Crash Test Dummies with Grapes of Wrath
Phoenix Concert Theatre Toronto Toronto, ON
Mar 29, 7:00 pm 2019
Friday
Mar 29
7:00 pm
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football