LISTE POUR : The Arkells

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

March

Arkells with Dear Rouge
The Casbah San Diego San Diego, CA
Mar 24, 9:30 pm 2019
Sunday
Mar 24
9:30 pm
Arkells with Dear Rouge
The Casbah, San Diego, CA
SELECT * from toolvenuepagelink WHERE venueid = 1606
SELECT * from toolcitypagelink WHERE cityname = 'West Hollywood'
Arkells with Dear Rouge
Troubadour West Hollywood West Hollywood, CA
Mar 26, 8:00 pm 2019
Tuesday
Mar 26
8:00 pm
Arkells with Dear Rouge
Troubadour, West Hollywood, CA
SELECT * from toolvenuepagelink WHERE venueid = 33546
SELECT * from toolcitypagelink WHERE cityname = 'Berkeley'
Arkells with Dear Rouge
Cornerstone Berkeley Berkeley, CA
Mar 27, 8:30 pm 2019
Wednesday
Mar 27
8:30 pm
Arkells with Dear Rouge
Cornerstone, Berkeley, CA
SELECT * from toolvenuepagelink WHERE venueid = 5108
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Arkells with Dear Rouge
Doug Fir Lounge Portland Portland, OR
Mar 29, 9:00 pm 2019
Friday
Mar 29
9:00 pm
Arkells with Dear Rouge
Doug Fir Lounge, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 4275
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Arkells with Dear Rouge
Chop Suey Seattle Seattle, WA
Mar 30, 6:00 pm 2019
Saturday
Mar 30
6:00 pm
Arkells with Dear Rouge
Chop Suey, 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