LISTE POUR : Magic Giant

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

January

Magic Giant
Crescent Ballroom - AZ Phoenix Phoenix, AZ
Jan 23, 7:30 pm 2019
Wednesday
Jan 23
7:30 pm
Magic Giant
Crescent Ballroom - AZ, Phoenix, AZ
SELECT * from toolvenuepagelink WHERE venueid = 32057
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Magic Giant
Dada Dallas Dallas Dallas, TX
Jan 25, 9:00 pm 2019
Friday
Jan 25
9:00 pm
Magic Giant
Dada Dallas, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 2483
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
Magic Giant with Castlecomer
Exit/In Nashville Nashville, TN
Jan 28, 9:00 pm 2019
Monday
Jan 28
9:00 pm
Magic Giant with Castlecomer
Exit/In, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 3837
SELECT * from toolcitypagelink WHERE cityname = 'Orlando'
Magic Giant
The Social Orlando Orlando, FL
Jan 31, 7:00 pm 2019
Thursday
Jan 31
7:00 pm
Magic Giant
The Social, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 33004
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'

February

Magic Giant
Velvet Underground - Toronto Toronto Toronto, ON
Feb 12, 6:30 pm 2019
Tuesday
Feb 12
6:30 pm
Magic Giant
Velvet Underground - Toronto, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 33149
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
Magic Giant
El Club Detroit Detroit, MI
Feb 13, 9:00 pm 2019
Wednesday
Feb 13
9:00 pm
Magic Giant
El Club, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 19289
SELECT * from toolcitypagelink WHERE cityname = 'Indianapolis'
Magic Giant
Deluxe at Old National Centre Indianapolis Indianapolis, IN
Feb 14, 7:00 pm 2019
Thursday
Feb 14
7:00 pm
Magic Giant
Deluxe at Old National Centre, Indianapolis, IN
SELECT * from toolvenuepagelink WHERE venueid = 32411
SELECT * from toolcitypagelink WHERE cityname = 'Indianapolis'
Magic Giant
The Hi-Fi Indianapolis Indianapolis, IN
Feb 14, 7:00 pm 2019
Thursday
Feb 14
7:00 pm
Magic Giant
The Hi-Fi, Indianapolis, IN
SELECT * from toolvenuepagelink WHERE venueid = 78
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Magic Giant
Athenaeum Theatre Chicago Chicago, IL
Feb 16, 8:00 pm 2019
Saturday
Feb 16
8:00 pm
Magic Giant
Athenaeum Theatre, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 34011
SELECT * from toolcitypagelink WHERE cityname = 'Columbus'
Magic Giant
Columbus Athenaeum Columbus Columbus, OH
Feb 16, 8:00 pm 2019
Saturday
Feb 16
8:00 pm
Magic Giant
Columbus Athenaeum, Columbus, OH
SELECT * from toolvenuepagelink WHERE venueid = 610
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
Magic Giant with Castlecomer
Grog Shop Cleveland Cleveland, OH
Feb 19, 7:30 pm 2019
Tuesday
Feb 19
7:30 pm
Magic Giant with Castlecomer
Grog Shop, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 3523
SELECT * from toolcitypagelink WHERE cityname = 'Covington'
Magic Giant
Madison Theater Covington Covington, KY
Feb 20, 8:00 pm 2019
Wednesday
Feb 20
8:00 pm
Magic Giant
Madison Theater, Covington, KY
SELECT * from toolvenuepagelink WHERE venueid = 12054
SELECT * from toolcitypagelink WHERE cityname = 'St Louis'
Magic Giant
Off Broadway St Louis St Louis, MO
Feb 21, 7:00 pm 2019
Thursday
Feb 21
7:00 pm
Magic Giant
Off Broadway, St Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 33097
SELECT * from toolcitypagelink WHERE cityname = 'Milwaukee'
Magic Giant
Colectivo Coffee - Prospect Café Milwaukee Milwaukee, WI
Feb 22, 7:00 pm 2019
Friday
Feb 22
7:00 pm
Magic Giant
Colectivo Coffee - Prospect Café, Milwaukee, WI
SELECT * from toolvenuepagelink WHERE venueid = 28883
SELECT * from toolcitypagelink WHERE cityname = 'Saint Paul'
Magic Giant
Amsterdam Bar and Hall Saint Paul Saint Paul, MN
Feb 23, 6:30 pm 2019
Saturday
Feb 23
6:30 pm
Magic Giant
Amsterdam Bar and Hall, Saint Paul, MN
SELECT * from toolvenuepagelink WHERE venueid = 30076
SELECT * from toolcitypagelink WHERE cityname = 'Missoula'
Magic Giant with Castlecomer
Top Hat Lounge & Casino Missoula Missoula, MT
Feb 26, 7:30 pm 2019
Tuesday
Feb 26
7:30 pm
Magic Giant with Castlecomer
Top Hat Lounge & Casino, Missoula, MT
SELECT * from toolvenuepagelink WHERE venueid = 3268
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Magic Giant
Crocodile Cafe Seattle Seattle, WA
Feb 27, 6:00 pm 2019
Wednesday
Feb 27
6:00 pm
Magic Giant
Crocodile Cafe, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 2395
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Magic Giant
McMenamins Crystal Ballroom Portland Portland, OR
Feb 28, 7:00 pm 2019
Thursday
Feb 28
7:00 pm
Magic Giant
McMenamins Crystal Ballroom, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 33752
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'

March

Magic Giant
August Hall San Francisco San Francisco, CA
Mar 1, 7:00 pm 2019
Friday
Mar 1
7:00 pm
Magic Giant
August Hall, San Francisco, CA
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football