LISTE POUR : The Lemon Twigs

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

January

The Lemon Twigs
Music Hall of Williamsburg Brooklyn Brooklyn, NY
Jan 18, 9:00 pm 2019
Friday
Jan 18
9:00 pm
The Lemon Twigs
Music Hall of Williamsburg, Brooklyn, NY
SELECT * from toolvenuepagelink WHERE venueid = 4853
SELECT * from toolcitypagelink WHERE cityname = 'Brooklyn'
The Lemon Twigs
Music Hall of Williamsburg Brooklyn Brooklyn, NY
Jan 19, 8:00 pm 2019
Saturday
Jan 19
8:00 pm
The Lemon Twigs
Music Hall of Williamsburg, Brooklyn, NY
SELECT * from toolvenuepagelink WHERE venueid = 2885
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
The Lemon Twigs
Phoenix Concert Theatre Toronto Toronto, ON
Jan 22, 7:30 pm 2019
Tuesday
Jan 22
7:30 pm
The Lemon Twigs
Phoenix Concert Theatre, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 33149
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
The Lemon Twigs
El Club Detroit Detroit, MI
Jan 23, 7:00 pm 2019
Wednesday
Jan 23
7:00 pm
The Lemon Twigs
El Club, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 2164
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
The Lemon Twigs
Metro Smart Bar Chicago Chicago, IL
Jan 25, 9:00 pm 2019
Friday
Jan 25
9:00 pm
The Lemon Twigs
Metro Smart Bar, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 496
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
The Lemon Twigs
First Avenue Minneapolis Minneapolis, MN
Jan 26, 9:00 pm 2019
Saturday
Jan 26
9:00 pm
The Lemon Twigs
First Avenue, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 7836
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
The Lemon Twigs
The Neptune Theatre Seattle Seattle, WA
Jan 29, 8:00 pm 2019
Tuesday
Jan 29
8:00 pm
The Lemon Twigs
The Neptune Theatre, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 6919
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
The Lemon Twigs
Venue-BC Vancouver Vancouver, BC
Jan 30, 8:00 pm 2019
Wednesday
Jan 30
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 4059
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
The Lemon Twigs
Wonder Ballroom Portland Portland, OR
Jan 31, 7:30 pm 2019
Thursday
Jan 31
7:30 pm
The Lemon Twigs
Wonder Ballroom, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 1803
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'

February

The Lemon Twigs
Slim's San Francisco San Francisco, CA
Feb 2, 8:00 pm 2019
Saturday
Feb 2
8:00 pm
The Lemon Twigs
Slim's, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 442
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
The Lemon Twigs
El Rey Theatre Los Angeles Los Angeles, CA
Feb 5, 8:30 pm 2019
Tuesday
Feb 5
8:30 pm
The Lemon Twigs
El Rey Theatre, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 442
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
The Lemon Twigs
El Rey Theatre Los Angeles Los Angeles, CA
Feb 6, 8:30 pm 2019
Wednesday
Feb 6
8:30 pm
The Lemon Twigs
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