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

June

Eugene Emeralds at Vancouver Canadians
Scotiabank Field Vancouver Vancouver, BC
Jun 17, 7:05 pm 2019
Monday
Jun 17
7:05 pm
Eugene Emeralds at Vancouver Canadians
Scotiabank Field Vancouver Vancouver, BC
Jun 18, 7:05 pm 2019
Tuesday
Jun 18
7:05 pm
Eugene Emeralds at Vancouver Canadians
Scotiabank Field Vancouver Vancouver, BC
Jun 19, 7:05 pm 2019
Wednesday
Jun 19
7:05 pm
Eugene Emeralds at Vancouver Canadians
Scotiabank Field Vancouver Vancouver, BC
Jun 20, 1:05 pm 2019
Thursday
Jun 20
1:05 pm