LISTE POUR : Teenage Fanclub

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

February

Teenage Fanclub
Commodore Ballroom Vancouver Vancouver, BC
Feb 21, 7:00 pm 2019
Thursday
Feb 21
7:00 pm
Teenage Fanclub
Commodore Ballroom, Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 7836
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Teenage Fanclub
The Neptune Theatre Seattle Seattle, WA
Feb 22, 9:00 pm 2019
Friday
Feb 22
9:00 pm
Teenage Fanclub
The Neptune Theatre, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 4059
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Teenage Fanclub
Wonder Ballroom Portland Portland, OR
Feb 23, 9:00 pm 2019
Saturday
Feb 23
9:00 pm
Teenage Fanclub
Wonder Ballroom, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 492
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Teenage Fanclub
The Fillmore - San Francisco San Francisco San Francisco, CA
Feb 25, 8:00 pm 2019
Monday
Feb 25
8:00 pm
Teenage Fanclub
The Fillmore - San Francisco, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 32375
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Teenage Fanclub
Teragram Ballroom Los Angeles Los Angeles, CA
Feb 26, 8:00 pm 2019
Tuesday
Feb 26
8:00 pm
Teenage Fanclub
Teragram Ballroom, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 32375
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Teenage Fanclub
Teragram Ballroom Los Angeles Los Angeles, CA
Feb 27, 8:00 pm 2019
Wednesday
Feb 27
8:00 pm
Teenage Fanclub
Teragram Ballroom, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 159
SELECT * from toolcitypagelink WHERE cityname = 'Denver'

March

Teenage Fanclub
Bluebird Theater Denver Denver, CO
Mar 2, 9:00 pm 2019
Saturday
Mar 2
9:00 pm
Teenage Fanclub
Bluebird Theater, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 4092
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
Teenage Fanclub
Varsity Theater - Minneapolis, MN Minneapolis Minneapolis, MN
Mar 4, 7:00 pm 2019
Monday
Mar 4
7:00 pm
Teenage Fanclub
Varsity Theater - Minneapolis, MN, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 4106
SELECT * from toolcitypagelink WHERE cityname = 'Madison'
Teenage Fanclub
Majestic Theatre Madison Madison, WI
Mar 5, 8:00 pm 2019
Tuesday
Mar 5
8:00 pm
Teenage Fanclub
Majestic Theatre, Madison, WI
SELECT * from toolvenuepagelink WHERE venueid = 2164
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Teenage Fanclub
Metro Smart Bar Chicago Chicago, IL
Mar 6, 7:30 pm 2019
Wednesday
Mar 6
7:30 pm
Teenage Fanclub
Metro Smart Bar, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 33149
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
Teenage Fanclub
El Club Detroit Detroit, MI
Mar 7, 8:00 pm 2019
Thursday
Mar 7
8:00 pm
Teenage Fanclub
El Club, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 2885
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Teenage Fanclub
Phoenix Concert Theatre Toronto Toronto, ON
Mar 8, 7:00 pm 2019
Friday
Mar 8
7:00 pm
Teenage Fanclub
Phoenix Concert Theatre, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 27951
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Teenage Fanclub
Petit Campus Montreal Montreal, QC
Mar 9, 8:00 pm 2019
Saturday
Mar 9
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 2254
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Teenage Fanclub
Paradise Rock Club Boston Boston, MA
Mar 11, 8:00 pm 2019
Monday
Mar 11
8:00 pm
Teenage Fanclub
Paradise Rock Club, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 1822
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Teenage Fanclub
Bowery Ballroom New York New York, NY
Mar 13, 9:00 pm 2019
Wednesday
Mar 13
9:00 pm
Teenage Fanclub
Bowery Ballroom, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 4853
SELECT * from toolcitypagelink WHERE cityname = 'Brooklyn'
Teenage Fanclub
Music Hall of Williamsburg Brooklyn Brooklyn, NY
Mar 14, 9:00 pm 2019
Thursday
Mar 14
9:00 pm
Teenage Fanclub
Music Hall of Williamsburg, Brooklyn, NY
SELECT * from toolvenuepagelink WHERE venueid = 7916
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
Teenage Fanclub
Union Transfer Philadelphia Philadelphia, PA
Mar 15, 8:30 pm 2019
Friday
Mar 15
8:30 pm
Teenage Fanclub
Union Transfer, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 1959
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Teenage Fanclub
9:30 Club Washington Washington, DC
Mar 16, 8:00 pm 2019
Saturday
Mar 16
8:00 pm
Teenage Fanclub
9:30 Club, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 28927
SELECT * from toolcitypagelink WHERE cityname = 'Saxapahaw'
Teenage Fanclub
Haw River Ballroom Saxapahaw Saxapahaw, NC
Mar 18, 7:30 pm 2019
Monday
Mar 18
7:30 pm
Teenage Fanclub
Haw River Ballroom, Saxapahaw, NC
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football