LISTE POUR : Montreal Canadiens

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

February

Vancouver Canucks at Montreal Canadiens
Bell Centre Montreal Montreal, QC
Feb 25, 7:00 pm 2020
Tuesday
Feb 25
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 1036
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
New York Rangers at Montreal Canadiens
Bell Centre Montreal Montreal, QC
Feb 27, 7:00 pm 2020
Thursday
Feb 27
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 1036
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Carolina Hurricanes at Montreal Canadiens
Bell Centre Montreal Montreal, QC
Feb 29, 7:00 pm 2020
Saturday
Feb 29
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 1036
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'

March

Nashville Predators at Montreal Canadiens
Bell Centre Montreal Montreal, QC
Mar 10, 7:00 pm 2020
Tuesday
Mar 10
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 1036
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Buffalo Sabres at Montreal Canadiens
Bell Centre Montreal Montreal, QC
Mar 12, 7:00 pm 2020
Thursday
Mar 12
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 1036
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Buffalo Sabres at Montreal Canadiens
Bell Centre Montreal Montreal, QC
Mar 24, 7:00 pm 2020
Tuesday
Mar 24
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 1036
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Florida Panthers at Montreal Canadiens
Bell Centre Montreal Montreal, QC
Mar 26, 7:00 pm 2020
Thursday
Mar 26
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 1036
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
New York Islanders at Montreal Canadiens
Bell Centre Montreal Montreal, QC
Mar 28, 7:00 pm 2020
Saturday
Mar 28
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