SELECT tbproductions.*, ttvenues.city,ttvenues.state, CONCAT(ttvenues.city,', ',ttvenues.state) as Region FROM tbproductions,ttvenues , tevoEventPerformers
WHERE tbEventsID = 31136 AND tevoEventPerformers.performerId = 31136 AND tbproductions.tbVenuesID = ttvenues.id AND tbproductions.tbVenuesID = ttvenues.id AND tevoEventPerformers.eventId = tbproductions.ID
ORDER BY tbproductions.Eventdate
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
Orlando City SC at Chicago Fire
http://www.qualityplustickets.com/searchtickets.php?productionID=1654017
SeatGeek Stadium
Bridgeview Bridgeview, IL
Mar 9, 12:00 pm 2019
Montreal Impact at Orlando City SC
http://www.qualityplustickets.com/searchtickets.php?productionID=1643487
Orlando City Stadium
Orlando Orlando, FL
Mar 16, 4:00 pm 2019
Orlando City SC at New York Red Bulls
http://www.qualityplustickets.com/searchtickets.php?productionID=1639803
Red Bull Arena
Harrison Harrison, NJ
Mar 23, 7:00 pm 2019
Orlando City SC at D.C. United
http://www.qualityplustickets.com/searchtickets.php?productionID=1639591
Orlando City Stadium
Orlando Orlando, FL
Mar 31, 6:30 pm 2019
April
Orlando City SC at Colorado Rapids
http://www.qualityplustickets.com/searchtickets.php?productionID=1639590
Orlando City Stadium
Orlando Orlando, FL
Apr 6, 7:30 pm 2019
Orlando City SC at Real Salt Lake
http://www.qualityplustickets.com/searchtickets.php?productionID=1639987
Rio Tinto Stadium
Sandy Sandy, UT
Apr 13, 7:00 pm 2019
Orlando City SC at Vancouver Whitecaps FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1639593
Orlando City Stadium
Orlando Orlando, FL
Apr 20, 3: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
Orlando City SC at Toronto FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1639592
Orlando City Stadium
Orlando Orlando, FL
May 4, 4:00 pm 2019
Orlando City SC at Atlanta United FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1639966
Mercedes-Benz Stadium
Atlanta Atlanta, GA
May 12, 2:00 pm 2019
Orlando City SC at Seattle Sounders FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1641154
CenturyLink Field
Seattle Seattle, WA
May 15, 7:30 pm 2019
FC Cincinnati at Orlando City SC
http://www.qualityplustickets.com/searchtickets.php?productionID=1641123
Orlando City Stadium
Orlando Orlando, FL
May 19, 4:00 pm 2019
Orlando City SC at Los Angeles Galaxy
http://www.qualityplustickets.com/searchtickets.php?productionID=1639633
Orlando City Stadium
Orlando Orlando, FL
May 24, 8:00 pm 2019
June
Orlando City SC at Montreal Impact
http://www.qualityplustickets.com/searchtickets.php?productionID=1656207
Stade Saputo
Montreal Montreal, QC
Jun 1, 4:00 pm 2019
Orlando City SC at DC United
http://www.qualityplustickets.com/searchtickets.php?productionID=1639874
Audi Field
Washington Washington, DC
Jun 26, 8:00 pm 2019
Orlando City SC at Columbus Crew
http://www.qualityplustickets.com/searchtickets.php?productionID=1640898
Mapfre Stadium
Columbus Columbus, OH
Jun 29, 6:30 pm 2019
July
Philadelphia Union at Orlando City SC
http://www.qualityplustickets.com/searchtickets.php?productionID=1639774
Orlando City Stadium
Orlando Orlando, FL
Jul 3, 7:30 pm 2019
Orlando City SC at Philadelphia Union
http://www.qualityplustickets.com/searchtickets.php?productionID=1652880
Talen Energy Stadium
Chester Chester, PA
Jul 6, 7:00 pm 2019
Columbus Crew at Orlando City SC
http://www.qualityplustickets.com/searchtickets.php?productionID=1639812
Orlando City Stadium
Orlando Orlando, FL
Jul 13, 7:30 pm 2019
Orlando City SC at Portland Timbers
http://www.qualityplustickets.com/searchtickets.php?productionID=1644882
Providence Park
Portland Portland, OR
Jul 18, 7:00 pm 2019
Orlando City SC at New York Red Bulls
http://www.qualityplustickets.com/searchtickets.php?productionID=1639800
Orlando City Stadium
Orlando Orlando, FL
Jul 21, 7:30 pm 2019
Orlando City SC at New England Revolution
http://www.qualityplustickets.com/searchtickets.php?productionID=1639565
Gillette Stadium
Foxborough Foxborough, MA
Jul 27, 8:00 pm 2019
August
FC Dallas at Orlando City SC
http://www.qualityplustickets.com/searchtickets.php?productionID=1639811
Orlando City Stadium
Orlando Orlando, FL
Aug 3, 7:30 pm 2019
Orlando City SC at Toronto FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1639192
BMO Field (National Soccer Stadium)
Toronto Toronto, ON
Aug 10, 7:30 pm 2019
Sporting Kansas City at Orlando City SC
http://www.qualityplustickets.com/searchtickets.php?productionID=1639813
Orlando City Stadium
Orlando Orlando, FL
Aug 14, 7:30 pm 2019
Orlando City SC at Minnesota United FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1651034
Allianz Field
Saint Paul Saint Paul, MN
Aug 17, 7:00 pm 2019
Atlanta United at Orlando City SC
http://www.qualityplustickets.com/searchtickets.php?productionID=1639810
Orlando City Stadium
Orlando Orlando, FL
Aug 23, 8:00 pm 2019
Orlando City SC at San Jose Earthquakes
http://www.qualityplustickets.com/searchtickets.php?productionID=1639640
Avaya Stadium
San Jose San Jose, CA
Aug 31, 7:15 pm 2019
September
Los Angeles Club at Orlando City SC
http://www.qualityplustickets.com/searchtickets.php?productionID=1641124
Orlando City Stadium
Orlando Orlando, FL
Sep 7, 7:30 pm 2019
New England Revolution at Orlando City SC
http://www.qualityplustickets.com/searchtickets.php?productionID=1639805
Orlando City Stadium
Orlando Orlando, FL
Sep 14, 7:30 pm 2019
Orlando City SC at Houston Dynamo
http://www.qualityplustickets.com/searchtickets.php?productionID=1642523
BBVA Compass Stadium
Houston Houston, TX
Sep 21, 7:30 pm 2019
Orlando City SC at FC Cincinnati
http://www.qualityplustickets.com/searchtickets.php?productionID=1639977
Nippert Stadium
Cincinnati Cincinnati, OH
Sep 29, 5:00 pm 2019
October
Chicago Fire at Orlando City SC
http://www.qualityplustickets.com/searchtickets.php?productionID=1639815
Orlando City Stadium
Orlando Orlando, FL
Oct 6, 4:00 pm 2019