LISTE POUR : Amadeus

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

January

Amadeus
Boettcher Concert Hall Denver Denver, CO
Jan 25, 7:30 pm 2019
Friday
Jan 25
7:30 pm
Amadeus
Boettcher Concert Hall, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 1449
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Amadeus
Boettcher Concert Hall Denver Denver, CO
Jan 26, 7:30 pm 2019
Saturday
Jan 26
7:30 pm
Amadeus
Boettcher Concert Hall, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 690
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'

February

Amadeus
Sony Centre for the Performing Arts Toronto Toronto, ON
Feb 21, 7:30 pm 2019
Thursday
Feb 21
7:30 pm
Amadeus
Sony Centre for the Performing Arts, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 690
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Amadeus
Sony Centre for the Performing Arts Toronto Toronto, ON
Feb 22, 7:30 pm 2019
Friday
Feb 22
7:30 pm
Amadeus
Sony Centre for the Performing Arts, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 134
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Amadeus
Benaroya Hall Seattle Seattle, WA
Feb 22, 8:00 pm 2019
Friday
Feb 22
8:00 pm
Amadeus
Benaroya Hall, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 134
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Amadeus
Benaroya Hall Seattle Seattle, WA
Feb 23, 8:00 pm 2019
Saturday
Feb 23
8:00 pm
Amadeus
Benaroya Hall, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 5920
SELECT * from toolcitypagelink WHERE cityname = 'Santa Barbara'

March

Amadeus
Granada Theatre - CA Santa Barbara Santa Barbara, CA
Mar 16, 8:00 pm 2019
Saturday
Mar 16
8:00 pm
Amadeus
Granada Theatre - CA, Santa Barbara, CA
SELECT * from toolvenuepagelink WHERE venueid = 5920
SELECT * from toolcitypagelink WHERE cityname = 'Santa Barbara'
Amadeus
Granada Theatre - CA Santa Barbara Santa Barbara, CA
Mar 17, 3:00 pm 2019
Sunday
Mar 17
3:00 pm
Amadeus
Granada Theatre - CA, Santa Barbara, CA
SELECT * from toolvenuepagelink WHERE venueid = 2183
SELECT * from toolcitypagelink WHERE cityname = 'Portland'

May

Amadeus
Arlene Schnitzer Concert Hall Portland Portland, OR
May 4, 7:30 pm 2019
Saturday
May 4
7:30 pm
Amadeus
Arlene Schnitzer Concert Hall, Portland, OR
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football