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 = 1855
SELECT * from toolcitypagelink WHERE cityname = 'Clifton Park'

January

Guster
Upstate Concert Hall Clifton Park Clifton Park, NY
Jan 16, 8:00 pm 2019
Wednesday
Jan 16
8:00 pm
Guster
Upstate Concert Hall, Clifton Park, NY
SELECT * from toolvenuepagelink WHERE venueid = 32474
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
Guster
The Fillmore Philadelphia Philadelphia Philadelphia, PA
Jan 17, 8:00 pm 2019
Thursday
Jan 17
8:00 pm
Guster
The Fillmore Philadelphia, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 6064
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Guster
House of Blues - Boston Boston Boston, MA
Jan 19, 7:00 pm 2019
Saturday
Jan 19
7:00 pm
Guster
House of Blues - Boston, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 3142
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Guster with Henry Jamison
Mod Club Theatre Toronto Toronto, ON
Jan 22, 7:00 pm 2019
Tuesday
Jan 22
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 32097
SELECT * from toolcitypagelink WHERE cityname = 'Rochester'
Guster
Anthology - NY Rochester Rochester, NY
Jan 23, 8:00 pm 2019
Wednesday
Jan 23
8:00 pm
Guster
Anthology - NY, Rochester, NY
SELECT * from toolvenuepagelink WHERE venueid = 1959
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Guster
9:30 Club Washington Washington, DC
Jan 25, 8:00 pm 2019
Friday
Jan 25
8:00 pm
Guster
9:30 Club, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 1959
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Guster
9:30 Club Washington Washington, DC
Jan 26, 8:00 pm 2019
Saturday
Jan 26
8:00 pm
Guster
9:30 Club, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 2082
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Guster
Bimbos 365 Club San Francisco San Francisco, CA
Jan 30, 8:00 pm 2019
Wednesday
Jan 30
8:00 pm
Guster
Bimbos 365 Club, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 2082
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Guster
Bimbos 365 Club San Francisco San Francisco, CA
Jan 31, 8:00 pm 2019
Thursday
Jan 31
8:00 pm
Guster
Bimbos 365 Club, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 2082
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'

February

Guster
Bimbos 365 Club San Francisco San Francisco, CA
Feb 1, 8:00 pm 2019
Friday
Feb 1
8:00 pm
Guster
Bimbos 365 Club, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 546
SELECT * from toolcitypagelink WHERE cityname = 'Santa Ana'
Guster
The Observatory Santa Ana Santa Ana, CA
Feb 2, 8:00 pm 2019
Saturday
Feb 2
8:00 pm
Guster
The Observatory, Santa Ana, CA
SELECT * from toolvenuepagelink WHERE venueid = 3946
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
Guster
The Depot Salt Lake City Salt Lake City, UT
Feb 4, 7:00 pm 2019
Monday
Feb 4
7:00 pm
Guster
The Depot, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 1131
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Guster
Ogden Theatre Denver Denver, CO
Feb 7, 8:00 pm 2019
Thursday
Feb 7
8:00 pm
Guster
Ogden Theatre, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 4608
SELECT * from toolcitypagelink WHERE cityname = 'Omaha'
Guster
Holland Performing Arts Center Omaha Omaha, NE
Feb 8, 7:30 pm 2019
Friday
Feb 8
7:30 pm
Guster
Holland Performing Arts Center, Omaha, NE
SELECT * from toolvenuepagelink WHERE venueid = 496
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
Guster
First Avenue Minneapolis Minneapolis, MN
Feb 9, 9:00 pm 2019
Saturday
Feb 9
9:00 pm
Guster
First Avenue, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 30076
SELECT * from toolcitypagelink WHERE cityname = 'Missoula'
Guster with Henry Jamison
Top Hat Lounge & Casino Missoula Missoula, MT
Feb 11, 9:00 pm 2019
Monday
Feb 11
9:00 pm
Guster with Henry Jamison
Top Hat Lounge & Casino, Missoula, MT
SELECT * from toolvenuepagelink WHERE venueid = 4059
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Guster
Wonder Ballroom Portland Portland, OR
Feb 14, 8:30 pm 2019
Thursday
Feb 14
8:30 pm
Guster
Wonder Ballroom, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 31647
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Guster with Henry Jamison
Imperial (Vancouver) Vancouver Vancouver, BC
Feb 15, 9:00 pm 2019
Friday
Feb 15
9:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 1419
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Guster
The Showbox Seattle Seattle, WA
Feb 16, 8:00 pm 2019
Saturday
Feb 16
8:00 pm
Guster
The Showbox, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 1503
SELECT * from toolcitypagelink WHERE cityname = 'Providence'

March

Guster
Strand Theatre Providence Providence, RI
Mar 14, 9:00 pm 2019
Thursday
Mar 14
9:00 pm
Guster
Strand Theatre, Providence, RI
SELECT * from toolvenuepagelink WHERE venueid = 8545
SELECT * from toolcitypagelink WHERE cityname = 'Portsmouth'
Guster with Saintseneca
Portsmouth Music Hall Portsmouth Portsmouth, NH
Mar 15, 7:00 pm 2019
Friday
Mar 15
7:00 pm
Guster with Saintseneca
Portsmouth Music Hall, Portsmouth, NH
SELECT * from toolvenuepagelink WHERE venueid = 123
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Guster
Beacon Theatre New York New York, NY
Mar 16, 8:00 pm 2019
Saturday
Mar 16
8:00 pm
Guster
Beacon Theatre, New York, NY
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