LISTING FOR:
Boise Hawks
SELECT tbproductions.*, ttvenues.city,ttvenues.state, CONCAT(ttvenues.city,', ',ttvenues.state) as Region FROM tbproductions,ttvenues , tevoEventPerformers WHERE tbEventsID = 47558 AND tevoEventPerformers.performerId = 47558 AND tbproductions.tbVenuesID = ttvenues.id AND tbproductions.tbVenuesID = ttvenues.id AND tevoEventPerformers.eventId = tbproductions.ID ORDER BY tbproductions.Eventdate
DATES
EVENT

August

Boise Hawks at Vancouver Canadians
Scotiabank Field Vancouver Vancouver, BC
Aug 17, 7:05 pm 2019
Saturday
Aug 17
7:05 pm
Boise Hawks at Vancouver Canadians
Scotiabank Field Vancouver Vancouver, BC
Aug 18, 1:05 pm 2019
Sunday
Aug 18
1:05 pm
Boise Hawks at Vancouver Canadians
Scotiabank Field Vancouver Vancouver, BC
Aug 19, 7:05 pm 2019
Monday
Aug 19
7:05 pm