LISTE POUR : Sylvan Esso

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

March

Sylvan Esso
The Tabernacle Atlanta Atlanta, GA
Mar 17, 8:00 pm 2018
Saturday
Mar 17
8:00 pm
Sylvan Esso
The Tabernacle, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 32931
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
Sylvan Esso
White Oak Music Hall Houston Houston, TX
Mar 19, 7:00 pm 2018
Monday
Mar 19
7:00 pm
Sylvan Esso
White Oak Music Hall, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 31816
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Sylvan Esso
Bomb Factory Dallas Dallas, TX
Mar 20, 8:00 pm 2018
Tuesday
Mar 20
8:00 pm
Sylvan Esso
Bomb Factory, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 3554
SELECT * from toolcitypagelink WHERE cityname = 'Albuquerque'
Sylvan Esso
Sunshine Theatre Albuquerque Albuquerque, NM
Mar 22, 8:00 pm 2018
Thursday
Mar 22
8:00 pm
Sylvan Esso
Sunshine Theatre, Albuquerque, NM
SELECT * from toolvenuepagelink WHERE venueid = 3000
SELECT * from toolcitypagelink WHERE cityname = 'Tulsa'
Sylvan Esso
Cains Ballroom Tulsa Tulsa, OK
Mar 26, 8:00 pm 2018
Monday
Mar 26
8:00 pm
Sylvan Esso
Cains Ballroom, Tulsa, OK
SELECT * from toolvenuepagelink WHERE venueid = 687
SELECT * from toolcitypagelink WHERE cityname = 'Des Moines'
Sylvan Esso
Hoyt Sherman Auditorium Des Moines Des Moines, IA
Mar 27, 8:00 pm 2018
Tuesday
Mar 27
8:00 pm
Sylvan Esso
Hoyt Sherman Auditorium, Des Moines, IA
SELECT * from toolvenuepagelink WHERE venueid = 33426
SELECT * from toolcitypagelink WHERE cityname = 'Grand Rapids'
Sylvan Esso
20 Monroe Live Grand Rapids Grand Rapids, MI
Mar 29, 8:00 pm 2018
Thursday
Mar 29
8:00 pm
Sylvan Esso
20 Monroe Live, Grand Rapids, MI
SELECT * from toolvenuepagelink WHERE venueid = 4492
SELECT * from toolcitypagelink WHERE cityname = 'Buffalo'
Sylvan Esso
Town Ballroom Buffalo Buffalo, NY
Mar 30, 7:00 pm 2018
Friday
Mar 30
7:00 pm
Sylvan Esso
Town Ballroom, Buffalo, NY
SELECT * from toolvenuepagelink WHERE venueid = 6826
SELECT * from toolcitypagelink WHERE cityname = 'North Adams'
Sylvan Esso
MASS MoCA North Adams North Adams, MA
Mar 31, 8:00 pm 2018
Saturday
Mar 31
8:00 pm
Sylvan Esso
MASS MoCA, North Adams, MA
SELECT * from toolvenuepagelink WHERE venueid = 32217
SELECT * from toolcitypagelink WHERE cityname = 'Portland'

April

Sylvan Esso
State Theatre - Maine Portland Portland, ME
Apr 2, 8:00 pm 2018
Monday
Apr 2
8:00 pm
Sylvan Esso
State Theatre - Maine, Portland, ME
SELECT * from toolvenuepagelink WHERE venueid = 18123
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Sylvan Esso
Corona Theatre Montreal Montreal, QC
Apr 3, 8:00 pm 2018
Tuesday
Apr 3
8:00 pm
Sylvan Esso
Corona Theatre, Montreal, QC
SELECT * from toolvenuepagelink WHERE venueid = 5177
SELECT * from toolcitypagelink WHERE cityname = 'Richmond'
Sylvan Esso
The National Richmond Richmond, VA
Apr 6, 8:00 pm 2018
Friday
Apr 6
8:00 pm
Sylvan Esso
The National, Richmond, VA
SELECT * from toolvenuepagelink WHERE venueid = 33171
SELECT * from toolcitypagelink WHERE cityname = 'Knoxville'
Sylvan Esso
The Mill & Mine Knoxville Knoxville, TN
Apr 7, 9:00 pm 2018
Saturday
Apr 7
9:00 pm
Sylvan Esso
The Mill & Mine, Knoxville, TN
SELECT * from toolvenuepagelink WHERE venueid = 603
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'

