LISTE POUR : Broods

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

March

Broods
The Observatory Santa Ana Santa Ana, CA
Mar 26, 8:00 pm 2019
Tuesday
Mar 26
8:00 pm
Broods
The Observatory, Santa Ana, CA
SELECT * from toolvenuepagelink WHERE venueid = 651
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Broods
Henry Fonda Theatre Los Angeles Los Angeles, CA
Mar 27, 9:00 pm 2019
Wednesday
Mar 27
9:00 pm
Broods
Henry Fonda Theatre, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 28217
SELECT * from toolcitypagelink WHERE cityname = 'San Diego'
Broods
The Observatory North Park San Diego San Diego, CA
Mar 29, 8:00 pm 2019
Friday
Mar 29
8:00 pm
Broods
The Observatory North Park, San Diego, CA
SELECT * from toolvenuepagelink WHERE venueid = 33752
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Broods
August Hall San Francisco San Francisco, CA
Mar 30, 9:00 pm 2019
Saturday
Mar 30
9:00 pm
Broods
August Hall, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 7836
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'

April

Broods
The Neptune Theatre Seattle Seattle, WA
Apr 1, 8:00 pm 2019
Monday
Apr 1
8:00 pm
Broods
The Neptune Theatre, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 1692
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Broods
Vogue Theatre Vancouver Vancouver, BC
Apr 2, 8:00 pm 2019
Tuesday
Apr 2
8:00 pm
Broods
Vogue Theatre, Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 4059
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Broods
Wonder Ballroom Portland Portland, OR
Apr 3, 8:30 pm 2019
Wednesday
Apr 3
8:30 pm
Broods
Wonder Ballroom, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 3541
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
Broods
In The Venue Salt Lake City Salt Lake City, UT
Apr 5, 7:00 pm 2019
Friday
Apr 5
7:00 pm
Broods
In The Venue, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 7810
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Broods
Summit Music Hall Denver Denver, CO
Apr 6, 8:00 pm 2019
Saturday
Apr 6
8:00 pm
Broods
Summit Music Hall, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 33547
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Broods
The Truman Kansas City Kansas City, MO
Apr 7, 8:00 pm 2019
Sunday
Apr 7
8:00 pm
Broods
The Truman, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 493
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
Broods
Fine Line Music Cafe Minneapolis Minneapolis, MN
Apr 8, 7:00 pm 2019
Monday
Apr 8
7:00 pm
Broods
Fine Line Music Cafe, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 28883
SELECT * from toolcitypagelink WHERE cityname = 'Saint Paul'
Broods
Amsterdam Bar and Hall Saint Paul Saint Paul, MN
Apr 8, 7:00 pm 2019
Monday
Apr 8
7:00 pm
Broods
Amsterdam Bar and Hall, Saint Paul, MN
SELECT * from toolvenuepagelink WHERE venueid = 2164
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Broods
Metro Smart Bar Chicago Chicago, IL
Apr 10, 9:00 pm 2019
Wednesday
Apr 10
9:00 pm
Broods
Metro Smart Bar, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 2885
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Broods
Phoenix Concert Theatre Toronto Toronto, ON
Apr 12, 7:30 pm 2019
Friday
Apr 12
7:30 pm
Broods
Phoenix Concert Theatre, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 32982
SELECT * from toolcitypagelink WHERE cityname = 'Montréal'
Broods
Theatre Fairmount Montréal Montréal, QC
Apr 13, 8:00 pm 2019
Saturday
Apr 13
8:00 pm
Broods
Theatre Fairmount, Montréal, QC
SELECT * from toolvenuepagelink WHERE venueid = 2254
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Broods
Paradise Rock Club Boston Boston, MA
Apr 14, 8:00 pm 2019
Sunday
Apr 14
8:00 pm
Broods
Paradise Rock Club, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 7916
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
Broods
Union Transfer Philadelphia Philadelphia, PA
Apr 16, 8:30 pm 2019
Tuesday
Apr 16
8:30 pm
Broods
Union Transfer, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 725
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Broods
Irving Plaza New York New York, NY
Apr 18, 7:00 pm 2019
Thursday
Apr 18
7:00 pm
Broods
Irving Plaza, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 5559
SELECT * from toolcitypagelink WHERE cityname = 'Asbury Park'
Broods
Asbury Lanes Asbury Park Asbury Park, NJ
Apr 19, 8:00 pm 2019
Friday
Apr 19
8:00 pm
Broods
Asbury Lanes, Asbury Park, NJ
SELECT * from toolvenuepagelink WHERE venueid = 7900
SELECT * from toolcitypagelink WHERE cityname = 'Silver Spring'
Broods
The Fillmore Silver Spring Silver Spring Silver Spring, MD
Apr 20, 8:00 pm 2019
Saturday
Apr 20
8:00 pm
Broods
The Fillmore Silver Spring, Silver Spring, MD
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football