SELECT tbproductions.*, ttvenues.city,ttvenues.state, CONCAT(ttvenues.city,', ',ttvenues.state) as Region FROM tbproductions,ttvenues , tevoEventPerformers
WHERE tbEventsID = 18575 AND tevoEventPerformers.performerId = 18575 AND tbproductions.tbVenuesID = ttvenues.id AND tbproductions.tbVenuesID = ttvenues.id AND tevoEventPerformers.eventId = tbproductions.ID
ORDER BY tbproductions.Eventdate
March
Gerry Dee
http://www.qualityplustickets.com/searchtickets.php?productionID=1617633
Casino Rama Resort
Rama Rama, ON
Mar 1, 9:00 pm 2019
April
Gerry Dee
http://www.qualityplustickets.com/searchtickets.php?productionID=1617606
Bell Performing Arts Centre
Surrey Surrey, BC
Apr 5, 8:00 pm 2019
Gerry Dee
Bell Performing Arts Centre, Surrey, BC
Gerry Dee
http://www.qualityplustickets.com/searchtickets.php?productionID=1618105
Vancouver Centre for Performing Arts
Vancouver Vancouver, BC
Apr 6, 8:00 pm 2019
Gerry Dee
http://www.qualityplustickets.com/searchtickets.php?productionID=1620702
Rebecca Cohn Auditorium
Halifax Halifax, NS
Apr 23, 7:00 pm 2019
Gerry Dee
Rebecca Cohn Auditorium, Halifax, NS
May
Gerry Dee
http://www.qualityplustickets.com/searchtickets.php?productionID=1618028
May 24, 8:00 pm 2019
|