SELECT tbproductions.*, ttvenues.city,ttvenues.state, CONCAT(ttvenues.city,', ',ttvenues.state) as Region FROM tbproductions,ttvenues , tevoEventPerformers
WHERE tbEventsID = 55141 AND tevoEventPerformers.performerId = 55141 AND tbproductions.tbVenuesID = ttvenues.id AND tbproductions.tbVenuesID = ttvenues.id AND tevoEventPerformers.eventId = tbproductions.ID
ORDER BY tbproductions.Eventdate
February
Saves The Day with Remo Drive
http://www.qualityplustickets.com/searchtickets.php?productionID=1580221
The Showbox
Seattle Seattle, WA
Feb 22, 8:00 pm 2019
Saves The Day with Remo Drive
http://www.qualityplustickets.com/searchtickets.php?productionID=1644542
Biltmore Cabaret
Vancouver Vancouver, BC
Feb 23, 8:15 pm 2019
Saves The Day with Remo Drive
http://www.qualityplustickets.com/searchtickets.php?productionID=1580318
Slim's
San Francisco San Francisco, CA
Feb 27, 7:30 pm 2019
Saves The Day with Remo Drive
http://www.qualityplustickets.com/searchtickets.php?productionID=1580425
Troubadour
West Hollywood West Hollywood, CA
Feb 28, 7:00 pm 2019
March
Saves The Day with Remo Drive
http://www.qualityplustickets.com/searchtickets.php?productionID=1583944
Crescent Ballroom - AZ
Phoenix Phoenix, AZ
Mar 3, 7:30 pm 2019
Saves The Day with Remo Drive
http://www.qualityplustickets.com/searchtickets.php?productionID=1580212
Saturn
Birmingham Birmingham, AL
Mar 8, 8:00 pm 2019
|