SELECT tbproductions.*, ttvenues.city,ttvenues.state, CONCAT(ttvenues.city,', ',ttvenues.state) as Region FROM tbproductions,ttvenues , tevoEventPerformers
WHERE tbEventsID = 18599 AND tevoEventPerformers.performerId = 18599 AND tbproductions.tbVenuesID = ttvenues.id AND tbproductions.tbVenuesID = ttvenues.id AND tevoEventPerformers.eventId = tbproductions.ID
ORDER BY tbproductions.Eventdate
March
Pennsylvania Ballet - Giselle
http://www.qualityplustickets.com/searchtickets.php?productionID=1580607
Academy of Music
Philadelphia Philadelphia, PA
Mar 7, 7:30 pm 2019
Pennsylvania Ballet - Giselle
http://www.qualityplustickets.com/searchtickets.php?productionID=1580608
Academy of Music
Philadelphia Philadelphia, PA
Mar 8, 7:30 pm 2019
Russian National Ballet: Giselle
http://www.qualityplustickets.com/searchtickets.php?productionID=1642760
Ferguson Center for the Arts Concert Hall
Newport News Newport News, VA
Mar 8, 8:00 pm 2019
Pennsylvania Ballet: Giselle
http://www.qualityplustickets.com/searchtickets.php?productionID=1575263
Academy of Music
Philadelphia Philadelphia, PA
Mar 9, 2:00 pm 2019
Pennsylvania Ballet: Giselle
http://www.qualityplustickets.com/searchtickets.php?productionID=1575288
Academy of Music
Philadelphia Philadelphia, PA
Mar 10, 2:00 pm 2019
Pennsylvania Ballet - Giselle
http://www.qualityplustickets.com/searchtickets.php?productionID=1580609
Academy of Music
Philadelphia Philadelphia, PA
Mar 15, 7:30 pm 2019
Pennsylvania Ballet - Giselle
http://www.qualityplustickets.com/searchtickets.php?productionID=1580610
Academy of Music
Philadelphia Philadelphia, PA
Mar 16, 2:00 pm 2019
Pennsylvania Ballet - Giselle
http://www.qualityplustickets.com/searchtickets.php?productionID=1580612
Academy of Music
Philadelphia Philadelphia, PA
Mar 16, 8:00 pm 2019
Pennsylvania Ballet - Giselle
http://www.qualityplustickets.com/searchtickets.php?productionID=1580613
Academy of Music
Philadelphia Philadelphia, PA
Mar 17, 2:00 pm 2019
April
Russian National Ballet: Giselle
http://www.qualityplustickets.com/searchtickets.php?productionID=1533998
The Community Theatre at Mayo Center of the Performing Arts
Morristown Morristown, NJ
Apr 4, 7:30 pm 2019
Les Grands Ballets Canadiens: Giselle
http://www.qualityplustickets.com/searchtickets.php?productionID=1582685
Apr 4, 8:00 pm 2019
Les Grands Ballets Canadiens: Giselle
http://www.qualityplustickets.com/searchtickets.php?productionID=1582686
Apr 5, 8:00 pm 2019
Les Grands Ballets Canadiens: Giselle
http://www.qualityplustickets.com/searchtickets.php?productionID=1582688
Apr 6, 8:00 pm 2019
Les Grandes Ballet
http://www.qualityplustickets.com/searchtickets.php?productionID=1452376
Apr 11, 8:00 pm 2019
Giselle
http://www.qualityplustickets.com/searchtickets.php?productionID=1545318
Orpheum Theatre - Memphis
Memphis Memphis, TN
Apr 12, 7:30 pm 2019
Giselle
Orpheum Theatre - Memphis, Memphis, TN
Les Grandes Ballet
http://www.qualityplustickets.com/searchtickets.php?productionID=1452377
Apr 12, 8:00 pm 2019
Les Grandes Ballet
http://www.qualityplustickets.com/searchtickets.php?productionID=1452378
Apr 13, 2:00 pm 2019
Giselle
http://www.qualityplustickets.com/searchtickets.php?productionID=1542658
Orpheum Theatre - Memphis
Memphis Memphis, TN
Apr 13, 7:30 pm 2019
Giselle
Orpheum Theatre - Memphis, Memphis, TN
Les Grandes Ballet
http://www.qualityplustickets.com/searchtickets.php?productionID=1452379
Apr 13, 8:00 pm 2019
Giselle
http://www.qualityplustickets.com/searchtickets.php?productionID=1542657
Orpheum Theatre - Memphis
Memphis Memphis, TN
Apr 14, 2:00 pm 2019
Giselle
Orpheum Theatre - Memphis, Memphis, TN
Russian Ballet: Giselle
http://www.qualityplustickets.com/searchtickets.php?productionID=1611655
Bluma Appel Theatre
Toronto Toronto, ON
Apr 27, 8:00 pm 2019
Russian Ballet: Giselle
http://www.qualityplustickets.com/searchtickets.php?productionID=1619155
Bluma Appel Theatre
Toronto Toronto, ON
Apr 28, 2:30 pm 2019
Russian Ballet: Giselle
http://www.qualityplustickets.com/searchtickets.php?productionID=1619154
Bluma Appel Theatre
Toronto Toronto, ON
Apr 28, 6:30 pm 2019
May
Ballet Austin: Giselle
http://www.qualityplustickets.com/searchtickets.php?productionID=1508649
Dell Hall - Long Center for the Performing Arts
Austin Austin, TX
May 10, 8:00 pm 2019
Ballet Austin: Giselle
http://www.qualityplustickets.com/searchtickets.php?productionID=1508650
Dell Hall - Long Center for the Performing Arts
Austin Austin, TX
May 11, 2:00 pm 2019
Ballet Austin: Giselle
http://www.qualityplustickets.com/searchtickets.php?productionID=1508651
Dell Hall - Long Center for the Performing Arts
Austin Austin, TX
May 11, 8:00 pm 2019
Ballet Austin: Giselle
http://www.qualityplustickets.com/searchtickets.php?productionID=1508652
Dell Hall - Long Center for the Performing Arts
Austin Austin, TX
May 12, 3:00 pm 2019
|