SELECT tbproductions.*, ttvenues.city,ttvenues.state, CONCAT(ttvenues.city,', ',ttvenues.state) as Region FROM tbproductions,ttvenues , tevoEventPerformers
WHERE tbEventsID = 29838 AND tevoEventPerformers.performerId = 29838 AND tbproductions.tbVenuesID = ttvenues.id AND tbproductions.tbVenuesID = ttvenues.id AND tevoEventPerformers.eventId = tbproductions.ID
ORDER BY tbproductions.Eventdate
QualityPlusTickets is a full service ticket broker specializing in the selling and buying of sports, concerts, Montreal Canadiens Tickets and all other event tickets in Canada and the USA. Tickets can be ordered online or by phone and can be picked up at our office or sent by priority courier anywhere in the world.