LISTE POUR : Brockhampton

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

February

Brockhampton
Vogue Theatre Vancouver Vancouver, BC
Feb 26, 9:00 pm 2018
Monday
Feb 26
9:00 pm
Brockhampton
Vogue Theatre, Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 1419
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Brockhampton
The Showbox Seattle Seattle, WA
Feb 27, 9:00 pm 2018
Tuesday
Feb 27
9:00 pm
Brockhampton
The Showbox, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 1419
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Brockhampton
The Showbox Seattle Seattle, WA
Feb 28, 8:00 pm 2018
Wednesday
Feb 28
8:00 pm
Brockhampton
The Showbox, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 2395
SELECT * from toolcitypagelink WHERE cityname = 'Portland'

March

Brockhampton
McMenamins Crystal Ballroom Portland Portland, OR
Mar 2, 9:00 pm 2018
Friday
Mar 2
9:00 pm
Brockhampton
McMenamins Crystal Ballroom, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 1708
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Brockhampton
The Warfield San Francisco San Francisco, CA
Mar 3, 9:00 pm 2018
Saturday
Mar 3
9:00 pm
Brockhampton
The Warfield, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 1708
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Brockhampton
The Warfield San Francisco San Francisco, CA
Mar 4, 9:00 pm 2018
Sunday
Mar 4
9:00 pm
Brockhampton
The Warfield, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 9556
SELECT * from toolcitypagelink WHERE cityname = 'Sacramento'
Brockhampton
Ace of Spades Sacramento Sacramento, CA
Mar 5, 7:00 pm 2018
Monday
Mar 5
7:00 pm
Brockhampton
Ace of Spades, Sacramento, CA
SELECT * from toolvenuepagelink WHERE venueid = 33533
SELECT * from toolcitypagelink WHERE cityname = 'Phoenix'
Brockhampton
The Van Buren Phoenix Phoenix, AZ
Mar 7, 9:00 pm 2018
Wednesday
Mar 7
9:00 pm
Brockhampton
The Van Buren, Phoenix, AZ
SELECT * from toolvenuepagelink WHERE venueid = 33533
SELECT * from toolcitypagelink WHERE cityname = 'Phoenix'
Brockhampton
The Van Buren Phoenix Phoenix, AZ
Mar 8, 9:00 pm 2018
Thursday
Mar 8
9:00 pm
Brockhampton
The Van Buren, Phoenix, AZ
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football