LISTE POUR : Dandy Warhols

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

May

The Dandy Warhols
9:30 Club Washington Washington, DC
May 6, 7:00 pm 2019
Monday
May 6
7:00 pm
The Dandy Warhols
9:30 Club, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 31549
SELECT * from toolcitypagelink WHERE cityname = 'Cambridge'
The Dandy Warhols
The Sinclair Cambridge Cambridge, MA
May 7, 8:00 pm 2019
Tuesday
May 7
8:00 pm
The Dandy Warhols
The Sinclair, Cambridge, MA
SELECT * from toolvenuepagelink WHERE venueid = 33405
SELECT * from toolcitypagelink WHERE cityname = 'Brooklyn'
The Dandy Warhols
Brooklyn Steel Brooklyn Brooklyn, NY
May 8, 8:00 pm 2019
Wednesday
May 8
8:00 pm
The Dandy Warhols
Brooklyn Steel, Brooklyn, NY
SELECT * from toolvenuepagelink WHERE venueid = 2992
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
The Dandy Warhols
Danforth Music Hall Toronto Toronto, ON
May 9, 7:00 pm 2019
Thursday
May 9
7:00 pm
The Dandy Warhols
Danforth Music Hall, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 2164
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
The Dandy Warhols
Metro Smart Bar Chicago Chicago, IL
May 11, 7:30 pm 2019
Saturday
May 11
7:30 pm
The Dandy Warhols
Metro Smart Bar, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 496
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
Dandy Warhols
First Avenue Minneapolis Minneapolis, MN
May 12, 7:00 pm 2019
Sunday
May 12
7:00 pm
Dandy Warhols
First Avenue, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 2040
SELECT * from toolcitypagelink WHERE cityname = 'Englewood'
The Dandy Warhols
Gothic Theatre Englewood Englewood, CO
May 14, 8:00 pm 2019
Tuesday
May 14
8:00 pm
The Dandy Warhols
Gothic Theatre, Englewood, CO
SELECT * from toolvenuepagelink WHERE venueid = 31629
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
The Dandy Warhols
The Theatre at Ace Hotel Los Angeles Los Angeles, CA
May 16, 8:00 pm 2019
Thursday
May 16
8:00 pm
The Dandy Warhols
The Theatre at Ace Hotel, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 28217
SELECT * from toolcitypagelink WHERE cityname = 'San Diego'
The Dandy Warhols
The Observatory North Park San Diego San Diego, CA
May 17, 8:00 pm 2019
Friday
May 17
8:00 pm
The Dandy Warhols
The Observatory North Park, San Diego, CA
SELECT * from toolvenuepagelink WHERE venueid = 492
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Dandy Warhols
The Fillmore - San Francisco San Francisco San Francisco, CA
May 18, 9:00 pm 2019
Saturday
May 18
9:00 pm
Dandy Warhols
The Fillmore - San Francisco, San Francisco, CA
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football