LISTE POUR : 2Cellos

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

April

2Cellos
Bell Centre Montreal Montreal, QC
Apr 11, 8:00 pm 2018
Wednesday
Apr 11
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 690
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
2Cellos
Sony Centre for the Performing Arts Toronto Toronto, ON
Apr 12, 8:00 pm 2018
Thursday
Apr 12
8:00 pm
2Cellos
Sony Centre for the Performing Arts, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 690
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
2Cellos
Sony Centre for the Performing Arts Toronto Toronto, ON
Apr 13, 8:00 pm 2018
Friday
Apr 13
8:00 pm
2Cellos
Sony Centre for the Performing Arts, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 1084
SELECT * from toolcitypagelink WHERE cityname = 'Ottawa'
2Cellos
National Arts Centre Ottawa Ottawa, ON
Apr 15, 8:00 pm 2018
Sunday
Apr 15
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 33464
SELECT * from toolcitypagelink WHERE cityname = 'Hamilton'
2Cellos
FirstOntario Concert Hall Hamilton Hamilton, ON
Apr 16, 8:00 pm 2018
Monday
Apr 16
8:00 pm
2Cellos
FirstOntario Concert Hall, Hamilton, ON
SELECT * from toolvenuepagelink WHERE venueid = 5400
SELECT * from toolcitypagelink WHERE cityname = 'Thunder Bay'
2Cellos
Thunder Bay Community Auditorium Thunder Bay Thunder Bay, ON
Apr 18, 8:00 pm 2018
Wednesday
Apr 18
8:00 pm
2Cellos
Thunder Bay Community Auditorium, Thunder Bay, ON
SELECT * from toolvenuepagelink WHERE venueid = 3316
SELECT * from toolcitypagelink WHERE cityname = 'Winnipeg'
2Cellos
Bell MTS Place Winnipeg Winnipeg, MB
Apr 19, 8:00 pm 2018
Thursday
Apr 19
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 4431
SELECT * from toolcitypagelink WHERE cityname = 'Regina'
2Cellos
Conexus Arts Centre Regina Regina, SK
Apr 21, 8:00 pm 2018
Saturday
Apr 21
8:00 pm
2Cellos
Conexus Arts Centre, Regina, SK
SELECT * from toolvenuepagelink WHERE venueid = 2661
SELECT * from toolcitypagelink WHERE cityname = 'Calgary'
2Cellos
Southern Alberta Jubilee Auditorium Calgary Calgary, AB
Apr 22, 3:30 pm 2018
Sunday
Apr 22
3:30 pm
2Cellos
Southern Alberta Jubilee Auditorium, Calgary, AB
SELECT * from toolvenuepagelink WHERE venueid = 2661
SELECT * from toolcitypagelink WHERE cityname = 'Calgary'
2Cellos
Southern Alberta Jubilee Auditorium Calgary Calgary, AB
Apr 22, 8:00 pm 2018
Sunday
Apr 22
8:00 pm
2Cellos
Southern Alberta Jubilee Auditorium, Calgary, AB
SELECT * from toolvenuepagelink WHERE venueid = 433
SELECT * from toolcitypagelink WHERE cityname = 'Edmonton'
2Cellos
Northern Alberta Jubilee Auditorium Edmonton Edmonton, AB
Apr 23, 8:00 pm 2018
Monday
Apr 23
8:00 pm
2Cellos
Northern Alberta Jubilee Auditorium, Edmonton, AB
SELECT * from toolvenuepagelink WHERE venueid = 557
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
2Cellos
Rogers Arena Vancouver Vancouver, BC
Apr 25, 8:00 pm 2018
Wednesday
Apr 25
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 276
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'

October

2Cellos
Chicago Theatre Chicago Chicago, IL
Oct 28, 7:30 pm 2018
Sunday
Oct 28
7:30 pm
2Cellos
Chicago Theatre, Chicago, IL
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football