LISTE POUR : Missio

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

April

Missio
Crescent Ballroom - AZ Phoenix Phoenix, AZ
Apr 2, 8:00 pm 2019
Tuesday
Apr 2
8:00 pm
Missio
Crescent Ballroom - AZ, Phoenix, AZ
SELECT * from toolvenuepagelink WHERE venueid = 7114
SELECT * from toolcitypagelink WHERE cityname = 'San Diego'
Missio
Music Box - San Diego San Diego San Diego, CA
Apr 3, 7:30 pm 2019
Wednesday
Apr 3
7:30 pm
Missio
Music Box - San Diego, San Diego, CA
SELECT * from toolvenuepagelink WHERE venueid = 442
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Missio
El Rey Theatre Los Angeles Los Angeles, CA
Apr 4, 8:00 pm 2019
Thursday
Apr 4
8:00 pm
Missio
El Rey Theatre, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 3365
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Missio
The Independent San Francisco San Francisco, CA
Apr 6, 9:00 pm 2019
Saturday
Apr 6
9:00 pm
Missio
The Independent, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 4829
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Missio
Hawthorne Theatre Portland Portland, OR
Apr 8, 7:30 pm 2019
Monday
Apr 8
7:30 pm
Missio
Hawthorne Theatre, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 4336
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Missio
Neumos Seattle Seattle, WA
Apr 10, 8:00 pm 2019
Wednesday
Apr 10
8:00 pm
Missio
Neumos, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 7810
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Missio
Summit Music Hall Denver Denver, CO
Apr 13, 8:00 pm 2019
Saturday
Apr 13
8:00 pm
Missio
Summit Music Hall, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 4745
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Missio
The Record Bar Kansas City Kansas City, MO
Apr 15, 7:30 pm 2019
Monday
Apr 15
7:30 pm
Missio
The Record Bar, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 28883
SELECT * from toolcitypagelink WHERE cityname = 'Saint Paul'
Missio
Amsterdam Bar and Hall Saint Paul Saint Paul, MN
Apr 16, 8:00 pm 2019
Tuesday
Apr 16
8:00 pm
Missio
Amsterdam Bar and Hall, Saint Paul, MN
SELECT * from toolvenuepagelink WHERE venueid = 2283
SELECT * from toolcitypagelink WHERE cityname = 'Milwaukee'
Missio
Rave-Eagles Ballroom Milwaukee Milwaukee, WI
Apr 18, 7:30 pm 2019
Thursday
Apr 18
7:30 pm
Missio
Rave-Eagles Ballroom, Milwaukee, WI
SELECT * from toolvenuepagelink WHERE venueid = 1371
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
Missio
St. Andrews Hall Detroit Detroit, MI
Apr 19, 7:00 pm 2019
Friday
Apr 19
7:00 pm
Missio
St. Andrews Hall, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 2164
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Missio
Metro Smart Bar Chicago Chicago, IL
Apr 20, 9:00 pm 2019
Saturday
Apr 20
9:00 pm
Missio
Metro Smart Bar, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 6716
SELECT * from toolcitypagelink WHERE cityname = 'St Louis'
Missio
The Firebird St Louis St Louis, MO
Apr 22, 8:00 pm 2019
Monday
Apr 22
8:00 pm
Missio
The Firebird, St Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 3142
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Missio
Mod Club Theatre Toronto Toronto, ON
Apr 25, 7:00 pm 2019
Thursday
Apr 25
7:00 pm
Missio
Mod Club Theatre, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 32982
SELECT * from toolcitypagelink WHERE cityname = 'Montréal'
Missio
Theatre Fairmount Montréal Montréal, QC
Apr 26, 8:00 pm 2019
Friday
Apr 26
8:00 pm
Missio
Theatre Fairmount, Montréal, QC
SELECT * from toolvenuepagelink WHERE venueid = 31549
SELECT * from toolcitypagelink WHERE cityname = 'Cambridge'
Missio
The Sinclair Cambridge Cambridge, MA
Apr 27, 8:00 pm 2019
Saturday
Apr 27
8:00 pm
Missio
The Sinclair, Cambridge, MA
SELECT * from toolvenuepagelink WHERE venueid = 1822
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Missio
Bowery Ballroom New York New York, NY
Apr 30, 7:00 pm 2019
Tuesday
Apr 30
7:00 pm
Missio
Bowery Ballroom, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 5383
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'

May

Missio
First Unitarian Church Philadelphia Philadelphia, PA
May 1, 7:30 pm 2019
Wednesday
May 1
7:30 pm
Missio
First Unitarian Church, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 1959
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Missio
9:30 Club Washington Washington, DC
May 2, 7:00 pm 2019
Thursday
May 2
7:00 pm
Missio
9:30 Club, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 6693
SELECT * from toolcitypagelink WHERE cityname = 'Charlotte'
Missio
The Underground - Fillmore Charlotte Charlotte Charlotte, NC
May 3, 8:00 pm 2019
Friday
May 3
8:00 pm
Missio
The Underground - Fillmore Charlotte, Charlotte, NC
SELECT * from toolvenuepagelink WHERE venueid = 28769
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
Missio
The Basement - TN Nashville Nashville, TN
May 7, 8:00 pm 2019
Tuesday
May 7
8:00 pm
Missio
The Basement - TN, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 33702
SELECT * from toolcitypagelink WHERE cityname = 'Oklahoma City'
Missio
Tower Theatre - OKC Oklahoma City Oklahoma City, OK
May 9, 7:30 pm 2019
Thursday
May 9
7:30 pm
Missio
Tower Theatre - OKC, Oklahoma City, OK
SELECT * from toolvenuepagelink WHERE venueid = 2171
SELECT * from toolcitypagelink WHERE cityname = 'Austin'
Missio
Emo's East Austin Austin, TX
May 10, 7:00 pm 2019
Friday
May 10
7:00 pm
Missio
Emo's East, Austin, TX
SELECT * from toolvenuepagelink WHERE venueid = 2329
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Missio
Granada Theater - TX Dallas Dallas, TX
May 11, 8:00 pm 2019
Saturday
May 11
8:00 pm
Missio
Granada Theater - TX, Dallas, TX
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football