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

November

2Cellos
Riverside Theatre - Perth Perth Perth, Au
Nov 23, 8:00 pm 2018
Friday
Nov 23
8:00 pm
2Cellos
Riverside Theatre - Perth, Perth, Au
SELECT * from toolvenuepagelink WHERE venueid = 28847
SELECT * from toolcitypagelink WHERE cityname = 'Melbourne'
2Cellos
The Plenary At Melbourne Convention and Exhibition Centre Melbourne Melbourne,
Nov 24, 8:00 pm 2018
Saturday
Nov 24
8:00 pm
2Cellos
The Plenary At Melbourne Convention and Exhibition Centre, Melbourne,
SELECT * from toolvenuepagelink WHERE venueid = 29913
SELECT * from toolcitypagelink WHERE cityname = 'Hindmarsh'
2Cellos
Adelaide Entertainment Centre Hindmarsh Hindmarsh, SA
Nov 26, 8:00 pm 2018
Monday
Nov 26
8:00 pm
2Cellos
Adelaide Entertainment Centre, Hindmarsh, SA
SELECT * from toolvenuepagelink WHERE venueid = 33957
SELECT * from toolcitypagelink WHERE cityname = 'Sydney'
2Cellos
ICC Sydney Sydney Sydney,
Nov 28, 8:00 pm 2018
Wednesday
Nov 28
8:00 pm
2Cellos
ICC Sydney, Sydney,
SELECT * from toolvenuepagelink WHERE venueid = 33956
SELECT * from toolcitypagelink WHERE cityname = 'Auckland, Auckland'

December

2Cellos
The Civic Auckland, Auckland Auckland, Auckland,
Dec 3, 8:00 pm 2018
Monday
Dec 3
8:00 pm
2Cellos
The Civic, Auckland, Auckland,
SELECT * from toolvenuepagelink WHERE venueid = 6423
SELECT * from toolcitypagelink WHERE cityname = 'Kent'

February

2Cellos
ShoWare Center Kent Kent, WA
Feb 5, 12:00 am 2019
Tuesday
Feb 5
12:00 am
2Cellos
ShoWare Center, Kent, WA
SELECT * from toolvenuepagelink WHERE venueid = 1343
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
2Cellos
Moda Center Portland Portland, OR
Feb 6, 8:00 pm 2019
Wednesday
Feb 6
8:00 pm
2Cellos
Moda Center, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 1422
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
2Cellos
Shrine Auditorium and Expo Hall Los Angeles Los Angeles, CA
Feb 8, 12:00 am 2019
Friday
Feb 8
12:00 am
2Cellos
Shrine Auditorium and Expo Hall, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 1384
SELECT * from toolcitypagelink WHERE cityname = 'San Jose'
2Cellos
SAP Center at San Jose San Jose San Jose, CA
Feb 9, 8:00 pm 2019
Saturday
Feb 9
8:00 pm
2Cellos
SAP Center at San Jose, San Jose, CA
SELECT * from toolvenuepagelink WHERE venueid = 8000
SELECT * from toolcitypagelink WHERE cityname = 'San Diego'
2Cellos
Valley View Casino Center San Diego San Diego, CA
Feb 10, 12:00 am 2019
Sunday
Feb 10
12:00 am
2Cellos
Valley View Casino Center, San Diego, CA
SELECT * from toolvenuepagelink WHERE venueid = 7648
SELECT * from toolcitypagelink WHERE cityname = 'Phoenix'
2Cellos
Comerica Theatre Phoenix Phoenix, AZ
Feb 11, 7:30 pm 2019
Monday
Feb 11
7:30 pm
2Cellos
Comerica Theatre, Phoenix, AZ
SELECT * from toolvenuepagelink WHERE venueid = 399
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
2Cellos
Vivint Smart Home Arena Salt Lake City Salt Lake City, UT
Feb 13, 8:00 pm 2019
Wednesday
Feb 13
8:00 pm
2Cellos
Vivint Smart Home Arena, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 1219
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
2Cellos
Pepsi Center Denver Denver, CO
Feb 14, 8:00 pm 2019
Thursday
Feb 14
8:00 pm
2Cellos
Pepsi Center, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 33479
SELECT * from toolcitypagelink WHERE cityname = 'Irving'
2Cellos
The Pavilion at Irving Music Factory Irving Irving, TX
Feb 16, 8:00 pm 2019
Saturday
Feb 16
8:00 pm
2Cellos
The Pavilion at Irving Music Factory, Irving, TX
SELECT * from toolvenuepagelink WHERE venueid = 33353
SELECT * from toolcitypagelink WHERE cityname = 'Sugar Land'
2Cellos
Smart Financial Centre Sugar Land Sugar Land, TX
Feb 17, 7:30 pm 2019
Sunday
Feb 17
7:30 pm
2Cellos
Smart Financial Centre, Sugar Land, TX
SELECT * from toolvenuepagelink WHERE venueid = 4603
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
2Cellos
Sprint Center Kansas City Kansas City, MO
Feb 19, 7:30 pm 2019
Tuesday
Feb 19
7:30 pm
2Cellos
Sprint Center, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 1534
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
2Cellos
Target Center Minneapolis Minneapolis, MN
Feb 20, 8:00 pm 2019
Wednesday
Feb 20
8:00 pm
2Cellos
Target Center, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 5263
SELECT * from toolcitypagelink WHERE cityname = 'St Louis'
2Cellos
Chaifetz Arena St Louis St Louis, MO
Feb 21, 8:00 pm 2019
Thursday
Feb 21
8:00 pm
2Cellos
Chaifetz Arena, St Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 526
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
2Cellos
Fox Theatre Detroit Detroit Detroit, MI
Feb 23, 3:00 pm 2019
Saturday
Feb 23
3:00 pm
2Cellos
Fox Theatre Detroit, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 526
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
2Cellos
Fox Theatre Detroit Detroit Detroit, MI
Feb 23, 7:30 pm 2019
Saturday
Feb 23
7:30 pm
2Cellos
Fox Theatre Detroit, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 33662
SELECT * from toolcitypagelink WHERE cityname = 'Milwaukee'
2Cellos
Fiserv Forum Milwaukee Milwaukee, WI
Feb 24, 8:00 pm 2019
Sunday
Feb 24
8:00 pm
2Cellos
Fiserv Forum, Milwaukee, WI
SELECT * from toolvenuepagelink WHERE venueid = 1633
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'

