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 = 1692
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'

October

Eden
Vogue Theatre Vancouver Vancouver, BC
Oct 2, 8:00 pm 2018
Tuesday
Oct 2
8:00 pm
Eden
Vogue Theatre, Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 2395
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Eden
McMenamins Crystal Ballroom Portland Portland, OR
Oct 3, 8:00 pm 2018
Wednesday
Oct 3
8:00 pm
Eden
McMenamins Crystal Ballroom, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 4309
SELECT * from toolcitypagelink WHERE cityname = 'Chico'
Eden
Senator Theatre Chico Chico, CA
Oct 5, 8:00 pm 2018
Friday
Oct 5
8:00 pm
Eden
Senator Theatre, Chico, CA
SELECT * from toolvenuepagelink WHERE venueid = 9556
SELECT * from toolcitypagelink WHERE cityname = 'Sacramento'
Eden
Ace of Spades Sacramento Sacramento, CA
Oct 6, 7:00 pm 2018
Saturday
Oct 6
7:00 pm
Eden
Ace of Spades, Sacramento, CA
SELECT * from toolvenuepagelink WHERE venueid = 2159
SELECT * from toolcitypagelink WHERE cityname = 'Santa Cruz'
Eden
The Catalyst - CA Santa Cruz Santa Cruz, CA
Oct 9, 8:00 pm 2018
Tuesday
Oct 9
8:00 pm
Eden
The Catalyst - CA, Santa Cruz, CA
SELECT * from toolvenuepagelink WHERE venueid = 31629
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Eden
The Theatre at Ace Hotel Los Angeles Los Angeles, CA
Oct 10, 8:00 pm 2018
Wednesday
Oct 10
8:00 pm
Eden
The Theatre at Ace Hotel, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 33533
SELECT * from toolcitypagelink WHERE cityname = 'Phoenix'
Eden
The Van Buren Phoenix Phoenix, AZ
Oct 12, 8:00 pm 2018
Friday
Oct 12
8:00 pm
Eden
The Van Buren, Phoenix, AZ
SELECT * from toolvenuepagelink WHERE venueid = 3554
SELECT * from toolcitypagelink WHERE cityname = 'Albuquerque'
Eden
Sunshine Theatre Albuquerque Albuquerque, NM
Oct 13, 7:00 pm 2018
Saturday
Oct 13
7:00 pm
Eden
Sunshine Theatre, Albuquerque, NM
SELECT * from toolvenuepagelink WHERE venueid = 1131
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Eden
Ogden Theatre Denver Denver, CO
Oct 15, 8:00 pm 2018
Monday
Oct 15
8:00 pm
Eden
Ogden Theatre, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 30759
SELECT * from toolcitypagelink WHERE cityname = 'St. Louis'
Eden
The Ready Room St. Louis St. Louis, MO
Oct 19, 8:00 pm 2018
Friday
Oct 19
8:00 pm
Eden
The Ready Room, St. Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 1324
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Eden
Riviera Theatre (Chicago) Chicago Chicago, IL
Oct 20, 8:00 pm 2018
Saturday
Oct 20
8:00 pm
Eden
Riviera Theatre (Chicago), Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 19289
SELECT * from toolcitypagelink WHERE cityname = 'Indianapolis'
Eden
Deluxe at Old National Centre Indianapolis Indianapolis, IN
Oct 23, 8:00 pm 2018
Tuesday
Oct 23
8:00 pm
Eden
Deluxe at Old National Centre, Indianapolis, IN
SELECT * from toolvenuepagelink WHERE venueid = 16281
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
Eden
Marathon Music Works Nashville Nashville, TN
Oct 24, 8:00 pm 2018
Wednesday
Oct 24
8:00 pm
Eden
Marathon Music Works, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 3607
SELECT * from toolcitypagelink WHERE cityname = 'Fort Lauderdale'
Eden
Culture Room Fort Lauderdale Fort Lauderdale, FL
Oct 26, 7:00 pm 2018
Friday
Oct 26
7:00 pm
Eden
Culture Room, Fort Lauderdale, FL
SELECT * from toolvenuepagelink WHERE venueid = 3462
SELECT * from toolcitypagelink WHERE cityname = 'Charleston'
Eden
Music Farm Charleston Charleston, SC
Oct 30, 8:00 pm 2018
Tuesday
Oct 30
8:00 pm
Eden
Music Farm, Charleston, SC
SELECT * from toolvenuepagelink WHERE venueid = 6693
SELECT * from toolcitypagelink WHERE cityname = 'Charlotte'
Eden
The Underground - Fillmore Charlotte Charlotte Charlotte, NC
Oct 31, 8:00 pm 2018
Wednesday
Oct 31
8:00 pm
Eden
The Underground - Fillmore Charlotte, Charlotte, NC
SELECT * from toolvenuepagelink WHERE venueid = 7725
SELECT * from toolcitypagelink WHERE cityname = 'Pittsburgh'

November

Eden
Stage AE Pittsburgh Pittsburgh, PA
Nov 2, 7:00 pm 2018
Friday
Nov 2
7:00 pm
Eden
Stage AE, Pittsburgh, PA
SELECT * from toolvenuepagelink WHERE venueid = 3508
SELECT * from toolcitypagelink WHERE cityname = 'Baltimore'
Eden
Rams Head Live Baltimore Baltimore, MD
Nov 3, 8:00 pm 2018
Saturday
Nov 3
8:00 pm
Eden
Rams Head Live, Baltimore, MD
SELECT * from toolvenuepagelink WHERE venueid = 3468
SELECT * from toolcitypagelink WHERE cityname = 'New Haven'
Eden
Toad's Place New Haven New Haven, CT
Nov 4, 8:00 pm 2018
Sunday
Nov 4
8:00 pm
Eden
Toad's Place, New Haven, CT
SELECT * from toolvenuepagelink WHERE venueid = 31471
SELECT * from toolcitypagelink WHERE cityname = 'Providence'
Eden
Fete Providence Providence, RI
Nov 6, 8:00 pm 2018
Tuesday
Nov 6
8:00 pm
Eden
Fete, Providence, RI
SELECT * from toolvenuepagelink WHERE venueid = 33405
SELECT * from toolcitypagelink WHERE cityname = 'Brooklyn'
Eden
Brooklyn Steel Brooklyn Brooklyn, NY
Nov 9, 8:00 pm 2018
Friday
Nov 9
8:00 pm
Eden
Brooklyn Steel, Brooklyn, NY
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football