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 = 442
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'

December

Brockhampton
El Rey Theatre Los Angeles Los Angeles, CA
Dec 27, 9:00 pm 2017
Wednesday
Dec 27
9:00 pm
Brockhampton
El Rey Theatre, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 442
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Brockhampton
El Rey Theatre Los Angeles Los Angeles, CA
Dec 28, 9:00 pm 2017
Thursday
Dec 28
9:00 pm
Brockhampton
El Rey Theatre, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 442
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Brockhampton
El Rey Theatre Los Angeles Los Angeles, CA
Dec 29, 8:00 pm 2017
Friday
Dec 29
8:00 pm
Brockhampton
El Rey Theatre, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 4568
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'

January

Brockhampton
House of Blues - Dallas Dallas Dallas, TX
Jan 16, 9:00 pm 2018
Tuesday
Jan 16
9:00 pm
Brockhampton
House of Blues - Dallas, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 5679
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
Brockhampton
House of Blues - Houston Houston Houston, TX
Jan 17, 9:00 pm 2018
Wednesday
Jan 17
9:00 pm
Brockhampton
House of Blues - Houston, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 30567
SELECT * from toolcitypagelink WHERE cityname = 'San Antonio'
Brockhampton
Aztec Theater San Antonio San Antonio, TX
Jan 19, 8:00 pm 2018
Friday
Jan 19
8:00 pm
Brockhampton
Aztec Theater, San Antonio, TX
SELECT * from toolvenuepagelink WHERE venueid = 2171
SELECT * from toolcitypagelink WHERE cityname = 'Austin'
Brockhampton
Emo's East Austin Austin, TX
Jan 20, 8:00 pm 2018
Saturday
Jan 20
8:00 pm
Brockhampton
Emo's East, Austin, TX
SELECT * from toolvenuepagelink WHERE venueid = 1936
SELECT * from toolcitypagelink WHERE cityname = 'New Orleans'
Brockhampton
House of Blues - New Orleans New Orleans New Orleans, LA
Jan 22, 8:00 pm 2018
Monday
Jan 22
8:00 pm
Brockhampton
House of Blues - New Orleans, New Orleans, LA
SELECT * from toolvenuepagelink WHERE venueid = 7465
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Brockhampton
Buckhead Theatre Atlanta Atlanta, GA
Jan 23, 8:00 pm 2018
Tuesday
Jan 23
8:00 pm
Brockhampton
Buckhead Theatre, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 7465
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Brockhampton
Buckhead Theatre Atlanta Atlanta, GA
Jan 24, 8:00 pm 2018
Wednesday
Jan 24
8:00 pm
Brockhampton
Buckhead Theatre, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 5552
SELECT * from toolcitypagelink WHERE cityname = 'Fort Lauderdale'
Brockhampton
Revolution Live Fort Lauderdale Fort Lauderdale, FL
Jan 25, 8:00 pm 2018
Thursday
Jan 25
8:00 pm
Brockhampton
Revolution Live, Fort Lauderdale, FL
SELECT * from toolvenuepagelink WHERE venueid = 5826
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Brockhampton
The Ritz Ybor Tampa Tampa, FL
Jan 26, 8:00 pm 2018
Friday
Jan 26
8:00 pm
Brockhampton
The Ritz Ybor, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 7900
SELECT * from toolcitypagelink WHERE cityname = 'Silver Spring'
Brockhampton
The Fillmore Silver Spring Silver Spring Silver Spring, MD
Jan 28, 8:00 pm 2018
Sunday
Jan 28
8:00 pm
Brockhampton
The Fillmore Silver Spring, Silver Spring, MD
SELECT * from toolvenuepagelink WHERE venueid = 4022
SELECT * from toolcitypagelink WHERE cityname = 'Raleigh'
Brockhampton
Lincoln Theatre - NC Raleigh Raleigh, NC
Jan 29, 9:00 pm 2018
Monday
Jan 29
9:00 pm
Brockhampton
Lincoln Theatre - NC, Raleigh, NC
SELECT * from toolvenuepagelink WHERE venueid = 856
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
Brockhampton
Theatre of Living Arts Philadelphia Philadelphia, PA
Jan 30, 9:00 pm 2018
Tuesday
Jan 30
9:00 pm
Brockhampton
Theatre of Living Arts, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 856
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
Brockhampton
Theatre of Living Arts Philadelphia Philadelphia, PA
Jan 31, 9:00 pm 2018
Wednesday
Jan 31
9:00 pm
Brockhampton
Theatre of Living Arts, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 725
SELECT * from toolcitypagelink WHERE cityname = 'New York'

