LISTE POUR : FKJ

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

April

FKJ
Vogue Theatre Vancouver Vancouver, BC
Apr 4, 8:00 pm 2019
Thursday
Apr 4
8:00 pm
FKJ
Vogue Theatre, Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 1945
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
FKJ
Commodore Ballroom Vancouver Vancouver, BC
Apr 5, 8:00 pm 2019
Friday
Apr 5
8:00 pm
FKJ
Commodore Ballroom, Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 1419
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
FKJ
The Showbox Seattle Seattle, WA
Apr 6, 9:00 pm 2019
Saturday
Apr 6
9:00 pm
FKJ
The Showbox, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 1419
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
FKJ
The Showbox Seattle Seattle, WA
Apr 7, 9:00 pm 2019
Sunday
Apr 7
9:00 pm
FKJ
The Showbox, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 2395
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
FKJ
McMenamins Crystal Ballroom Portland Portland, OR
Apr 8, 8:00 pm 2019
Monday
Apr 8
8:00 pm
FKJ
McMenamins Crystal Ballroom, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 1708
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
FKJ
The Warfield San Francisco San Francisco, CA
Apr 10, 8:00 pm 2019
Wednesday
Apr 10
8:00 pm
FKJ
The Warfield, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 1708
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
FKJ
The Warfield San Francisco San Francisco, CA
Apr 11, 8:00 pm 2019
Thursday
Apr 11
8:00 pm
FKJ
The Warfield, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 2624
SELECT * from toolcitypagelink WHERE cityname = 'Tempe'
FKJ
Marquee Theatre Tempe Tempe, AZ
Apr 23, 9:00 pm 2019
Tuesday
Apr 23
9:00 pm
FKJ
Marquee Theatre, Tempe, AZ
SELECT * from toolvenuepagelink WHERE venueid = 2171
SELECT * from toolcitypagelink WHERE cityname = 'Austin'
FKJ
Emo's East Austin Austin, TX
Apr 25, 8:00 pm 2019
Thursday
Apr 25
8:00 pm
FKJ
Emo's East, Austin, TX
SELECT * from toolvenuepagelink WHERE venueid = 33701
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
FKJ
Canton Hall Dallas Dallas, TX
Apr 26, 8:00 pm 2019
Friday
Apr 26
8:00 pm
FKJ
Canton Hall, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 3762
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
FKJ
Warehouse Live Houston Houston, TX
Apr 27, 8:00 pm 2019
Saturday
Apr 27
8:00 pm
FKJ
Warehouse Live, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 26926
SELECT * from toolcitypagelink WHERE cityname = 'New Orleans'
FKJ
Republic New Orleans New Orleans New Orleans, LA
Apr 29, 9:00 pm 2019
Monday
Apr 29
9:00 pm
FKJ
Republic New Orleans, New Orleans, LA
SELECT * from toolvenuepagelink WHERE venueid = 1670
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'

May

FKJ
Variety Playhouse Atlanta Atlanta, GA
May 1, 8:30 pm 2019
Wednesday
May 1
8:30 pm
FKJ
Variety Playhouse, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 5075
SELECT * from toolcitypagelink WHERE cityname = 'Orlando'
FKJ
The Plaza 'Live' Theatre Orlando Orlando, FL
May 2, 8:00 pm 2019
Thursday
May 2
8:00 pm
FKJ
The Plaza 'Live' Theatre, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 8167
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
FKJ
The Orpheum - Tampa Tampa Tampa, FL
May 3, 8:00 pm 2019
Friday
May 3
8:00 pm
FKJ
The Orpheum - Tampa, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 5552
SELECT * from toolcitypagelink WHERE cityname = 'Fort Lauderdale'
FKJ
Revolution Live Fort Lauderdale Fort Lauderdale, FL
May 4, 7:00 pm 2019
Saturday
May 4
7:00 pm
FKJ
Revolution Live, Fort Lauderdale, FL
SELECT * from toolvenuepagelink WHERE venueid = 1959
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
FKJ
9:30 Club Washington Washington, DC
May 8, 7:00 pm 2019
Wednesday
May 8
7:00 pm
FKJ
9:30 Club, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 7916
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
FKJ
Union Transfer Philadelphia Philadelphia, PA
May 9, 8:30 pm 2019
Thursday
May 9
8:30 pm
FKJ
Union Transfer, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 4954
SELECT * from toolcitypagelink WHERE cityname = 'New York'
FKJ
Terminal 5 New York New York, NY
May 11, 9:00 pm 2019
Saturday
May 11
9:00 pm
FKJ
Terminal 5, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 3427
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
FKJ
Royale Boston Boston Boston, MA
May 12, 8:00 pm 2019
Sunday
May 12
8:00 pm
FKJ
Royale Boston, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 33659
SELECT * from toolcitypagelink WHERE cityname = 'Ville-Marie, Montréal'
FKJ
MTELUS Ville-Marie, Montréal Ville-Marie, Montréal, QC
May 14, 9:00 pm 2019
Tuesday
May 14
9:00 pm
FKJ
MTELUS, Ville-Marie, Montréal, QC
SELECT * from toolvenuepagelink WHERE venueid = 2992
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
FKJ
Danforth Music Hall Toronto Toronto, ON
May 15, 7:00 pm 2019
Wednesday
May 15
7:00 pm
FKJ
Danforth Music Hall, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 905
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
FKJ
Majestic Theatre Detroit Detroit Detroit, MI
May 16, 8:00 pm 2019
Thursday
May 16
8:00 pm
FKJ
Majestic Theatre Detroit, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 7353
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
FKJ
V Live Chicago Chicago, IL
May 17, 8:00 pm 2019
Friday
May 17
8:00 pm
FKJ
V Live, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 30272
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
FKJ
Concord Music Hall Chicago Chicago, IL
May 17, 8:00 pm 2019
Friday
May 17
8:00 pm
FKJ
Concord Music Hall, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 30137
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
FKJ
Skyway Theater Minneapolis Minneapolis, MN
May 18, 7:00 pm 2019
Saturday
May 18
7:00 pm
FKJ
Skyway Theater, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 1131
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
FKJ
Ogden Theatre Denver Denver, CO
May 20, 9:00 pm 2019
Monday
May 20
9:00 pm
FKJ
Ogden Theatre, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 1131
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
FKJ
Ogden Theatre Denver Denver, CO
May 21, 9:00 pm 2019
Tuesday
May 21
9:00 pm
FKJ
Ogden Theatre, Denver, CO
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football