SELECT tbproductions.*, ttvenues.city,ttvenues.state, CONCAT(ttvenues.city,', ',ttvenues.state) as Region FROM tbproductions,ttvenues , tevoEventPerformers
WHERE tbEventsID = 14232 AND tevoEventPerformers.performerId = 14232 AND tbproductions.tbVenuesID = ttvenues.id AND tbproductions.tbVenuesID = ttvenues.id AND tevoEventPerformers.eventId = tbproductions.ID
ORDER BY tbproductions.Eventdate
March
New York Red Bulls at Columbus Crew
http://www.qualityplustickets.com/searchtickets.php?productionID=1639253
Mapfre Stadium
Columbus Columbus, OH
Mar 2, 4:30 pm 2019
San Jose Earthquakes at New York Red Bulls
http://www.qualityplustickets.com/searchtickets.php?productionID=1638988
Red Bull Arena
Harrison Harrison, NJ
Mar 16, 12:00 am 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
New York Red Bulls at Chicago Fire
http://www.qualityplustickets.com/searchtickets.php?productionID=1654016
SeatGeek Stadium
Bridgeview Bridgeview, IL
Mar 30, 12:00 pm 2019
April
Minnesota United FC at New York Red Bulls
http://www.qualityplustickets.com/searchtickets.php?productionID=1639792
Red Bull Arena
Harrison Harrison, NJ
Apr 6, 7:00 pm 2019
New York Red Bulls at Sporting Kansas City
http://www.qualityplustickets.com/searchtickets.php?productionID=1639747
Children's Mercy Park
Kansas City Kansas City, KS
Apr 14, 6:00 pm 2019
New York Red Bulls at New England Revolution
http://www.qualityplustickets.com/searchtickets.php?productionID=1639557
Gillette Stadium
Foxborough Foxborough, MA
Apr 20, 7:30 pm 2019
FC Cincinnati at New York Red Bulls
http://www.qualityplustickets.com/searchtickets.php?productionID=1639794
Red Bull Arena
Harrison Harrison, NJ
Apr 27, 7:00 pm 2019
May
Los Angeles Galaxy at New York Red Bulls
http://www.qualityplustickets.com/searchtickets.php?productionID=1639634
Red Bull Arena
Harrison Harrison, NJ
May 4, 2:00 pm 2019
Montreal Impact at New York Red Bulls
http://www.qualityplustickets.com/searchtickets.php?productionID=1639793
Red Bull Arena
Harrison Harrison, NJ
May 8, 8:00 pm 2019
New York Red Bulls at FC Dallas
http://www.qualityplustickets.com/searchtickets.php?productionID=1650866
Toyota Stadium
Frisco Frisco, TX
May 11, 1:00 pm 2019
Atlanta United at New York Red Bulls
http://www.qualityplustickets.com/searchtickets.php?productionID=1639796
Red Bull Arena
Harrison Harrison, NJ
May 19, 1:00 pm 2019
Vancouver Whitecaps FC at New York Red Bulls
http://www.qualityplustickets.com/searchtickets.php?productionID=1639809
Red Bull Arena
Harrison Harrison, NJ
May 22, 1:00 pm 2019
New York Red Bulls at FC Cincinnati
http://www.qualityplustickets.com/searchtickets.php?productionID=1639941
Nippert Stadium
Cincinnati Cincinnati, OH
May 25, 7:30 pm 2019
June
Real Salt Lake at New York Red Bulls
http://www.qualityplustickets.com/searchtickets.php?productionID=1639637
Red Bull Arena
Harrison Harrison, NJ
Jun 1, 7:00 pm 2019
New York Red Bulls at Philadelphia Union
http://www.qualityplustickets.com/searchtickets.php?productionID=1645810
Talen Energy Stadium
Chester Chester, PA
Jun 8, 7:30 pm 2019
Chicago Fire at New York Red Bulls
http://www.qualityplustickets.com/searchtickets.php?productionID=1639802
Red Bull Arena
Harrison Harrison, NJ
Jun 28, 8:00 pm 2019
July
New York Red Bulls at Houston Dynamo
http://www.qualityplustickets.com/searchtickets.php?productionID=1642517
BBVA Compass Stadium
Houston Houston, TX
Jul 3, 9:00 pm 2019
New York Red Bulls at Atlanta United FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1639961
Mercedes-Benz Stadium
Atlanta Atlanta, GA
Jul 7, 2:00 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 Red Bulls at Toronto FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1639185
BMO Field (National Soccer Stadium)
Toronto Toronto, ON
Jul 17, 8: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
Columbus Crew at New York Red Bulls
http://www.qualityplustickets.com/searchtickets.php?productionID=1639801
Red Bull Arena
Harrison Harrison, NJ
Jul 27, 8:00 pm 2019
August
Toronto FC at New York Red Bulls
http://www.qualityplustickets.com/searchtickets.php?productionID=1639799
Red Bull Arena
Harrison Harrison, NJ
Aug 3, 7:00 pm 2019
New York Red Bulls at Los Angeles FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1641307
Banc of California Stadium
Los Angeles Los Angeles, CA
Aug 11, 7:00 pm 2019
New England Revolution at New York Red Bulls
http://www.qualityplustickets.com/searchtickets.php?productionID=1639798
Red Bull Arena
Harrison Harrison, NJ
Aug 17, 7:00 pm 2019
New York Red Bulls at DC United
http://www.qualityplustickets.com/searchtickets.php?productionID=1639879
Audi Field
Washington Washington, DC
Aug 21, 8: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
Colorado Rapids at New York Red Bulls
http://www.qualityplustickets.com/searchtickets.php?productionID=1639797
Red Bull Arena
Harrison Harrison, NJ
Aug 31, 7:00 pm 2019
September
New York Red Bulls at Seattle Sounders FC
http://www.qualityplustickets.com/searchtickets.php?productionID=1641161
CenturyLink Field
Seattle Seattle, WA
Sep 15, 12:30 pm 2019
New York Red Bulls at Portland Timbers
http://www.qualityplustickets.com/searchtickets.php?productionID=1644880
Providence Park
Portland Portland, OR
Sep 18, 7:30 pm 2019
Philadelphia Union at New York Red Bulls
http://www.qualityplustickets.com/searchtickets.php?productionID=1639795
Red Bull Arena
Harrison Harrison, NJ
Sep 22, 6:00 pm 2019
D.C. United at New York Red Bulls
http://www.qualityplustickets.com/searchtickets.php?productionID=1639791
Red Bull Arena
Harrison Harrison, NJ
Sep 29, 5:00 pm 2019
October
New York Red Bulls at Montreal Impact
http://www.qualityplustickets.com/searchtickets.php?productionID=1656217
Stade Saputo
Montreal Montreal, QC
Oct 6, 4:00 pm 2019