July

Sylvan Esso
Greek Theatre - Los Angeles Los Angeles Los Angeles, CA
Jul 10, 8:00 pm 2018
Tuesday
Jul 10
8:00 pm
Sylvan Esso
Greek Theatre - Los Angeles, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 1785
SELECT * from toolcitypagelink WHERE cityname = 'Berkeley'
Sylvan Esso
Greek Theatre - Berkeley Berkeley Berkeley, CA
Jul 12, 7:30 pm 2018
Thursday
Jul 12
7:30 pm
Sylvan Esso
Greek Theatre - Berkeley, Berkeley, CA
SELECT * from toolvenuepagelink WHERE venueid = 4104
SELECT * from toolcitypagelink WHERE cityname = 'Troutdale'
Sylvan Esso
McMenamins Historic Edgefield Manor Troutdale Troutdale, OR
Jul 13, 7:00 pm 2018
Friday
Jul 13
7:00 pm
Sylvan Esso
McMenamins Historic Edgefield Manor, Troutdale, OR
SELECT * from toolvenuepagelink WHERE venueid = 2607
SELECT * from toolcitypagelink WHERE cityname = 'Boise'
Sylvan Esso
Knitting Factory Concert House - Boise Boise Boise, ID
Jul 16, 8:00 pm 2018
Monday
Jul 16
8:00 pm
Sylvan Esso
Knitting Factory Concert House - Boise, Boise, ID
SELECT * from toolvenuepagelink WHERE venueid = 1290
SELECT * from toolcitypagelink WHERE cityname = 'Morrison'
Sylvan Esso
Red Rocks Amphitheatre Morrison Morrison, CO
Jul 18, 8:00 pm 2018
Wednesday
Jul 18
8:00 pm
Sylvan Esso
Red Rocks Amphitheatre, Morrison, CO
SELECT * from toolvenuepagelink WHERE venueid = 1170
SELECT * from toolcitypagelink WHERE cityname = 'Milwaukee'
Sylvan Esso
Pabst Theater Milwaukee Milwaukee, WI
Jul 21, 8:00 pm 2018
Saturday
Jul 21
8:00 pm
Sylvan Esso
Pabst Theater, Milwaukee, WI
SELECT * from toolvenuepagelink WHERE venueid = 1324
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Sylvan Esso
Riviera Theatre (Chicago) Chicago Chicago, IL
Jul 23, 7:30 pm 2018
Monday
Jul 23
7:30 pm
Sylvan Esso
Riviera Theatre (Chicago), Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 33548
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Sylvan Esso
The Anthem Washington Washington, DC
Jul 26, 8:00 pm 2018
Thursday
Jul 26
8:00 pm
Sylvan Esso
The Anthem, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 109
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Sylvan Esso
Blue Hills Bank Pavilion Boston Boston, MA
Jul 28, 7:30 pm 2018
Saturday
Jul 28
7:30 pm
Sylvan Esso
Blue Hills Bank Pavilion, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 1855
SELECT * from toolcitypagelink WHERE cityname = 'Clifton Park'
Sylvan Esso
Upstate Concert Hall Clifton Park Clifton Park, NY
Jul 30, 8:00 pm 2018
Monday
Jul 30
8:00 pm
Sylvan Esso
Upstate Concert Hall, Clifton Park, NY
SELECT * from toolvenuepagelink WHERE venueid = 2992
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Sylvan Esso
Danforth Music Hall Toronto Toronto, ON
Jul 31, 7:00 pm 2018
Tuesday
Jul 31
7:00 pm
Sylvan Esso
Danforth Music Hall, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 2992
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'

August

Sylvan Esso
Danforth Music Hall Toronto Toronto, ON
Aug 1, 7:00 pm 2018
Wednesday
Aug 1
7:00 pm
Sylvan Esso
Danforth Music Hall, Toronto, ON
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football