LISTE POUR : My Favorite Murder

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

January

My Favorite Murder
The Met Philadelphia Philadelphia, PA
Jan 31, 8:00 pm 2019
Thursday
Jan 31
8:00 pm
My Favorite Murder
The Met, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 2019
SELECT * from toolcitypagelink WHERE cityname = 'Baltimore'

February

My Favorite Murder
Modell Performing Arts Center At The Lyric Baltimore Baltimore, MD
Feb 1, 8:00 pm 2019
Friday
Feb 1
8:00 pm
My Favorite Murder
Modell Performing Arts Center At The Lyric, Baltimore, MD
SELECT * from toolvenuepagelink WHERE venueid = 1825
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
My Favorite Murder
DAR Constitution Hall Washington Washington, DC
Feb 2, 8:00 pm 2019
Saturday
Feb 2
8:00 pm
My Favorite Murder
DAR Constitution Hall, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 4394
SELECT * from toolcitypagelink WHERE cityname = 'Honolulu'
My Favorite Murder
Neal S Blaisdell Concert Hall Honolulu Honolulu, HI
Feb 8, 8:00 pm 2019
Friday
Feb 8
8:00 pm
My Favorite Murder
Neal S Blaisdell Concert Hall, Honolulu, HI
SELECT * from toolvenuepagelink WHERE venueid = 526
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
My Favorite Murder
Fox Theatre Detroit Detroit Detroit, MI
Feb 22, 8:00 pm 2019
Friday
Feb 22
8:00 pm
My Favorite Murder
Fox Theatre Detroit, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 690
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
My Favorite Murder
Sony Centre for the Performing Arts Toronto Toronto, ON
Feb 23, 8:00 pm 2019
Saturday
Feb 23
8:00 pm
My Favorite Murder
Sony Centre for the Performing Arts, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 690
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
My Favorite Murder
Sony Centre for the Performing Arts Toronto Toronto, ON
Feb 24, 8:00 pm 2019
Sunday
Feb 24
8:00 pm
My Favorite Murder
Sony Centre for the Performing Arts, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 33368
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'

March

My Favorite Murder
Park Theater Las Vegas Las Vegas, NV
Mar 9, 8:00 pm 2019
Saturday
Mar 9
8:00 pm
My Favorite Murder
Park Theater, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 135
SELECT * from toolcitypagelink WHERE cityname = 'Pittsburgh'
My Favorite Murder
Benedum Center Pittsburgh Pittsburgh, PA
Mar 14, 8:00 pm 2019
Thursday
Mar 14
8:00 pm
My Favorite Murder
Benedum Center, Pittsburgh, PA
SELECT * from toolvenuepagelink WHERE venueid = 135
SELECT * from toolcitypagelink WHERE cityname = 'Pittsburgh'
My Favorite Murder
Benedum Center Pittsburgh Pittsburgh, PA
Mar 15, 8:00 pm 2019
Friday
Mar 15
8:00 pm
My Favorite Murder
Benedum Center, Pittsburgh, PA
SELECT * from toolvenuepagelink WHERE venueid = 1263
SELECT * from toolcitypagelink WHERE cityname = 'Cincinnati'
My Favorite Murder
Procter and Gamble Hall - Aronoff Center Cincinnati Cincinnati, OH
Mar 16, 8:00 pm 2019
Saturday
Mar 16
8:00 pm
My Favorite Murder
Procter and Gamble Hall - Aronoff Center, Cincinnati, OH
SELECT * from toolvenuepagelink WHERE venueid = 1062
SELECT * from toolcitypagelink WHERE cityname = 'Indianapolis'
My Favorite Murder
Murat Theatre Indianapolis Indianapolis, IN
Mar 17, 8:00 pm 2019
Sunday
Mar 17
8:00 pm
My Favorite Murder
Murat Theatre, Indianapolis, IN
SELECT * from toolvenuepagelink WHERE venueid = 1005
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
My Favorite Murder
Arvest Bank Theatre at The Midland Kansas City Kansas City, MO
Mar 22, 8:00 pm 2019
Friday
Mar 22
8:00 pm
My Favorite Murder
Arvest Bank Theatre at The Midland, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 402
SELECT * from toolcitypagelink WHERE cityname = 'Des Moines'
My Favorite Murder
Des Moines Civic Center Des Moines Des Moines, IA
Mar 23, 8:00 pm 2019
Saturday
Mar 23
8:00 pm
My Favorite Murder
Des Moines Civic Center, Des Moines, IA
SELECT * from toolvenuepagelink WHERE venueid = 1162
SELECT * from toolcitypagelink WHERE cityname = 'Omaha'
My Favorite Murder
Orpheum Theatre - Omaha Omaha Omaha, NE
Mar 24, 8:00 pm 2019
Sunday
Mar 24
8:00 pm
My Favorite Murder
Orpheum Theatre - Omaha, Omaha, NE
SELECT * from toolvenuepagelink WHERE venueid = 7648
SELECT * from toolcitypagelink WHERE cityname = 'Phoenix'

