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