LISTE POUR : John 5

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

March

John 5
Dickens Calgary Calgary, AB
Mar 29, 7:00 pm 2019
Friday
Mar 29
7:00 pm
John 5
Dickens, Calgary, AB
SELECT * from toolvenuepagelink WHERE venueid = 25930
SELECT * from toolcitypagelink WHERE cityname = 'Edmonton'
John 5 with Jared James Nichols
Starlite Room Edmonton Edmonton, AB
Mar 30, 6:00 pm 2019
Saturday
Mar 30
6:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 9124
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Jared James Nichols
Rickshaw Theatre Vancouver Vancouver, BC
Mar 31, 6:30 pm 2019
Sunday
Mar 31
6:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 3268
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'

April

John 5
Crocodile Cafe Seattle Seattle, WA
Apr 2, 6:30 pm 2019
Tuesday
Apr 2
6:30 pm
John 5
Crocodile Cafe, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 16317
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
John 5
Star Theater Portland Portland, OR
Apr 3, 7:15 pm 2019
Wednesday
Apr 3
7:15 pm
John 5
Star Theater, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 1734
SELECT * from toolcitypagelink WHERE cityname = 'West Hollywood'
John 5
Whisky A Go Go West Hollywood West Hollywood, CA
Apr 6, 7:15 pm 2019
Saturday
Apr 6
7:15 pm
John 5
Whisky A Go Go, West Hollywood, CA
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football