LISTE POUR : Phish

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 tevoEventPerformers.isPrimary = 1 AND tbproductions.tbVenuesID = ttvenues.id AND tbproductions.tbVenuesID = ttvenues.id AND tevoEventPerformers.eventId = tbproductions.ID ORDER BY tbproductions.Eventdate
DATES
ÉVÉNEMENT
SELECT * from toolvenuepagelink WHERE venueid = 5263
SELECT * from toolcitypagelink WHERE cityname = 'St Louis'

June

Phish
Chaifetz Arena St Louis St Louis, MO
Jun 11, 7:30 pm 2019
Tuesday
Jun 11
7:30 pm
Phish
Chaifetz Arena, St Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 5263
SELECT * from toolcitypagelink WHERE cityname = 'St Louis'
Phish
Chaifetz Arena St Louis St Louis, MO
Jun 12, 7:30 pm 2019
Wednesday
Jun 12
7:30 pm
Phish
Chaifetz Arena, St Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 1035
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Phish
Budweiser Stage Toronto Toronto, ON
Jun 18, 7:00 pm 2019
Tuesday
Jun 18
7:00 pm
Phish
Budweiser Stage, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 156
SELECT * from toolcitypagelink WHERE cityname = 'Cuyahoga Falls'
Phish
Blossom Music Center Cuyahoga Falls Cuyahoga Falls, OH
Jun 19, 7:00 pm 2019
Wednesday
Jun 19
7:00 pm
Phish
Blossom Music Center, Cuyahoga Falls, OH
SELECT * from toolvenuepagelink WHERE venueid = 1953
SELECT * from toolcitypagelink WHERE cityname = 'Charlotte'
Phish
PNC Music Pavilion - Charlotte Charlotte Charlotte, NC
Jun 21, 7:00 pm 2019
Friday
Jun 21
7:00 pm
Phish
PNC Music Pavilion - Charlotte, Charlotte, NC
SELECT * from toolvenuepagelink WHERE venueid = 984
SELECT * from toolcitypagelink WHERE cityname = 'Columbia'
Phish - 2 day pass
Merriweather Post Pavilion Columbia Columbia, MD
Jun 22, 6:59 pm 2019
Saturday
Jun 22
6:59 pm
Phish - 2 day pass
Merriweather Post Pavilion, Columbia, MD
SELECT * from toolvenuepagelink WHERE venueid = 984
SELECT * from toolcitypagelink WHERE cityname = 'Columbia'
Phish
Merriweather Post Pavilion Columbia Columbia, MD
Jun 22, 7:00 pm 2019
Saturday
Jun 22
7:00 pm
Phish
Merriweather Post Pavilion, Columbia, MD
SELECT * from toolvenuepagelink WHERE venueid = 984
SELECT * from toolcitypagelink WHERE cityname = 'Columbia'
Phish
Merriweather Post Pavilion Columbia Columbia, MD
Jun 23, 7:00 pm 2019
Sunday
Jun 23
7:00 pm
Phish
Merriweather Post Pavilion, Columbia, MD
SELECT * from toolvenuepagelink WHERE venueid = 7425
SELECT * from toolcitypagelink WHERE cityname = 'Bangor'
Phish
Darling's Waterfront Pavilion Bangor Bangor, ME
Jun 25, 6:30 pm 2019
Tuesday
Jun 25
6:30 pm
Phish
Darling's Waterfront Pavilion, Bangor, ME
SELECT * from toolvenuepagelink WHERE venueid = 7425
SELECT * from toolcitypagelink WHERE cityname = 'Bangor'
Phish
Darling's Waterfront Pavilion Bangor Bangor, ME
Jun 26, 6:30 pm 2019
Wednesday
Jun 26
6:30 pm
Phish
Darling's Waterfront Pavilion, Bangor, ME
SELECT * from toolvenuepagelink WHERE venueid = 155
SELECT * from toolcitypagelink WHERE cityname = 'Camden'
Phish - 3 Day Pass
BB&T Pavilion Camden Camden, NJ
Jun 28, 7:29 pm 2019
Friday
Jun 28
7:29 pm
Phish - 3 Day Pass
BB&T Pavilion, Camden, NJ
SELECT * from toolvenuepagelink WHERE venueid = 155
SELECT * from toolcitypagelink WHERE cityname = 'Camden'
Phish
BB&T Pavilion Camden Camden, NJ
Jun 28, 7:30 pm 2019
Friday
Jun 28
7:30 pm
Phish
BB&T Pavilion, Camden, NJ
SELECT * from toolvenuepagelink WHERE venueid = 155
SELECT * from toolcitypagelink WHERE cityname = 'Camden'
Phish
BB&T Pavilion Camden Camden, NJ
Jun 29, 7:30 pm 2019
Saturday
Jun 29
7:30 pm
Phish
BB&T Pavilion, Camden, NJ
SELECT * from toolvenuepagelink WHERE venueid = 155
SELECT * from toolcitypagelink WHERE cityname = 'Camden'
Phish
BB&T Pavilion Camden Camden, NJ
Jun 30, 7:30 pm 2019
Sunday
Jun 30
7:30 pm
Phish
BB&T Pavilion, Camden, NJ
SELECT * from toolvenuepagelink WHERE venueid = 1390
SELECT * from toolcitypagelink WHERE cityname = 'Saratoga Springs'

