LISTE POUR : Carmen

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

January

Opera Carolina: Carmen
Belk Theatre - Blumenthal PAC Charlotte Charlotte, NC
Jan 17, 7:00 pm 2019
Thursday
Jan 17
7:00 pm
Opera Carolina: Carmen
Belk Theatre - Blumenthal PAC, Charlotte, NC
SELECT * from toolvenuepagelink WHERE venueid = 2491
SELECT * from toolcitypagelink WHERE cityname = 'Charlotte'
Carmen
Belk Theatre - Blumenthal PAC Charlotte Charlotte, NC
Jan 19, 8:00 pm 2019
Saturday
Jan 19
8:00 pm
Carmen
Belk Theatre - Blumenthal PAC, Charlotte, NC
SELECT * from toolvenuepagelink WHERE venueid = 2491
SELECT * from toolcitypagelink WHERE cityname = 'Charlotte'
Carmen
Belk Theatre - Blumenthal PAC Charlotte Charlotte, NC
Jan 20, 2:00 pm 2019
Sunday
Jan 20
2:00 pm
Carmen
Belk Theatre - Blumenthal PAC, Charlotte, NC
SELECT * from toolvenuepagelink WHERE venueid = 2491
SELECT * from toolcitypagelink WHERE cityname = 'Charlotte'
Carmen
Belk Theatre - Blumenthal PAC Charlotte Charlotte, NC
Jan 24, 7:30 pm 2019
Thursday
Jan 24
7:30 pm
Carmen
Belk Theatre - Blumenthal PAC, Charlotte, NC
SELECT * from toolvenuepagelink WHERE venueid = 5078
SELECT * from toolcitypagelink WHERE cityname = 'Kingston'

February

Carmen
UPAC - The Ulster Performing Arts Center Kingston Kingston, NY
Feb 2, 1:00 pm 2019
Saturday
Feb 2
1:00 pm
Carmen
UPAC - The Ulster Performing Arts Center, Kingston, NY
SELECT * from toolvenuepagelink WHERE venueid = 111
SELECT * from toolcitypagelink WHERE cityname = 'Poughkeepsie'
Carmen
Bardavon Opera House Poughkeepsie Poughkeepsie, NY
Feb 2, 1:00 pm 2019
Saturday
Feb 2
1:00 pm
Carmen
Bardavon Opera House, Poughkeepsie, NY
SELECT * from toolvenuepagelink WHERE venueid = 8545
SELECT * from toolcitypagelink WHERE cityname = 'Portsmouth'
Carmen
Portsmouth Music Hall Portsmouth Portsmouth, NH
Feb 9, 1:00 pm 2019
Saturday
Feb 9
1:00 pm
Carmen
Portsmouth Music Hall, Portsmouth, NH
SELECT * from toolvenuepagelink WHERE venueid = 28461
SELECT * from toolcitypagelink WHERE cityname = 'Annapolis'

March

Carmen
Maryland Hall Annapolis Annapolis,
Mar 15, 8:00 pm 2019
Friday
Mar 15
8:00 pm
Carmen
Maryland Hall, Annapolis,
SELECT * from toolvenuepagelink WHERE venueid = 28461
SELECT * from toolcitypagelink WHERE cityname = 'Annapolis'
Carmen
Maryland Hall Annapolis Annapolis,
Mar 17, 3:00 pm 2019
Sunday
Mar 17
3:00 pm
Carmen
Maryland Hall, Annapolis,
SELECT * from toolvenuepagelink WHERE venueid = 5008
SELECT * from toolcitypagelink WHERE cityname = 'Modesto'

May

Carmen
Gallo Center For The Arts Modesto Modesto, CA
May 3, 7:30 pm 2019
Friday
May 3
7:30 pm
Carmen
Gallo Center For The Arts, Modesto, CA
SELECT * from toolvenuepagelink WHERE venueid = 2780
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Carmen
McCaw Hall Seattle Seattle, WA
May 4, 7:30 pm 2019
Saturday
May 4
7:30 pm
Carmen
McCaw Hall, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 2780
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Carmen
McCaw Hall Seattle Seattle, WA
May 5, 2:00 pm 2019
Sunday
May 5
2:00 pm
Carmen
McCaw Hall, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 5008
SELECT * from toolcitypagelink WHERE cityname = 'Modesto'
Carmen
Gallo Center For The Arts Modesto Modesto, CA
May 5, 2:00 pm 2019
Sunday
May 5
2:00 pm
Carmen
Gallo Center For The Arts, Modesto, CA
SELECT * from toolvenuepagelink WHERE venueid = 2780
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Carmen
McCaw Hall Seattle Seattle, WA
May 8, 7:30 pm 2019
Wednesday
May 8
7:30 pm
Carmen
McCaw Hall, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 2780
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Carmen
McCaw Hall Seattle Seattle, WA
May 11, 7:30 pm 2019
Saturday
May 11
7:30 pm
Carmen
McCaw Hall, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 2780
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Carmen
McCaw Hall Seattle Seattle, WA
May 12, 2:00 pm 2019
Sunday
May 12
2:00 pm
Carmen
McCaw Hall, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 2780
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Carmen
McCaw Hall Seattle Seattle, WA
May 15, 7:30 pm 2019
Wednesday
May 15
7:30 pm
Carmen
McCaw Hall, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 2780
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Carmen
McCaw Hall Seattle Seattle, WA
May 17, 7:30 pm 2019
Friday
May 17
7:30 pm
Carmen
McCaw Hall, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 2780
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Carmen
McCaw Hall Seattle Seattle, WA
May 18, 7:30 pm 2019
Saturday
May 18
7:30 pm
Carmen
McCaw Hall, Seattle, WA
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football