February

Brockhampton
Irving Plaza New York New York, NY
Feb 2, 8:00 pm 2018
Friday
Feb 2
8:00 pm
Brockhampton
Irving Plaza, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 725
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Brockhampton
Irving Plaza New York New York, NY
Feb 3, 9:00 pm 2018
Saturday
Feb 3
9:00 pm
Brockhampton
Irving Plaza, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 725
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Brockhampton
Irving Plaza New York New York, NY
Feb 4, 9:00 pm 2018
Sunday
Feb 4
9:00 pm
Brockhampton
Irving Plaza, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 6064
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Brockhampton
House of Blues - Boston Boston Boston, MA
Feb 5, 8:00 pm 2018
Monday
Feb 5
8:00 pm
Brockhampton
House of Blues - Boston, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 18123
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Brockhampton
Corona Theatre Montreal Montreal, QC
Feb 6, 8:00 pm 2018
Tuesday
Feb 6
8:00 pm
Brockhampton
Corona Theatre, Montreal, QC
SELECT * from toolvenuepagelink WHERE venueid = 18146
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Brockhampton
Rebel Toronto Toronto, ON
Feb 8, 8:00 pm 2018
Thursday
Feb 8
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 19289
SELECT * from toolcitypagelink WHERE cityname = 'Indianapolis'
Brockhampton
Deluxe at Old National Centre Indianapolis Indianapolis, IN
Feb 10, 9:30 pm 2018
Saturday
Feb 10
9:30 pm
Brockhampton
Deluxe at Old National Centre, Indianapolis, IN
SELECT * from toolvenuepagelink WHERE venueid = 905
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
Brockhampton
Majestic Theatre Detroit Detroit Detroit, MI
Feb 11, 8:00 pm 2018
Sunday
Feb 11
8:00 pm
Brockhampton
Majestic Theatre Detroit, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 720
SELECT * from toolcitypagelink WHERE cityname = 'Grand Rapids'
Brockhampton
Intersection Grand Rapids Grand Rapids, MI
Feb 13, 8:00 pm 2018
Tuesday
Feb 13
8:00 pm
Brockhampton
Intersection, Grand Rapids, MI
SELECT * from toolvenuepagelink WHERE venueid = 33473
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
Brockhampton
Music Hall Minneapolis Minneapolis, MN
Feb 15, 9:00 pm 2018
Thursday
Feb 15
9:00 pm
Brockhampton
Music Hall, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 33343
SELECT * from toolcitypagelink WHERE cityname = 'Milwaukee'
Brockhampton
The Rave/Eagles Club Milwaukee Milwaukee, WI
Feb 16, 8:00 pm 2018
Friday
Feb 16
8:00 pm
Brockhampton
The Rave/Eagles Club, Milwaukee, WI
SELECT * from toolvenuepagelink WHERE venueid = 680
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Brockhampton
House of Blues - Chicago Chicago Chicago, IL
Feb 18, 8:00 pm 2018
Sunday
Feb 18
8:00 pm
Brockhampton
House of Blues - Chicago, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 680
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Brockhampton
House of Blues - Chicago Chicago Chicago, IL
Feb 19, 8:00 pm 2018
Monday
Feb 19
8:00 pm
Brockhampton
House of Blues - Chicago, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 33347
SELECT * from toolcitypagelink WHERE cityname = 'St. Louis'
Brockhampton
The Pageant St. Louis St. Louis, MO
Feb 20, 8:00 pm 2018
Tuesday
Feb 20
8:00 pm
Brockhampton
The Pageant, St. Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 33547
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Brockhampton
The Truman Kansas City Kansas City, MO
Feb 21, 9:00 pm 2018
Wednesday
Feb 21
9:00 pm
Brockhampton
The Truman, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 1131
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Brockhampton
Ogden Theatre Denver Denver, CO
Feb 22, 9:00 pm 2018
Thursday
Feb 22
9:00 pm
Brockhampton
Ogden Theatre, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 3946
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
Brockhampton
The Depot Salt Lake City Salt Lake City, UT
Feb 24, 9:00 pm 2018
Saturday
Feb 24
9:00 pm
Brockhampton
The Depot, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 1692
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
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
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football
NOUVELLES - SPORT