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 = 3154
SELECT * from toolcitypagelink WHERE cityname = 'Estero'

April

Stars On Ice
Hertz Arena Estero Estero, FL
Apr 18, 7:00 pm 2019
Thursday
Apr 18
7:00 pm
Stars On Ice
Hertz Arena, Estero, FL
SELECT * from toolvenuepagelink WHERE venueid = 1082
SELECT * from toolcitypagelink WHERE cityname = 'Uniondale'
Stars On Ice
The New Coliseum Uniondale Uniondale, NY
Apr 20, 7:30 pm 2019
Saturday
Apr 20
7:30 pm
Stars On Ice
The New Coliseum, Uniondale, NY
SELECT * from toolvenuepagelink WHERE venueid = 1218
SELECT * from toolcitypagelink WHERE cityname = 'Albany'
Stars On Ice
Times Union Center Albany Albany, NY
Apr 25, 7:00 pm 2019
Thursday
Apr 25
7:00 pm
Stars On Ice
Times Union Center, Albany, NY
SELECT * from toolvenuepagelink WHERE venueid = 2379
SELECT * from toolcitypagelink WHERE cityname = 'Hershey'
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 = 3061
SELECT * from toolcitypagelink WHERE cityname = 'Halifax'
Stars On Ice
Halifax Metro Centre Halifax Halifax, NS
Apr 26, 7:30 pm 2019
Friday
Apr 26
7:30 pm
Stars On Ice
Halifax Metro Centre, Halifax, NS
SELECT * from toolvenuepagelink WHERE venueid = 2045
SELECT * from toolcitypagelink WHERE cityname = 'Providence'
Stars On Ice
Dunkin Donuts Center Providence Providence, RI
Apr 27, 7:30 pm 2019
Saturday
Apr 27
7:30 pm
Stars On Ice
Dunkin Donuts Center, Providence, RI
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 = 2172
SELECT * from toolcitypagelink WHERE cityname = 'Worcester'
Stars On Ice
DCU Center Worcester Worcester, MA
Apr 28, 4:00 pm 2019
Sunday
Apr 28
4:00 pm
Stars On Ice
DCU Center, Worcester, MA
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 = 1811
SELECT * from toolcitypagelink WHERE cityname = 'St Paul'
Stars On Ice
Xcel Energy Center St Paul St Paul, MN
May 3, 7:30 pm 2019
Friday
May 3
7:30 pm
Stars On Ice
Xcel Energy Center, St Paul, MN
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 = 3811
SELECT * from toolcitypagelink WHERE cityname = 'Bloomington'
Stars on Ice
Grossinger Motors Arena Bloomington Bloomington, IL
May 4, 7:30 pm 2019
Saturday
May 4
7:30 pm
Stars on Ice
Grossinger Motors Arena, Bloomington, IL
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 = 33
SELECT * from toolcitypagelink WHERE cityname = 'Rosemont'
Stars on Ice
Allstate Arena Rosemont Rosemont, IL
May 5, 4:00 pm 2019
Sunday
May 5
4:00 pm
Stars on Ice
Allstate Arena, Rosemont, IL
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 = 1384
SELECT * from toolcitypagelink WHERE cityname = 'San Jose'
Stars On Ice
SAP Center at San Jose San Jose San Jose, CA
May 12, 4:00 pm 2019
Sunday
May 12
4:00 pm
Stars On Ice
SAP Center at San Jose, San Jose, CA
SELECT * from toolvenuepagelink WHERE venueid = 3317
SELECT * from toolcitypagelink WHERE cityname = 'Victoria'
Stars On Ice
Save On Foods Memorial Centre Victoria Victoria, BC
May 14, 7:00 pm 2019
Tuesday
May 14
7:00 pm
Stars On Ice
Save On Foods Memorial Centre, Victoria, BC
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
SELECT * from toolvenuepagelink WHERE venueid = 1343
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Stars On Ice
Moda Center Portland Portland, OR
May 18, 7:30 pm 2019
Saturday
May 18
7:30 pm
Stars On Ice
Moda Center, Portland, OR
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football