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

January

2Cellos (Rescheduled from 11/2)
Jones Hall Houston Houston, TX
Jan 16, 7:00 pm 2018
Tuesday
Jan 16
7:00 pm
2Cellos (Rescheduled from 11/2)
Jones Hall, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 460
SELECT * from toolcitypagelink WHERE cityname = 'Austin'
2Cellos (Rescheduled from 11/3)
Frank Erwin Events Center Austin Austin, TX
Jan 18, 7:30 pm 2018
Thursday
Jan 18
7:30 pm
2Cellos (Rescheduled from 11/3)
Frank Erwin Events Center, Austin, TX
SELECT * from toolvenuepagelink WHERE venueid = 33479
SELECT * from toolcitypagelink WHERE cityname = 'Irving'
2Cellos (Rescheduled from 11/4)
The Pavilion at Irving Music Factory Irving Irving, TX
Jan 19, 8:00 pm 2018
Friday
Jan 19
8:00 pm
2Cellos (Rescheduled from 11/4)
The Pavilion at Irving Music Factory, Irving, TX
SELECT * from toolvenuepagelink WHERE venueid = 174
SELECT * from toolcitypagelink WHERE cityname = 'Tulsa'
2Cellos (Rescheduled from 11/1)
Brady Theater Tulsa Tulsa, OK
Jan 20, 7:30 pm 2018
Saturday
Jan 20
7:30 pm
2Cellos (Rescheduled from 11/1)
Brady Theater, Tulsa, OK
SELECT * from toolvenuepagelink WHERE venueid = 4603
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
2Cellos (Rescheduled from 11/5)
Sprint Center Kansas City Kansas City, MO
Jan 21, 7:00 pm 2018
Sunday
Jan 21
7:00 pm
2Cellos (Rescheduled from 11/5)
Sprint Center, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 526
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
2Cellos (Rescheduled from 10/27)
Fox Theatre Detroit Detroit Detroit, MI
Jan 23, 8:00 pm 2018
Tuesday
Jan 23
8:00 pm
2Cellos (Rescheduled from 10/27)
Fox Theatre Detroit, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 173
SELECT * from toolcitypagelink WHERE cityname = 'Milwaukee'
2Cellos (Rescheduled from 10/26)
BMO Harris Bradley Center Milwaukee Milwaukee, WI
Jan 24, 8:00 pm 2018
Wednesday
Jan 24
8:00 pm
2Cellos (Rescheduled from 10/26)
BMO Harris Bradley Center, Milwaukee, WI
SELECT * from toolvenuepagelink WHERE venueid = 1534
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
2Cellos (Rescheduled from 10/25)
Target Center Minneapolis Minneapolis, MN
Jan 25, 8:00 pm 2018
Thursday
Jan 25
8:00 pm
2Cellos (Rescheduled from 10/25)
Target Center, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 596
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
2Cellos (Rescheduled from 10/29)
Grand Ole Opry House Nashville Nashville, TN
Jan 27, 7:30 pm 2018
Saturday
Jan 27
7:30 pm
2Cellos (Rescheduled from 10/29)
Grand Ole Opry House, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 276
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
2Cellos (Rescheduled from 10/28)
Chicago Theatre Chicago Chicago, IL
Jan 28, 3:00 pm 2018
Sunday
Jan 28
3:00 pm
2Cellos (Rescheduled from 10/28)
Chicago Theatre, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 276
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
2Cellos (Rescheduled from 10/28)
Chicago Theatre Chicago Chicago, IL
Jan 28, 8:00 pm 2018
Sunday
Jan 28
8:00 pm
2Cellos (Rescheduled from 10/28)
Chicago Theatre, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 474
SELECT * from toolcitypagelink WHERE cityname = 'St Louis'
2Cellos (Rescheduled from 10/23)
Fabulous Fox Theatre - St. Louis St Louis St Louis, MO
Jan 29, 7:30 pm 2018
Monday
Jan 29
7:30 pm
2Cellos (Rescheduled from 10/23)
Fabulous Fox Theatre - St. Louis, St Louis, MO
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