LISTE POUR : Guster

SELECT tbproductions.*, ttvenues.city,ttvenues.state, CONCAT(ttvenues.city,', ',ttvenues.state) as Region FROM tbproductions,ttvenues , tevoEventPerformers WHERE tbEventsID = 4687 AND tevoEventPerformers.performerId = 4687 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 = 32474
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'

March

Guster
The Fillmore Philadelphia Philadelphia Philadelphia, PA
Mar 23, 8:00 pm 2019
Saturday
Mar 23
8:00 pm
Guster
The Fillmore Philadelphia, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 33783
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
Guster
The Heights Theater Houston Houston, TX
Mar 27, 8:00 pm 2019
Wednesday
Mar 27
8:00 pm
Guster
The Heights Theater, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 8118
SELECT * from toolcitypagelink WHERE cityname = 'Austin'
Guster
Stubbs BBQ Austin Austin, TX
Mar 28, 7:00 pm 2019
Thursday
Mar 28
7:00 pm
Guster
Stubbs BBQ, Austin, TX
SELECT * from toolvenuepagelink WHERE venueid = 4568
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Guster
House of Blues - Dallas Dallas Dallas, TX
Mar 29, 7:00 pm 2019
Friday
Mar 29
7:00 pm
Guster
House of Blues - Dallas, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 1936
SELECT * from toolcitypagelink WHERE cityname = 'New Orleans'
Guster
House of Blues - New Orleans New Orleans New Orleans, LA
Mar 30, 8:00 pm 2019
Saturday
Mar 30
8:00 pm
Guster
House of Blues - New Orleans, New Orleans, LA
SELECT * from toolvenuepagelink WHERE venueid = 216
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'

April

Guster
Cannery Ballroom Nashville Nashville, TN
Apr 4, 8:00 pm 2019
Thursday
Apr 4
8:00 pm
Guster
Cannery Ballroom, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 1555
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Guster
The Tabernacle Atlanta Atlanta, GA
Apr 5, 8:00 pm 2019
Friday
Apr 5
8:00 pm
Guster
The Tabernacle, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 3313
SELECT * from toolcitypagelink WHERE cityname = 'Orlando'
Guster
The Beacham Orlando Orlando, FL
Apr 6, 6:00 pm 2019
Saturday
Apr 6
6:00 pm
Guster
The Beacham, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 3607
SELECT * from toolcitypagelink WHERE cityname = 'Fort Lauderdale'
Guster
Culture Room Fort Lauderdale Fort Lauderdale, FL
Apr 7, 7:30 pm 2019
Sunday
Apr 7
7:30 pm
Guster
Culture Room, Fort Lauderdale, FL
SELECT * from toolvenuepagelink WHERE venueid = 2401
SELECT * from toolcitypagelink WHERE cityname = 'Charlotte'
Guster
Neighborhood Theatre Charlotte Charlotte, NC
Apr 9, 8:00 pm 2019
Tuesday
Apr 9
8:00 pm
Guster
Neighborhood Theatre, Charlotte, NC
SELECT * from toolvenuepagelink WHERE venueid = 3523
SELECT * from toolcitypagelink WHERE cityname = 'Covington'
Guster
Madison Theater Covington Covington, KY
Apr 11, 7:30 pm 2019
Thursday
Apr 11
7:30 pm
Guster
Madison Theater, Covington, KY
SELECT * from toolvenuepagelink WHERE venueid = 720
SELECT * from toolcitypagelink WHERE cityname = 'Grand Rapids'
Guster
Intersection Grand Rapids Grand Rapids, MI
Apr 12, 8:00 pm 2019
Friday
Apr 12
8:00 pm
Guster
Intersection, Grand Rapids, MI
SELECT * from toolvenuepagelink WHERE venueid = 1324
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Guster
Riviera Theatre (Chicago) Chicago Chicago, IL
Apr 13, 8:00 pm 2019
Saturday
Apr 13
8:00 pm
Guster
Riviera Theatre (Chicago), Chicago, IL
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football