LISTE POUR : JMSN

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

January

JMSN with Daley
El Club Detroit Detroit, MI
Jan 24, 9:00 pm 2019
Thursday
Jan 24
9:00 pm
JMSN with Daley
El Club, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 32703
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
JMSN
The Foundry - TX Dallas Dallas, TX
Jan 31, 8:00 pm 2019
Thursday
Jan 31
8:00 pm
JMSN
The Foundry - TX, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 28122
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'

February

JMSN
Crowbar Tampa Tampa, FL
Feb 12, 8:00 pm 2019
Tuesday
Feb 12
8:00 pm
JMSN
Crowbar, Tampa, FL
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football