LISTE POUR : Il Divo

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

March

Il Divo
Conexus Arts Centre Regina Regina, SK
Mar 4, 8:00 pm 2019
Monday
Mar 4
8:00 pm
Il Divo
Conexus Arts Centre, Regina, SK
SELECT * from toolvenuepagelink WHERE venueid = 248
SELECT * from toolcitypagelink WHERE cityname = 'Winnipeg'
Il Divo
Centennial Concert Hall Winnipeg Winnipeg, MB
Mar 6, 8:00 pm 2019
Wednesday
Mar 6
8:00 pm
Il Divo
Centennial Concert Hall, Winnipeg, MB
SELECT * from toolvenuepagelink WHERE venueid = 2661
SELECT * from toolcitypagelink WHERE cityname = 'Calgary'
Il Divo
Southern Alberta Jubilee Auditorium Calgary Calgary, AB
Mar 8, 8:30 pm 2019
Friday
Mar 8
8:30 pm
Il Divo
Southern Alberta Jubilee Auditorium, Calgary, AB
SELECT * from toolvenuepagelink WHERE venueid = 433
SELECT * from toolcitypagelink WHERE cityname = 'Edmonton'
Il Divo
Northern Alberta Jubilee Auditorium Edmonton Edmonton, AB
Mar 10, 8:00 pm 2019
Sunday
Mar 10
8:00 pm
Il Divo
Northern Alberta Jubilee Auditorium, Edmonton, AB
SELECT * from toolvenuepagelink WHERE venueid = 5813
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Il Divo
Queen Elizabeth Theatre - Toronto Toronto Toronto, ON
Mar 13, 8:00 pm 2019
Wednesday
Mar 13
8:00 pm
Il Divo
Queen Elizabeth Theatre - Toronto, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 1272
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Il Divo
Queen Elizabeth Theatre - Vancouver Vancouver Vancouver, BC
Mar 13, 8:00 pm 2019
Wednesday
Mar 13
8:00 pm
Il Divo
Queen Elizabeth Theatre - Vancouver, Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 4632
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'
Il Divo
The Pearl Concert Theater at Palms Casino Resort Las Vegas Las Vegas, NV
Mar 15, 8:00 pm 2019
Friday
Mar 15
8:00 pm
Il Divo
The Pearl Concert Theater at Palms Casino Resort, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 3489
SELECT * from toolcitypagelink WHERE cityname = 'Indio'
Il Divo
Fantasy Springs Resort Indio Indio, CA
Mar 16, 8:00 pm 2019
Saturday
Mar 16
8:00 pm
Il Divo
Fantasy Springs Resort, Indio, CA
SELECT * from toolvenuepagelink WHERE venueid = 2577
SELECT * from toolcitypagelink WHERE cityname = 'Temecula'
Il Divo
Pechanga Resort & Casino Showroom Temecula Temecula, CA
Mar 17, 7:00 pm 2019
Sunday
Mar 17
7:00 pm
Il Divo
Pechanga Resort & Casino Showroom, Temecula, CA
SELECT * from toolvenuepagelink WHERE venueid = 1380
SELECT * from toolcitypagelink WHERE cityname = 'San Diego'
Il Divo
San Diego Civic Theatre San Diego San Diego, CA
Mar 18, 7:30 pm 2019
Monday
Mar 18
7:30 pm
Il Divo
San Diego Civic Theatre, San Diego, CA
SELECT * from toolvenuepagelink WHERE venueid = 33981
SELECT * from toolcitypagelink WHERE cityname = 'McAllen'
Il Divo
McAllen Performing Arts Center McAllen McAllen, TX
Mar 22, 8:30 pm 2019
Friday
Mar 22
8:30 pm
Il Divo
McAllen Performing Arts Center, McAllen, TX
SELECT * from toolvenuepagelink WHERE venueid = 2407
SELECT * from toolcitypagelink WHERE cityname = 'Laredo'
Il Divo
Sames Auto Arena Laredo Laredo, TX
Mar 23, 8:30 pm 2019
Saturday
Mar 23
8:30 pm
Il Divo
Sames Auto Arena, Laredo, TX
SELECT * from toolvenuepagelink WHERE venueid = 18873
SELECT * from toolcitypagelink WHERE cityname = 'Midland'
IL Divo
Wagner Noel Performing Arts Center Midland Midland, TX
Mar 24, 8:00 pm 2019
Sunday
Mar 24
8:00 pm
IL Divo
Wagner Noel Performing Arts Center, Midland, TX
SELECT * from toolvenuepagelink WHERE venueid = 1346
SELECT * from toolcitypagelink WHERE cityname = 'Rosemont'
Il Divo
Rosemont Theatre Rosemont Rosemont, IL
Mar 27, 8:00 pm 2019
Wednesday
Mar 27
8:00 pm
Il Divo
Rosemont Theatre, Rosemont, IL
SELECT * from toolvenuepagelink WHERE venueid = 526
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
Il Divo
Fox Theatre Detroit Detroit Detroit, MI
Mar 28, 8:30 pm 2019
Thursday
Mar 28
8:30 pm
Il Divo
Fox Theatre Detroit, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 408
SELECT * from toolcitypagelink WHERE cityname = 'Grand Rapids'
Il Divo
DeVos Performance Hall Grand Rapids Grand Rapids, MI
Mar 31, 8:00 pm 2019
Sunday
Mar 31
8:00 pm
Il Divo
DeVos Performance Hall, Grand Rapids, MI
SELECT * from toolvenuepagelink WHERE venueid = 2053
SELECT * from toolcitypagelink WHERE cityname = 'Portland'

April

Il Divo
Merrill Auditorium Portland Portland, ME
Apr 3, 8:00 pm 2019
Wednesday
Apr 3
8:00 pm
Il Divo
Merrill Auditorium, Portland, ME
SELECT * from toolvenuepagelink WHERE venueid = 1160
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Il Divo
Orpheum Theatre - Boston Boston Boston, MA
Apr 4, 8:30 pm 2019
Thursday
Apr 4
8:30 pm
Il Divo
Orpheum Theatre - Boston, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 28062
SELECT * from toolcitypagelink WHERE cityname = 'Bethlehem'
Il Divo
Sands Bethlehem Event Center Bethlehem Bethlehem, PA
Apr 5, 8:00 pm 2019
Friday
Apr 5
8:00 pm
Il Divo
Sands Bethlehem Event Center, Bethlehem, PA
SELECT * from toolvenuepagelink WHERE venueid = 123
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Il Divo
Beacon Theatre New York New York, NY
Apr 6, 8:30 pm 2019
Saturday
Apr 6
8:30 pm
Il Divo
Beacon Theatre, New York, NY
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football