LISTE POUR : Dawes

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

June

Dawes
Agora Theatre Cleveland Cleveland, OH
Jun 24, 8:00 pm 2019
Monday
Jun 24
8:00 pm
Dawes
Agora Theatre, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 1258
SELECT * from toolcitypagelink WHERE cityname = 'Ann Arbor'

July

Dawes
Power Center Ann Arbor Ann Arbor, MI
Jul 26, 8:00 pm 2019
Friday
Jul 26
8:00 pm
Dawes
Power Center, Ann Arbor, MI
SELECT * from toolvenuepagelink WHERE venueid = 794
SELECT * from toolcitypagelink WHERE cityname = 'Wilkes Barre'
Dawes
Kirby Center Wilkes Barre Wilkes Barre, PA
Jul 30, 8:00 pm 2019
Tuesday
Jul 30
8:00 pm
Dawes
Kirby Center, Wilkes Barre, PA
SELECT * from toolvenuepagelink WHERE venueid = 25910
SELECT * from toolcitypagelink WHERE cityname = 'Grand Rapids'
Dawes with Margo Price
Frederik Meijer Gardens Grand Rapids Grand Rapids, MI
Jul 31, 6:30 pm 2019
Wednesday
Jul 31
6:30 pm
Dawes with Margo Price
Frederik Meijer Gardens, Grand Rapids, MI
SELECT * from toolvenuepagelink WHERE venueid = 3919
SELECT * from toolcitypagelink WHERE cityname = 'South Burlington'

August

Dawes
Higher Ground South Burlington South Burlington, VT
Aug 13, 8:00 pm 2019
Tuesday
Aug 13
8:00 pm
Dawes
Higher Ground, South Burlington, VT
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football