LISTE POUR : Eden

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

March

Eden
White Oak Music Hall Houston Houston, TX
Mar 1, 7:00 pm 2018
Thursday
Mar 1
7:00 pm
Eden
White Oak Music Hall, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 26602
SELECT * from toolcitypagelink WHERE cityname = 'Austin'
Eden
Scoot Inn Austin Austin, TX
Mar 2, 8:00 pm 2018
Friday
Mar 2
8:00 pm
Eden
Scoot Inn, Austin, TX
SELECT * from toolvenuepagelink WHERE venueid = 3493
SELECT * from toolcitypagelink WHERE cityname = 'San Diego'
Eden
House of Blues - San Diego San Diego San Diego, CA
Mar 7, 7:00 pm 2018
Wednesday
Mar 7
7:00 pm
Eden
House of Blues - San Diego, San Diego, CA
SELECT * from toolvenuepagelink WHERE venueid = 546
SELECT * from toolcitypagelink WHERE cityname = 'Santa Ana'
Eden
The Observatory Santa Ana Santa Ana, CA
Mar 9, 8:00 pm 2018
Friday
Mar 9
8:00 pm
Eden
The Observatory, Santa Ana, CA
SELECT * from toolvenuepagelink WHERE venueid = 651
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Eden with Verite
Henry Fonda Theatre Los Angeles Los Angeles, CA
Mar 10, 9:00 pm 2018
Saturday
Mar 10
9:00 pm
Eden with Verite
Henry Fonda Theatre, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 3226
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Eden
Regency Ballroom - Social Hall San Francisco San Francisco, CA
Mar 13, 8:00 pm 2018
Tuesday
Mar 13
8:00 pm
Eden
Regency Ballroom - Social Hall, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 4829
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Eden
Hawthorne Theatre Portland Portland, OR
Mar 15, 8:00 pm 2018
Thursday
Mar 15
8:00 pm
Eden
Hawthorne Theatre, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 5085
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Eden
Showbox SoDo Seattle Seattle, WA
Mar 16, 9:00 pm 2018
Friday
Mar 16
9:00 pm
Eden
Showbox SoDo, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 9539
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
Eden with VERITE
The Complex Salt Lake City Salt Lake City, UT
Mar 19, 7:00 pm 2018
Monday
Mar 19
7:00 pm
Eden with VERITE
The Complex, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 159
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Eden
Bluebird Theater Denver Denver, CO
Mar 20, 8:00 pm 2018
Tuesday
Mar 20
8:00 pm
Eden
Bluebird Theater, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 8089
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
Eden
Cedar Cultural Center Minneapolis Minneapolis, MN
Mar 22, 7:00 pm 2018
Thursday
Mar 22
7:00 pm
Eden
Cedar Cultural Center, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 33343
SELECT * from toolcitypagelink WHERE cityname = 'Milwaukee'
Eden
The Rave/Eagles Club Milwaukee Milwaukee, WI
Mar 23, 8:00 pm 2018
Friday
Mar 23
8:00 pm
Eden
The Rave/Eagles Club, Milwaukee, WI
SELECT * from toolvenuepagelink WHERE venueid = 680
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Eden
House of Blues - Chicago Chicago Chicago, IL
Mar 24, 8:00 pm 2018
Saturday
Mar 24
8:00 pm
Eden
House of Blues - Chicago, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 1371
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
Eden
St. Andrews Hall Detroit Detroit, MI
Mar 26, 7:00 pm 2018
Monday
Mar 26
7:00 pm
Eden
St. Andrews Hall, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 2992
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Eden
Danforth Music Hall Toronto Toronto, ON
Mar 28, 7:00 pm 2018
Wednesday
Mar 28
7:00 pm
Eden
Danforth Music Hall, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 18123
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Eden
Corona Theatre Montreal Montreal, QC
Mar 29, 8:00 pm 2018
Thursday
Mar 29
8:00 pm
Eden
Corona Theatre, Montreal, QC
SELECT * from toolvenuepagelink WHERE venueid = 6064
SELECT * from toolcitypagelink WHERE cityname = 'Boston'

April

Eden (Moved from Paradise Rock Club)
House of Blues - Boston Boston Boston, MA
Apr 2, 8:00 pm 2018
Monday
Apr 2
8:00 pm
Eden (Moved from Paradise Rock Club)
House of Blues - Boston, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 725
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Eden
Irving Plaza New York New York, NY
Apr 4, 7:00 pm 2018
Wednesday
Apr 4
7:00 pm
Eden
Irving Plaza, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 725
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Eden
Irving Plaza New York New York, NY
Apr 5, 7:00 pm 2018
Thursday
Apr 5
7:00 pm
Eden
Irving Plaza, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 7916
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
Eden
Union Transfer Philadelphia Philadelphia, PA
Apr 6, 8:00 pm 2018
Friday
Apr 6
8:00 pm
Eden
Union Transfer, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 1959
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Eden
9:30 Club Washington Washington, DC
Apr 7, 8:00 pm 2018
Saturday
Apr 7
8:00 pm
Eden
9:30 Club, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 7725
SELECT * from toolcitypagelink WHERE cityname = 'Pittsburgh'
Eden
Stage AE Pittsburgh Pittsburgh, PA
Apr 10, 7:00 pm 2018
Tuesday
Apr 10
7:00 pm
Eden
Stage AE, Pittsburgh, PA
SELECT * from toolvenuepagelink WHERE venueid = 1110
SELECT * from toolcitypagelink WHERE cityname = 'Columbus'
Eden
Newport Music Hall Columbus Columbus, OH
Apr 11, 7:00 pm 2018
Wednesday
Apr 11
7:00 pm
Eden
Newport Music Hall, Columbus, OH
SELECT * from toolvenuepagelink WHERE venueid = 3312
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
Eden with Verite
Mercy Lounge Nashville Nashville, TN
Apr 12, 8:00 pm 2018
Thursday
Apr 12
8:00 pm
Eden with Verite
Mercy Lounge, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 1670
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Eden
Variety Playhouse Atlanta Atlanta, GA
Apr 14, 8:00 pm 2018
Saturday
Apr 14
8:00 pm
Eden
Variety Playhouse, Atlanta, GA
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football
NOUVELLES - SPORT