SELECT tbproductions.*, ttvenues.city,ttvenues.state, CONCAT(ttvenues.city,', ',ttvenues.state) as Region FROM tbproductions,ttvenues , tevoEventPerformers
WHERE tbEventsID = 18916 AND tevoEventPerformers.performerId = 18916 AND tbproductions.tbVenuesID = ttvenues.id AND tbproductions.tbVenuesID = ttvenues.id AND tevoEventPerformers.eventId = tbproductions.ID
ORDER BY tbproductions.Eventdate
March
Jay Leno
http://www.qualityplustickets.com/searchtickets.php?productionID=1650679
The Vine at Del Lago Resort
Waterloo Waterloo, NY
Mar 15, 8:00 pm 2019
Jay Leno
The Vine at Del Lago Resort, Waterloo, NY
Jay Leno
http://www.qualityplustickets.com/searchtickets.php?productionID=1643043
The Vine at Del Lago Resort
Waterloo Waterloo, NY
Mar 16, 8:00 pm 2019
Jay Leno
The Vine at Del Lago Resort, Waterloo, NY
Jay Leno
http://www.qualityplustickets.com/searchtickets.php?productionID=1479150
Kiewit Hall
Omaha Omaha, NE
Mar 29, 7:30 pm 2019
April
Pittsburgh Speakers Series
http://www.qualityplustickets.com/searchtickets.php?productionID=1643275
Heinz Hall
Pittsburgh Pittsburgh, PA
Apr 24, 8:00 pm 2019
Jay Leno
http://www.qualityplustickets.com/searchtickets.php?productionID=1644905
New Jersey Performing Arts Center
Newark Newark, NJ
Apr 25, 8:00 pm 2019
Jay Leno
New Jersey Performing Arts Center, Newark, NJ
Jay Leno
http://www.qualityplustickets.com/searchtickets.php?productionID=1571583
Kennedy Center - Terrace Theater
Washington Washington, DC
Apr 26, 8:00 pm 2019
Jay Leno
Kennedy Center - Terrace Theater, Washington, DC
Jay Leno
http://www.qualityplustickets.com/searchtickets.php?productionID=1616903
Roy Thomson Hall
Toronto Toronto, ON
Apr 27, 8:00 pm 2019
May
Jay Leno
http://www.qualityplustickets.com/searchtickets.php?productionID=1649822
Parx Casino and Racing
Bensalem Bensalem, PA
May 11, 8:00 pm 2019
Jay Leno
Parx Casino and Racing, Bensalem, PA
Jay Leno
http://www.qualityplustickets.com/searchtickets.php?productionID=1573669
Terry Fator Theatre - Mirage Las Vegas
Las Vegas Las Vegas, NV
May 17, 10:00 pm 2019
Jay Leno
Terry Fator Theatre - Mirage Las Vegas, Las Vegas, NV
Jay Leno
http://www.qualityplustickets.com/searchtickets.php?productionID=1636443
Flynn Center for the Performing Arts
Burlington Burlington, VT
May 30, 7:30 pm 2019
Jay Leno
Flynn Center for the Performing Arts, Burlington, VT
Jay Leno
http://www.qualityplustickets.com/searchtickets.php?productionID=1620630
Hampton Beach Casino Ballroom
Hampton Hampton, NH
May 31, 8:00 pm 2019
Jay Leno
Hampton Beach Casino Ballroom, Hampton, NH
June
Jay Leno
http://www.qualityplustickets.com/searchtickets.php?productionID=1573668
Terry Fator Theatre - Mirage Las Vegas
Las Vegas Las Vegas, NV
Jun 22, 10:00 pm 2019
Jay Leno
Terry Fator Theatre - Mirage Las Vegas, Las Vegas, NV
July
Jay Leno
http://www.qualityplustickets.com/searchtickets.php?productionID=1573667
Terry Fator Theatre - Mirage Las Vegas
Las Vegas Las Vegas, NV
Jul 26, 10:00 pm 2019
Jay Leno
Terry Fator Theatre - Mirage Las Vegas, Las Vegas, NV
September
Jay Leno
http://www.qualityplustickets.com/searchtickets.php?productionID=1658278
Durham Performing Arts Center
Durham Durham, NC
Sep 20, 8:00 pm 2019
Jay Leno
Durham Performing Arts Center, Durham, NC
December
Jay Leno
http://www.qualityplustickets.com/searchtickets.php?productionID=1573666
Terry Fator Theatre - Mirage Las Vegas
Las Vegas Las Vegas, NV
Dec 28, 10:00 pm 2019
Jay Leno
Terry Fator Theatre - Mirage Las Vegas, Las Vegas, NV
|