April

My Favorite Murder
Comerica Theatre Phoenix Phoenix, AZ
Apr 5, 8:00 pm 2019
Friday
Apr 5
8:00 pm
My Favorite Murder
Comerica Theatre, Phoenix, AZ
SELECT * from toolvenuepagelink WHERE venueid = 3358
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
My Favorite Murder
Bellco Theatre Denver Denver, CO
Apr 6, 8:00 pm 2019
Saturday
Apr 6
8:00 pm
My Favorite Murder
Bellco Theatre, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 596
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
My Favorite Murder
Grand Ole Opry House Nashville Nashville, TN
Apr 18, 8:00 pm 2019
Thursday
Apr 18
8:00 pm
My Favorite Murder
Grand Ole Opry House, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 30051
SELECT * from toolcitypagelink WHERE cityname = 'Louisville'
My Favorite Murder
W. L. Lyons Brown Theatre Louisville Louisville, KY
Apr 19, 8:00 pm 2019
Friday
Apr 19
8:00 pm
My Favorite Murder
W. L. Lyons Brown Theatre, Louisville, KY
SELECT * from toolvenuepagelink WHERE venueid = 7818
SELECT * from toolcitypagelink WHERE cityname = 'St Louis'
My Favorite Murder
Stifel Theatre St Louis St Louis, MO
Apr 20, 8:00 pm 2019
Saturday
Apr 20
8:00 pm
My Favorite Murder
Stifel Theatre, St Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 2143
SELECT * from toolcitypagelink WHERE cityname = 'Oklahoma City'

May

My Favorite Murder
Civic Center Music Hall Oklahoma City Oklahoma City, OK
May 2, 8:00 pm 2019
Thursday
May 2
8:00 pm
My Favorite Murder
Civic Center Music Hall, Oklahoma City, OK
SELECT * from toolvenuepagelink WHERE venueid = 33353
SELECT * from toolcitypagelink WHERE cityname = 'Sugar Land'
My Favorite Murder
Smart Financial Centre Sugar Land Sugar Land, TX
May 3, 8:00 pm 2019
Friday
May 3
8:00 pm
My Favorite Murder
Smart Financial Centre, Sugar Land, TX
SELECT * from toolvenuepagelink WHERE venueid = 33479
SELECT * from toolcitypagelink WHERE cityname = 'Irving'
My Favorite Murder
The Pavilion at Irving Music Factory Irving Irving, TX
May 4, 8:00 pm 2019
Saturday
May 4
8:00 pm
My Favorite Murder
The Pavilion at Irving Music Factory, Irving, TX
SELECT * from toolvenuepagelink WHERE venueid = 33479
SELECT * from toolcitypagelink WHERE cityname = 'Irving'
My Favorite Murder
The Pavilion at Irving Music Factory Irving Irving, TX
May 5, 8:00 pm 2019
Sunday
May 5
8:00 pm
My Favorite Murder
The Pavilion at Irving Music Factory, Irving, TX
SELECT * from toolvenuepagelink WHERE venueid = 1322
SELECT * from toolcitypagelink WHERE cityname = 'Milwaukee'
My Favorite Murder
Riverside Theatre - WI Milwaukee Milwaukee, WI
May 16, 8:00 pm 2019
Thursday
May 16
8:00 pm
My Favorite Murder
Riverside Theatre - WI, Milwaukee, WI
SELECT * from toolvenuepagelink WHERE venueid = 1322
SELECT * from toolcitypagelink WHERE cityname = 'Milwaukee'
My Favorite Murder
Riverside Theatre - WI Milwaukee Milwaukee, WI
May 17, 8:00 pm 2019
Friday
May 17
8:00 pm
My Favorite Murder
Riverside Theatre - WI, Milwaukee, WI
SELECT * from toolvenuepagelink WHERE venueid = 1121
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
My Favorite Murder
Northrop Auditorium Minneapolis Minneapolis, MN
May 18, 8:00 pm 2019
Saturday
May 18
8:00 pm
My Favorite Murder
Northrop Auditorium, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 1121
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
My Favorite Murder
Northrop Auditorium Minneapolis Minneapolis, MN
May 19, 8:00 pm 2019
Sunday
May 19
8:00 pm
My Favorite Murder
Northrop Auditorium, Minneapolis, MN
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football