SELECT tbproductions.*, ttvenues.city,ttvenues.state, CONCAT(ttvenues.city,', ',ttvenues.state) as Region FROM tbproductions,ttvenues , tevoEventPerformers
WHERE tbEventsID = 8903 AND tevoEventPerformers.performerId = 8903 AND tevoEventPerformers.isPrimary = 1 AND tbproductions.tbVenuesID = ttvenues.id AND tbproductions.tbVenuesID = ttvenues.id AND tevoEventPerformers.eventId = tbproductions.ID
ORDER BY tbproductions.Eventdate
Don't miss out on getting amazing Pink Martini tour tickets. At QualityPlusTickets.com we will alert you when the Pink Martini tour tickets are available at a venue near you. Sign up for a Pink Martini tour alerts now. Check out our selection or call 1-888-937-0108 to get your Quality Pink Martini tickets now.
Get Pink Martini Tour Concert Tickets at Quality Plus Tickets now!
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.