LISTE POUR : Canadian Grand Prix

Montreal
SELECT tbproductions.*, ttvenues.city,ttvenues.state, CONCAT(ttvenues.city,', ',ttvenues.state) as Region FROM tbproductions,ttvenues , tevoEventPerformers WHERE tbEventsID = 13536 AND tevoEventPerformers.performerId = 13536 AND tevoEventPerformers.isPrimary = 1 AND tbproductions.tbVenuesID = ttvenues.id AND tbproductions.market LIKE '%Montreal%' AND tbproductions.tbVenuesID = ttvenues.id AND tevoEventPerformers.eventId = tbproductions.ID ORDER BY tbproductions.Eventdate
DATES
ÉVÉNEMENT
SELECT * from toolvenuepagelink WHERE venueid = 2124
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'

June

Canadian Grand Prix - Friday
Gilles Villeneuve Circuit Montreal Montreal, QC
Jun 8, 12:00 am 2018
Friday
Jun 8
12:00 am
Canadian Grand Prix - Friday
Gilles Villeneuve Circuit, Montreal, QC
SELECT * from toolvenuepagelink WHERE venueid = 2124
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Canadian Grand Prix - 3 Day Pass
Gilles Villeneuve Circuit Montreal Montreal, QC
Jun 8, 12:00 am 2018
Friday
Jun 8
12:00 am
Canadian Grand Prix - 3 Day Pass
Gilles Villeneuve Circuit, Montreal, QC
SELECT * from toolvenuepagelink WHERE venueid = 2124
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Canadian Grand Prix - Saturday
Gilles Villeneuve Circuit Montreal Montreal, QC
Jun 9, 12:00 am 2018
Saturday
Jun 9
12:00 am
Canadian Grand Prix - Saturday
Gilles Villeneuve Circuit, Montreal, QC
SELECT * from toolvenuepagelink WHERE venueid = 2124
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Canadian Grand Prix - Sunday
Gilles Villeneuve Circuit Montreal Montreal, QC
Jun 10, 12:00 am 2018
Sunday
Jun 10
12:00 am
Canadian Grand Prix - Sunday
Gilles Villeneuve Circuit, Montreal, QC
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football