LISTE POUR : Perturbator

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

April

Perturbator
Trees Dallas Dallas, TX
Apr 24, 8:00 pm 2019
Wednesday
Apr 24
8:00 pm
Perturbator
Trees, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 33545
SELECT * from toolcitypagelink WHERE cityname = 'Austin'
Perturbator
Come and Take It Live Austin Austin, TX
Apr 25, 7:00 pm 2019
Thursday
Apr 25
7:00 pm
Perturbator
Come and Take It Live, Austin, TX
SELECT * from toolvenuepagelink WHERE venueid = 33775
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
Perturbator
Music Box Supper Club Cleveland Cleveland, OH
Apr 28, 8:30 pm 2019
Sunday
Apr 28
8:30 pm
Perturbator
Music Box Supper Club, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 9486
SELECT * from toolcitypagelink WHERE cityname = 'Oakland'
Perturbator
Oakland Metro Operahouse Oakland Oakland, CA
Apr 30, 8:00 pm 2019
Tuesday
Apr 30
8:00 pm
Perturbator
Oakland Metro Operahouse, Oakland, CA
SELECT * from toolvenuepagelink WHERE venueid = 4336
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'

May

Perturbator
Neumos Seattle Seattle, WA
May 2, 8:00 pm 2019
Thursday
May 2
8:00 pm
Perturbator
Neumos, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 9124
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Perturbator
Rickshaw Theatre Vancouver Vancouver, BC
May 3, 8:00 pm 2019
Friday
May 3
8:00 pm
Perturbator
Rickshaw Theatre, Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 16317
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Perturbator
Star Theater Portland Portland, OR
May 4, 9:00 pm 2019
Saturday
May 4
9:00 pm
Perturbator
Star Theater, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 1551
SELECT * from toolcitypagelink WHERE cityname = 'Jackson'
Perturbator
Thalia Mara Hall Jackson Jackson, MS
May 9, 8:30 pm 2019
Thursday
May 9
8:30 pm
Perturbator
Thalia Mara Hall, Jackson, MS
SELECT * from toolvenuepagelink WHERE venueid = 28100
SELECT * from toolcitypagelink WHERE cityname = 'Grand Rapids'
Perturbator
The Pyramid Scheme Grand Rapids Grand Rapids, MI
May 11, 8:00 pm 2019
Saturday
May 11
8:00 pm
Perturbator
The Pyramid Scheme, Grand Rapids, MI
SELECT * from toolvenuepagelink WHERE venueid = 2885
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Perturbator
Phoenix Concert Theatre Toronto Toronto, ON
May 12, 7:00 pm 2019
Sunday
May 12
7:00 pm
Perturbator
Phoenix Concert Theatre, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 1603
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
Perturbator
Trocadero Philadelphia Philadelphia, PA
May 15, 8:00 pm 2019
Wednesday
May 15
8:00 pm
Perturbator
Trocadero, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 725
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Perturbator
Irving Plaza New York New York, NY
May 16, 7:00 pm 2019
Thursday
May 16
7:00 pm
Perturbator
Irving Plaza, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 31934
SELECT * from toolcitypagelink WHERE cityname = 'Richmond'
Perturbator
The Broadberry Richmond Richmond, VA
May 17, 8:00 pm 2019
Friday
May 17
8:00 pm
Perturbator
The Broadberry, Richmond, VA
SELECT * from toolvenuepagelink WHERE venueid = 1670
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Perturbator
Variety Playhouse Atlanta Atlanta, GA
May 18, 9:00 pm 2019
Saturday
May 18
9:00 pm
Perturbator
Variety Playhouse, Atlanta, GA
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football