LISTE POUR : Gnash

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

January

Gnash with Mallrat
Irving Plaza New York New York, NY
Jan 22, 7:00 pm 2019
Tuesday
Jan 22
7:00 pm
Gnash with Mallrat
Irving Plaza, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 7686
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Gnash with Mallrat
Brighton Music Hall Boston Boston, MA
Jan 23, 6:00 pm 2019
Wednesday
Jan 23
6:00 pm
Gnash with Mallrat
Brighton Music Hall, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 3142
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Gnash with Mallrat
Mod Club Theatre Toronto Toronto, ON
Jan 24, 7:00 pm 2019
Thursday
Jan 24
7:00 pm
Gnash with Mallrat
Mod Club Theatre, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 5471
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Gnash
Bottom Lounge Chicago Chicago, IL
Jan 26, 7:30 pm 2019
Saturday
Jan 26
7:30 pm
Gnash
Bottom Lounge, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 5039
SELECT * from toolcitypagelink WHERE cityname = 'Milwaukee'
Gnash
Turner Hall Ballroom Milwaukee Milwaukee, WI
Jan 27, 7:30 pm 2019
Sunday
Jan 27
7:30 pm
Gnash
Turner Hall Ballroom, Milwaukee, WI
SELECT * from toolvenuepagelink WHERE venueid = 6040
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Gnash
Riot Room Kansas City Kansas City, MO
Jan 28, 7:30 pm 2019
Monday
Jan 28
7:30 pm
Gnash
Riot Room, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 159
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Gnash
Bluebird Theater Denver Denver, CO
Jan 30, 7:30 pm 2019
Wednesday
Jan 30
7:30 pm
Gnash
Bluebird Theater, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 4336
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'

February

Gnash
Neumos Seattle Seattle, WA
Feb 4, 7:00 pm 2019
Monday
Feb 4
7:00 pm
Gnash
Neumos, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 4829
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Gnash
Hawthorne Theatre Portland Portland, OR
Feb 5, 7:30 pm 2019
Tuesday
Feb 5
7:30 pm
Gnash
Hawthorne Theatre, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 33752
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Gnash
August Hall San Francisco San Francisco, CA
Feb 7, 7:30 pm 2019
Thursday
Feb 7
7:30 pm
Gnash
August Hall, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 442
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Gnash
El Rey Theatre Los Angeles Los Angeles, CA
Feb 8, 8:00 pm 2019
Friday
Feb 8
8:00 pm
Gnash
El Rey Theatre, Los Angeles, 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