LISTE POUR : RY X

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

March

RY X
Le National Montreal Montreal, PQ
Mar 24, 8:00 pm 2019
Sunday
Mar 24
8:00 pm
RY X
Le National, Montreal, PQ
SELECT * from toolvenuepagelink WHERE venueid = 9500
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
RY X
The Great Hall Toronto Toronto, ON
Mar 25, 7:00 pm 2019
Monday
Mar 25
7:00 pm
RY X
The Great Hall, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 1551
SELECT * from toolcitypagelink WHERE cityname = 'Jackson'
RY X
Thalia Mara Hall Jackson Jackson, MS
Mar 26, 7:30 pm 2019
Tuesday
Mar 26
7:30 pm
RY X
Thalia Mara Hall, Jackson, MS
SELECT * from toolvenuepagelink WHERE venueid = 31629
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
RY X
The Theatre at Ace Hotel Los Angeles Los Angeles, CA
Mar 28, 8:00 pm 2019
Thursday
Mar 28
8:00 pm
RY X
The Theatre at Ace Hotel, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 8412
SELECT * from toolcitypagelink WHERE cityname = 'Portland'

April

RY X
Aladdin Theater Portland Portland, OR
Apr 1, 8:00 pm 2019
Monday
Apr 1
8:00 pm
RY X
Aladdin Theater, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 134
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Ry X
Benaroya Hall Seattle Seattle, WA
Apr 3, 8:00 pm 2019
Wednesday
Apr 3
8:00 pm
Ry X
Benaroya 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