LISTE POUR : Stars on Ice

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

April

Stars On Ice
Giant Center Hershey Hershey, PA
Apr 26, 7:30 pm 2019
Friday
Apr 26
7:30 pm
Stars On Ice
Giant Center, Hershey, PA
SELECT * from toolvenuepagelink WHERE venueid = 345
SELECT * from toolcitypagelink WHERE cityname = 'Kanata'
Stars On Ice
Canadian Tire Centre Kanata Kanata, ON
Apr 28, 4:00 pm 2019
Sunday
Apr 28
4:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 33560
SELECT * from toolcitypagelink WHERE cityname = 'Laval'

May

Stars On Ice
Place Bell Laval Laval, QC
May 1, 7:00 pm 2019
Wednesday
May 1
7:00 pm
Stars On Ice
Place Bell, Laval, QC
SELECT * from toolvenuepagelink WHERE venueid = 17
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Stars On Ice
Scotiabank Arena Toronto Toronto, ON
May 3, 7:30 pm 2019
Friday
May 3
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 342
SELECT * from toolcitypagelink WHERE cityname = 'Hamilton'
Stars On Ice
First Ontario Centre Hamilton Hamilton, ON
May 4, 7:30 pm 2019
Saturday
May 4
7:30 pm
Stars On Ice
First Ontario Centre, Hamilton, ON
SELECT * from toolvenuepagelink WHERE venueid = 2521
SELECT * from toolcitypagelink WHERE cityname = 'London'
Stars On Ice
Budweiser Gardens London London, ON
May 5, 4:00 pm 2019
Sunday
May 5
4:00 pm
Stars On Ice
Budweiser Gardens, London, ON
SELECT * from toolvenuepagelink WHERE venueid = 3316
SELECT * from toolcitypagelink WHERE cityname = 'Winnipeg'
Stars On Ice
Bell MTS Place Winnipeg Winnipeg, MB
May 8, 7:00 pm 2019
Wednesday
May 8
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 3308
SELECT * from toolcitypagelink WHERE cityname = 'Saskatoon'
Stars On Ice
SaskTel Centre Saskatoon Saskatoon, SK
May 10, 7:30 pm 2019
Friday
May 10
7:30 pm
Stars On Ice
SaskTel Centre, Saskatoon, SK
SELECT * from toolvenuepagelink WHERE venueid = 1367
SELECT * from toolcitypagelink WHERE cityname = 'Calgary'
Stars On Ice
Scotiabank Saddledome Calgary Calgary, AB
May 11, 7:30 pm 2019
Saturday
May 11
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 66
SELECT * from toolcitypagelink WHERE cityname = 'Anaheim'
Stars On Ice
Honda Center Anaheim Anaheim, CA
May 11, 7:30 pm 2019
Saturday
May 11
7:30 pm
Stars On Ice
Honda Center, Anaheim, CA
SELECT * from toolvenuepagelink WHERE venueid = 33142
SELECT * from toolcitypagelink WHERE cityname = 'Edmonton'
Stars On Ice
Rogers Place Edmonton Edmonton, AB
May 12, 4:00 pm 2019
Sunday
May 12
4:00 pm
Stars On Ice
Rogers Place, Edmonton, AB
SELECT * from toolvenuepagelink WHERE venueid = 557
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Stars On Ice
Rogers Arena Vancouver Vancouver, BC
May 16, 7:00 pm 2019
Thursday
May 16
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