LISTE POUR : Cosmic Gate

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

February

Cosmic Gate
Rebel Toronto Toronto, ON
Feb 8, 10:00 pm 2019
Friday
Feb 8
10:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 1419
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'

March

Cosmic Gate
The Showbox Seattle Seattle, WA
Mar 1, 8:00 pm 2019
Friday
Mar 1
8:00 pm
Cosmic Gate
The Showbox, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 2040
SELECT * from toolcitypagelink WHERE cityname = 'Englewood'
Cosmic Gate
Gothic Theatre Englewood Englewood, CO
Mar 8, 9:00 pm 2019
Friday
Mar 8
9:00 pm
Cosmic Gate
Gothic Theatre, Englewood, CO
SELECT * from toolvenuepagelink WHERE venueid = 7353
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Cosmic Gate
V Live Chicago Chicago, IL
Mar 15, 8:00 pm 2019
Friday
Mar 15
8:00 pm
Cosmic Gate
V Live, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 670
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'

April

Cosmic Gate
Hollywood Palladium Los Angeles Los Angeles, CA
Apr 5, 9:00 pm 2019
Friday
Apr 5
9:00 pm
Cosmic Gate
Hollywood Palladium, Los Angeles, CA
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football