SELECT tbproductions.*, ttvenues.city,ttvenues.state, CONCAT(ttvenues.city,', ',ttvenues.state) as Region FROM tbproductions,ttvenues , tevoEventPerformers
WHERE tbEventsID = 45324 AND tevoEventPerformers.performerId = 45324 AND tbproductions.tbVenuesID = ttvenues.id AND tbproductions.tbVenuesID = ttvenues.id AND tevoEventPerformers.eventId = tbproductions.ID
ORDER BY tbproductions.Eventdate
February
New York City FC at Nashville SC
http://www.qualityplustickets.com/searchtickets.php?productionID=1642786
First Tennessee Park
Nashville Nashville, TN
Feb 22, 7:00 pm 2019
March
New York City FC at Orlando City SC
http://www.qualityplustickets.com/searchtickets.php?productionID=1639589
Orlando City Stadium
Orlando Orlando, FL
Mar 2, 2:30 pm 2019
D.C. United at New York City FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1639620
Yankee Stadium
Bronx Bronx, NY
Mar 10, 3:00 pm 2019
Los Angeles Club at New York City FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1642784
Yankee Stadium
Bronx Bronx, NY
Mar 17, 3:00 pm 2019
New York City FC at Toronto FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1639179
BMO Field (National Soccer Stadium)
Toronto Toronto, ON
Mar 29, 8:00 pm 2019
April
Montreal Impact at New York City FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1640320
Yankee Stadium
Bronx Bronx, NY
Apr 6, 1:00 pm 2019
New York City FC at Minnesota United FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1651040
Allianz Field
Saint Paul Saint Paul, MN
Apr 13, 4:00 pm 2019
New York City FC at DC United
http://www.qualityplustickets.com/searchtickets.php?productionID=1639880
Audi Field
Washington Washington, DC
Apr 21, 4:00 pm 2019
Chicago Fire at New York City FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1640318
Yankee Stadium
Bronx Bronx, NY
Apr 24, 7:00 pm 2019
Orlando City SC at New York City FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1640329
Yankee Stadium
Bronx Bronx, NY
Apr 27, 1:00 pm 2019
May
New York City FC at Montreal Impact
http://www.qualityplustickets.com/searchtickets.php?productionID=1656204
Stade Saputo
Montreal Montreal, QC
May 4, 5:00 pm 2019
New York City FC at Los Angeles Galaxy
http://www.qualityplustickets.com/searchtickets.php?productionID=1639610
Dignity Health Sports Park
Carson Carson, CA
May 11, 1:00 pm 2019
New York City FC at Chicago Fire
http://www.qualityplustickets.com/searchtickets.php?productionID=1654015
SeatGeek Stadium
Bridgeview Bridgeview, IL
May 25, 2:30 pm 2019
New York City FC at Chicago Fire
http://www.qualityplustickets.com/searchtickets.php?productionID=1655952
SeatGeek Stadium
Bridgeview Bridgeview, IL
May 25, 2:30 pm 2019
June
New York City FC at Columbus Crew
http://www.qualityplustickets.com/searchtickets.php?productionID=1640900
Mapfre Stadium
Columbus Columbus, OH
Jun 1, 6:30 pm 2019
FC Cincinnati at New York City FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1640319
Yankee Stadium
Bronx Bronx, NY
Jun 6, 7:00 pm 2019
Philadelphia Union at New York City FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1640321
Yankee Stadium
Bronx Bronx, NY
Jun 29, 7:00 pm 2019
July
Seattle Sounders FC at New York City FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1640327
Yankee Stadium
Bronx Bronx, NY
Jul 3, 7:00 pm 2019
Portland Timbers at New York City FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1640328
Yankee Stadium
Bronx Bronx, NY
Jul 7, 6:30 pm 2019
New York City FC at New York Red Bulls
http://www.qualityplustickets.com/searchtickets.php?productionID=1639790
Red Bull Arena
Harrison Harrison, NJ
Jul 14, 6:30 pm 2019
New York City FC at Colorado Rapids
http://www.qualityplustickets.com/searchtickets.php?productionID=1641061
Dick's Sporting Goods Park
Commerce City Commerce City, CO
Jul 20, 9:00 pm 2019
Sporting Kansas City at New York City FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1640326
Yankee Stadium
Bronx Bronx, NY
Jul 26, 7:30 pm 2019
August
New York City FC at Real Salt Lake
http://www.qualityplustickets.com/searchtickets.php?productionID=1639988
Rio Tinto Stadium
Sandy Sandy, UT
Aug 3, 8:00 pm 2019
Houston Dynamo at New York City FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1642803
Yankee Stadium
Bronx Bronx, NY
Aug 8, 7:00 pm 2019
New York City FC at Atlanta United FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1639965
Mercedes-Benz Stadium
Atlanta Atlanta, GA
Aug 11, 4:00 pm 2019
New York City FC at FC Cincinnati
http://www.qualityplustickets.com/searchtickets.php?productionID=1639938
Nippert Stadium
Cincinnati Cincinnati, OH
Aug 17, 7:30 pm 2019
Columbus Crew at New York City FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1642805
Yankee Stadium
Bronx Bronx, NY
Aug 21, 7:00 pm 2019
New York Red Bulls at New York City FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1640324
Yankee Stadium
Bronx Bronx, NY
Aug 24, 7:00 pm 2019
New York City FC at Vancouver Whitecaps FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1639148
Aug 31, 7:00 pm 2019
September
New England Revolution at New York City FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1640325
Yankee Stadium
Bronx Bronx, NY
Sep 7, 3:30 pm 2019
Toronto FC at New York City FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1640322
Yankee Stadium
Bronx Bronx, NY
Sep 11, 7:00 pm 2019
San Jose Earthquakes at New York City FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1640323
Yankee Stadium
Bronx Bronx, NY
Sep 14, 7:00 pm 2019
New York City FC at FC Dallas
http://www.qualityplustickets.com/searchtickets.php?productionID=1650861
Toyota Stadium
Frisco Frisco, TX
Sep 22, 12:00 am 2019
Atlanta United FC at New York City FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1642804
Yankee Stadium
Bronx Bronx, NY
Sep 25, 7:00 pm 2019
New York City FC at New England Revolution
http://www.qualityplustickets.com/searchtickets.php?productionID=1639556
Gillette Stadium
Foxborough Foxborough, MA
Sep 29, 5:00 pm 2019
October
New York City FC at Philadelphia Union
http://www.qualityplustickets.com/searchtickets.php?productionID=1644031
Talen Energy Stadium
Chester Chester, PA
Oct 6, 4:00 pm 2019