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