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

March

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