SELECT tbproductions.*, ttvenues.city,ttvenues.state, CONCAT(ttvenues.city,', ',ttvenues.state) as Region FROM tbproductions,ttvenues , tevoEventPerformers
WHERE tbEventsID = 8859 AND tevoEventPerformers.performerId = 8859 AND tbproductions.tbVenuesID = ttvenues.id AND tbproductions.tbVenuesID = ttvenues.id AND tevoEventPerformers.eventId = tbproductions.ID
ORDER BY tbproductions.Eventdate
June
Phish
http://www.qualityplustickets.com/searchtickets.php?productionID=1641012
Chaifetz Arena
St Louis St Louis, MO
Jun 11, 7:30 pm 2019
Phish
Chaifetz Arena, St Louis, MO
Phish
http://www.qualityplustickets.com/searchtickets.php?productionID=1641013
Chaifetz Arena
St Louis St Louis, MO
Jun 12, 7:30 pm 2019
Phish
Chaifetz Arena, St Louis, MO
Phish
http://www.qualityplustickets.com/searchtickets.php?productionID=1641025
Budweiser Stage
Toronto Toronto, ON
Jun 18, 7:00 pm 2019
Phish
http://www.qualityplustickets.com/searchtickets.php?productionID=1641011
Blossom Music Center
Cuyahoga Falls Cuyahoga Falls, OH
Jun 19, 7:00 pm 2019
Phish
Blossom Music Center, Cuyahoga Falls, OH
Phish
http://www.qualityplustickets.com/searchtickets.php?productionID=1641022
PNC Music Pavilion - Charlotte
Charlotte Charlotte, NC
Jun 21, 7:00 pm 2019
Phish
PNC Music Pavilion - Charlotte, Charlotte, NC
Phish - 2 day pass
http://www.qualityplustickets.com/searchtickets.php?productionID=1651430
Merriweather Post Pavilion
Columbia Columbia, MD
Jun 22, 6:59 pm 2019
Phish
http://www.qualityplustickets.com/searchtickets.php?productionID=1641016
Merriweather Post Pavilion
Columbia Columbia, MD
Jun 22, 7:00 pm 2019
Phish
Merriweather Post Pavilion, Columbia, MD
Phish
http://www.qualityplustickets.com/searchtickets.php?productionID=1641017
Merriweather Post Pavilion
Columbia Columbia, MD
Jun 23, 7:00 pm 2019
Phish
Merriweather Post Pavilion, Columbia, MD
Phish
http://www.qualityplustickets.com/searchtickets.php?productionID=1641024
Darling's Waterfront Pavilion
Bangor Bangor, ME
Jun 25, 6:30 pm 2019
Phish
Darling's Waterfront Pavilion, Bangor, ME
Phish
http://www.qualityplustickets.com/searchtickets.php?productionID=1641023
Darling's Waterfront Pavilion
Bangor Bangor, ME
Jun 26, 6:30 pm 2019
Phish
Darling's Waterfront Pavilion, Bangor, ME
Phish - 3 Day Pass
http://www.qualityplustickets.com/searchtickets.php?productionID=1650138
BB&T Pavilion
Camden Camden, NJ
Jun 28, 7:29 pm 2019
Phish
http://www.qualityplustickets.com/searchtickets.php?productionID=1641005
BB&T Pavilion
Camden Camden, NJ
Jun 28, 7:30 pm 2019
Phish
BB&T Pavilion, Camden, NJ
Phish
http://www.qualityplustickets.com/searchtickets.php?productionID=1641009
BB&T Pavilion
Camden Camden, NJ
Jun 29, 7:30 pm 2019
Phish
BB&T Pavilion, Camden, NJ
Phish
http://www.qualityplustickets.com/searchtickets.php?productionID=1641010
BB&T Pavilion
Camden Camden, NJ
Jun 30, 7:30 pm 2019
Phish
BB&T Pavilion, Camden, NJ
July
Phish - 2 Day Pass
http://www.qualityplustickets.com/searchtickets.php?productionID=1650139
Saratoga Performing Arts Center
Saratoga Springs Saratoga Springs, NY
Jul 2, 7:29 pm 2019
Phish
http://www.qualityplustickets.com/searchtickets.php?productionID=1641021
Saratoga Performing Arts Center
Saratoga Springs Saratoga Springs, NY
Jul 2, 7:30 pm 2019
Phish
Saratoga Performing Arts Center, Saratoga Springs, NY
Phish
http://www.qualityplustickets.com/searchtickets.php?productionID=1641020
Saratoga Performing Arts Center
Saratoga Springs Saratoga Springs, NY
Jul 3, 7:30 pm 2019
Phish
Saratoga Performing Arts Center, Saratoga Springs, NY
Phish
http://www.qualityplustickets.com/searchtickets.php?productionID=1641014
Fenway Park
Boston Boston, MA
Jul 5, 6:30 pm 2019
Phish
Fenway Park, Boston, MA
Phish
http://www.qualityplustickets.com/searchtickets.php?productionID=1641015
Fenway Park
Boston Boston, MA
Jul 6, 6:30 pm 2019
Phish
Fenway Park, Boston, MA
Phish
http://www.qualityplustickets.com/searchtickets.php?productionID=1641018
Mohegan Sun Arena
Uncasville Uncasville, CT
Jul 9, 7:30 pm 2019
Phish
Mohegan Sun Arena, Uncasville, CT
Phish
http://www.qualityplustickets.com/searchtickets.php?productionID=1641019
Mohegan Sun Arena
Uncasville Uncasville, CT
Jul 10, 7:30 pm 2019
Phish
Mohegan Sun Arena, Uncasville, CT
Phish
http://www.qualityplustickets.com/searchtickets.php?productionID=1641008
Alpine Valley Music Theatre
East Troy East Troy, WI
Jul 12, 7:00 pm 2019
Phish
Alpine Valley Music Theatre, East Troy, WI
Phish - 3 Day Pass
http://www.qualityplustickets.com/searchtickets.php?productionID=1650414
Alpine Valley Music Theatre
East Troy East Troy, WI
Jul 12, 7:00 pm 2019
Phish
http://www.qualityplustickets.com/searchtickets.php?productionID=1641007
Alpine Valley Music Theatre
East Troy East Troy, WI
Jul 13, 7:00 pm 2019
Phish
Alpine Valley Music Theatre, East Troy, WI
Phish
http://www.qualityplustickets.com/searchtickets.php?productionID=1641006
Alpine Valley Music Theatre
East Troy East Troy, WI
Jul 14, 7:00 pm 2019
Phish
Alpine Valley Music Theatre, East Troy, WI
August
Phish - 3 Day Pass
http://www.qualityplustickets.com/searchtickets.php?productionID=1641180
Dick's Sporting Goods Park
Commerce City Commerce City, CO
Aug 30, 7:29 pm 2019
Phish
http://www.qualityplustickets.com/searchtickets.php?productionID=1641177
Dick's Sporting Goods Park
Commerce City Commerce City, CO
Aug 30, 7:30 pm 2019
Phish
Dick's Sporting Goods Park, Commerce City, CO
Phish
http://www.qualityplustickets.com/searchtickets.php?productionID=1641178
Dick's Sporting Goods Park
Commerce City Commerce City, CO
Aug 31, 7:30 pm 2019
Phish
Dick's Sporting Goods Park, Commerce City, CO
September
Phish
http://www.qualityplustickets.com/searchtickets.php?productionID=1641179
Dick's Sporting Goods Park
Commerce City Commerce City, CO
Sep 1, 7:30 pm 2019
Phish
Dick's Sporting Goods Park, Commerce City, CO
|