SELECT tbproductions.*, ttvenues.city,ttvenues.state, CONCAT(ttvenues.city,', ',ttvenues.state) as Region FROM tbproductions,ttvenues , tevoEventPerformers
WHERE tbEventsID = 13189 AND tevoEventPerformers.performerId = 13189 AND tbproductions.tbVenuesID = ttvenues.id AND tbproductions.tbVenuesID = ttvenues.id AND tevoEventPerformers.eventId = tbproductions.ID
ORDER BY tbproductions.Eventdate
Wynton Marsalis with Jazz at Lincoln Center Orchestra
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.