July

Phish - 2 Day Pass
Saratoga Performing Arts Center Saratoga Springs Saratoga Springs, NY
Jul 2, 7:29 pm 2019
Tuesday
Jul 2
7:29 pm
Phish - 2 Day Pass
Saratoga Performing Arts Center, Saratoga Springs, NY
SELECT * from toolvenuepagelink WHERE venueid = 1390
SELECT * from toolcitypagelink WHERE cityname = 'Saratoga Springs'
Phish
Saratoga Performing Arts Center Saratoga Springs Saratoga Springs, NY
Jul 2, 7:30 pm 2019
Tuesday
Jul 2
7:30 pm
Phish
Saratoga Performing Arts Center, Saratoga Springs, NY
SELECT * from toolvenuepagelink WHERE venueid = 1390
SELECT * from toolcitypagelink WHERE cityname = 'Saratoga Springs'
Phish
Saratoga Performing Arts Center Saratoga Springs Saratoga Springs, NY
Jul 3, 7:30 pm 2019
Wednesday
Jul 3
7:30 pm
Phish
Saratoga Performing Arts Center, Saratoga Springs, NY
SELECT * from toolvenuepagelink WHERE venueid = 488
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Phish
Fenway Park Boston Boston, MA
Jul 5, 6:30 pm 2019
Friday
Jul 5
6:30 pm
Phish
Fenway Park, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 488
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Phish
Fenway Park Boston Boston, MA
Jul 6, 6:30 pm 2019
Saturday
Jul 6
6:30 pm
Phish
Fenway Park, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 2061
SELECT * from toolcitypagelink WHERE cityname = 'Uncasville'
Phish
Mohegan Sun Arena Uncasville Uncasville, CT
Jul 9, 7:30 pm 2019
Tuesday
Jul 9
7:30 pm
Phish
Mohegan Sun Arena, Uncasville, CT
SELECT * from toolvenuepagelink WHERE venueid = 2061
SELECT * from toolcitypagelink WHERE cityname = 'Uncasville'
Phish
Mohegan Sun Arena Uncasville Uncasville, CT
Jul 10, 7:30 pm 2019
Wednesday
Jul 10
7:30 pm
Phish
Mohegan Sun Arena, Uncasville, CT
SELECT * from toolvenuepagelink WHERE venueid = 39
SELECT * from toolcitypagelink WHERE cityname = 'East Troy'
Phish
Alpine Valley Music Theatre East Troy East Troy, WI
Jul 12, 7:00 pm 2019
Friday
Jul 12
7:00 pm
Phish
Alpine Valley Music Theatre, East Troy, WI
SELECT * from toolvenuepagelink WHERE venueid = 39
SELECT * from toolcitypagelink WHERE cityname = 'East Troy'
Phish - 3 Day Pass
Alpine Valley Music Theatre East Troy East Troy, WI
Jul 12, 7:00 pm 2019
Friday
Jul 12
7:00 pm
Phish - 3 Day Pass
Alpine Valley Music Theatre, East Troy, WI
SELECT * from toolvenuepagelink WHERE venueid = 39
SELECT * from toolcitypagelink WHERE cityname = 'East Troy'
Phish
Alpine Valley Music Theatre East Troy East Troy, WI
Jul 13, 7:00 pm 2019
Saturday
Jul 13
7:00 pm
Phish
Alpine Valley Music Theatre, East Troy, WI
SELECT * from toolvenuepagelink WHERE venueid = 39
SELECT * from toolcitypagelink WHERE cityname = 'East Troy'
Phish
Alpine Valley Music Theatre East Troy East Troy, WI
Jul 14, 7:00 pm 2019
Sunday
Jul 14
7:00 pm
Phish
Alpine Valley Music Theatre, East Troy, WI
SELECT * from toolvenuepagelink WHERE venueid = 4537
SELECT * from toolcitypagelink WHERE cityname = 'Commerce City'

August

Phish - 3 Day Pass
Dick's Sporting Goods Park Commerce City Commerce City, CO
Aug 30, 7:29 pm 2019
Friday
Aug 30
7:29 pm
Phish - 3 Day Pass
Dick's Sporting Goods Park, Commerce City, CO
SELECT * from toolvenuepagelink WHERE venueid = 4537
SELECT * from toolcitypagelink WHERE cityname = 'Commerce City'
Phish
Dick's Sporting Goods Park Commerce City Commerce City, CO
Aug 30, 7:30 pm 2019
Friday
Aug 30
7:30 pm
Phish
Dick's Sporting Goods Park, Commerce City, CO
SELECT * from toolvenuepagelink WHERE venueid = 4537
SELECT * from toolcitypagelink WHERE cityname = 'Commerce City'
Phish
Dick's Sporting Goods Park Commerce City Commerce City, CO
Aug 31, 7:30 pm 2019
Saturday
Aug 31
7:30 pm
Phish
Dick's Sporting Goods Park, Commerce City, CO
SELECT * from toolvenuepagelink WHERE venueid = 4537
SELECT * from toolcitypagelink WHERE cityname = 'Commerce City'

September

Phish
Dick's Sporting Goods Park Commerce City Commerce City, CO
Sep 1, 7:30 pm 2019
Sunday
Sep 1
7:30 pm
Phish
Dick's Sporting Goods Park, Commerce City, CO
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football