March

2Cellos
United Center Chicago Chicago, IL
Mar 26, 7:30 pm 2019
Tuesday
Mar 26
7:30 pm
2Cellos
United Center, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 614
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
2Cellos
Quicken Loans Arena Cleveland Cleveland, OH
Mar 27, 12:00 am 2019
Wednesday
Mar 27
12:00 am
2Cellos
Quicken Loans Arena, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 2379
SELECT * from toolcitypagelink WHERE cityname = 'Hershey'
2Cellos
Giant Center Hershey Hershey, PA
Mar 29, 8:00 pm 2019
Friday
Mar 29
8:00 pm
2Cellos
Giant Center, Hershey, PA
SELECT * from toolvenuepagelink WHERE venueid = 3238
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
2Cellos
Agganis Arena Boston Boston, MA
Mar 30, 8:00 pm 2019
Saturday
Mar 30
8:00 pm
2Cellos
Agganis Arena, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 4613
SELECT * from toolcitypagelink WHERE cityname = 'Syracuse'

April

2Cellos
Crouse Hinds Theater - The Oncenter Syracuse Syracuse, NY
Apr 1, 8:00 pm 2019
Monday
Apr 1
8:00 pm
2Cellos
Crouse Hinds Theater - The Oncenter, Syracuse, NY
SELECT * from toolvenuepagelink WHERE venueid = 1205
SELECT * from toolcitypagelink WHERE cityname = 'Fairfax'
2Cellos
Eaglebank Arena Fairfax Fairfax, VA
Apr 2, 8:00 pm 2019
Tuesday
Apr 2
8:00 pm
2Cellos
Eaglebank Arena, Fairfax, VA
SELECT * from toolvenuepagelink WHERE venueid = 7329
SELECT * from toolcitypagelink WHERE cityname = 'Pittsburgh'
2Cellos
PPG Paints Arena Pittsburgh Pittsburgh, PA
Apr 3, 8:00 pm 2019
Wednesday
Apr 3
8:00 pm
2Cellos
PPG Paints Arena, Pittsburgh, PA
SELECT * from toolvenuepagelink WHERE venueid = 2061
SELECT * from toolcitypagelink WHERE cityname = 'Uncasville'
2Cellos
Mohegan Sun Arena Uncasville Uncasville, CT
Apr 5, 8:00 pm 2019
Friday
Apr 5
8:00 pm
2Cellos
Mohegan Sun Arena, Uncasville, CT
SELECT * from toolvenuepagelink WHERE venueid = 1275
SELECT * from toolcitypagelink WHERE cityname = 'New York'
2Cellos
Radio City Music Hall New York New York, NY
Apr 6, 3:00 pm 2019
Saturday
Apr 6
3:00 pm
2Cellos
Radio City Music Hall, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 1275
SELECT * from toolcitypagelink WHERE cityname = 'New York'
2Cellos
Radio City Music Hall New York New York, NY
Apr 6, 8:00 pm 2019
Saturday
Apr 6
8:00 pm
2Cellos
Radio City Music Hall, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 1454
SELECT * from toolcitypagelink WHERE cityname = 'Trenton'
2Cellos
CURE Insurance Arena Trenton Trenton, NJ
Apr 7, 12:00 am 2019
Sunday
Apr 7
12:00 am
2Cellos
CURE Insurance Arena, Trenton, NJ
SELECT * from toolvenuepagelink WHERE venueid = 141
SELECT * from toolcitypagelink WHERE cityname = 'Greenville'
2Cellos
Bon Secours Wellness Arena Greenville Greenville, SC
Apr 9, 7:30 pm 2019
Tuesday
Apr 9
7:30 pm
2Cellos
Bon Secours Wellness Arena, Greenville, SC
SELECT * from toolvenuepagelink WHERE venueid = 617
SELECT * from toolcitypagelink WHERE cityname = 'Duluth'
2Cellos
Infinite Energy Arena Duluth Duluth, GA
Apr 10, 8:00 pm 2019
Wednesday
Apr 10
8:00 pm
2Cellos
Infinite Energy Arena, Duluth, GA
SELECT * from toolvenuepagelink WHERE venueid = 1080
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
2Cellos
Bridgestone Arena Nashville Nashville, TN
Apr 11, 8:00 pm 2019
Thursday
Apr 11
8:00 pm
2Cellos
Bridgestone Arena, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
2Cellos
Amalie Arena Tampa Tampa, FL
Apr 13, 8:00 pm 2019
Saturday
Apr 13
8:00 pm
2Cellos
Amalie Arena, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 1537
SELECT * from toolcitypagelink WHERE cityname = 'Orlando'
2Cellos
Amway Center Orlando Orlando, FL
Apr 14, 7:30 pm 2019
Sunday
Apr 14
7:30 pm
2Cellos
Amway Center, Orlando, FL
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football