LISTE POUR : Gryffin

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

January

Gryffin
Theatre of Living Arts Philadelphia Philadelphia, PA
Jan 25, 8:00 pm 2019
Friday
Jan 25
8:00 pm
Gryffin
Theatre of Living Arts, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 10642
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Gryffin
Echostage at Glow Washington Washington, DC
Jan 26, 9:00 pm 2019
Saturday
Jan 26
9:00 pm
Gryffin
Echostage at Glow, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 6064
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Gryffin
House of Blues - Boston Boston Boston, MA
Jan 31, 7:00 pm 2019
Thursday
Jan 31
7:00 pm
Gryffin
House of Blues - Boston, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 33405
SELECT * from toolcitypagelink WHERE cityname = 'Brooklyn'

February

Gryffin
Brooklyn Steel Brooklyn Brooklyn, NY
Feb 1, 7:00 pm 2019
Friday
Feb 1
7:00 pm
Gryffin
Brooklyn Steel, Brooklyn, NY
SELECT * from toolvenuepagelink WHERE venueid = 33405
SELECT * from toolcitypagelink WHERE cityname = 'Brooklyn'
Gryffin
Brooklyn Steel Brooklyn Brooklyn, NY
Feb 2, 7:00 pm 2019
Saturday
Feb 2
7:00 pm
Gryffin
Brooklyn Steel, Brooklyn, NY
SELECT * from toolvenuepagelink WHERE venueid = 5960
SELECT * from toolcitypagelink WHERE cityname = 'Syracuse'
Gryffin
Westcott Theatre Syracuse Syracuse, NY
Feb 5, 9:00 pm 2019
Tuesday
Feb 5
9:00 pm
Gryffin
Westcott Theatre, Syracuse, NY
SELECT * from toolvenuepagelink WHERE venueid = 3919
SELECT * from toolcitypagelink WHERE cityname = 'South Burlington'
Gryffin
Higher Ground South Burlington South Burlington, VT
Feb 6, 8:30 pm 2019
Wednesday
Feb 6
8:30 pm
Gryffin
Higher Ground, South Burlington, VT
SELECT * from toolvenuepagelink WHERE venueid = 18123
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Gryffin
Corona Theatre Montreal Montreal, QC
Feb 7, 8:00 pm 2019
Thursday
Feb 7
8:00 pm
Gryffin
Corona Theatre, Montreal, QC
SELECT * from toolvenuepagelink WHERE venueid = 2992
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Gryffin
Danforth Music Hall Toronto Toronto, ON
Feb 8, 7:00 pm 2019
Friday
Feb 8
7:00 pm
Gryffin
Danforth Music Hall, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 30272
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Gryffin
Concord Music Hall Chicago Chicago, IL
Feb 9, 6:00 pm 2019
Saturday
Feb 9
6:00 pm
Gryffin
Concord Music Hall, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 30272
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Gryffin
Concord Music Hall Chicago Chicago, IL
Feb 9, 11:00 pm 2019
Saturday
Feb 9
11:00 pm
Gryffin
Concord Music Hall, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 4106
SELECT * from toolcitypagelink WHERE cityname = 'Madison'
Gryffin
Majestic Theatre Madison Madison, WI
Feb 10, 8:00 pm 2019
Sunday
Feb 10
8:00 pm
Gryffin
Majestic Theatre, Madison, WI
SELECT * from toolvenuepagelink WHERE venueid = 1945
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Gryffin
Commodore Ballroom Vancouver Vancouver, BC
Feb 15, 10:00 pm 2019
Friday
Feb 15
10:00 pm
Gryffin
Commodore Ballroom, Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 5085
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Gryffin
Showbox SoDo Seattle Seattle, WA
Feb 16, 6:45 pm 2019
Saturday
Feb 16
6:45 pm
Gryffin
Showbox SoDo, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 5085
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Gryffin
Showbox SoDo Seattle Seattle, WA
Feb 16, 10:45 pm 2019
Saturday
Feb 16
10:45 pm
Gryffin
Showbox SoDo, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 4059
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Gryffin
Wonder Ballroom Portland Portland, OR
Feb 17, 9:00 pm 2019
Sunday
Feb 17
9:00 pm
Gryffin
Wonder Ballroom, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 2607
SELECT * from toolcitypagelink WHERE cityname = 'Boise'
Gryffin
Knitting Factory Concert House - Boise Boise Boise, ID
Feb 20, 8:00 pm 2019
Wednesday
Feb 20
8:00 pm
Gryffin
Knitting Factory Concert House - Boise, Boise, ID
SELECT * from toolvenuepagelink WHERE venueid = 3946
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
Gryffin
The Depot Salt Lake City Salt Lake City, UT
Feb 21, 8:00 pm 2019
Thursday
Feb 21
8:00 pm
Gryffin
The Depot, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 144
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Gryffin
Bill Graham Civic Auditorium San Francisco San Francisco, CA
Feb 23, 8:00 pm 2019
Saturday
Feb 23
8:00 pm
Gryffin
Bill Graham Civic Auditorium, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 6519
SELECT * from toolcitypagelink WHERE cityname = 'Pomona'
Gryffin with Yung Bae
Fox Theater Pomona Pomona Pomona, CA
Feb 26, 9:00 pm 2019
Tuesday
Feb 26
9:00 pm
Gryffin with Yung Bae
Fox Theater Pomona, Pomona, 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