LISTE POUR : High On Fire

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

January

High On Fire (Canceled)
Metro Smart Bar Chicago Chicago, IL
Jan 22, 8:00 pm 2019
Tuesday
Jan 22
8:00 pm
High On Fire (Canceled)
Metro Smart Bar, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 27854
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
High On Fire (Canceled)
The Oriental Theater Denver Denver, CO
Jan 25, 8:00 pm 2019
Friday
Jan 25
8:00 pm
High On Fire (Canceled)
The Oriental Theater, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 4862
SELECT * from toolcitypagelink WHERE cityname = 'Omaha'
High On Fire (Canceled)
Slowdown Omaha Omaha, NE
Jan 26, 8:00 pm 2019
Saturday
Jan 26
8:00 pm
High On Fire (Canceled)
Slowdown, Omaha, NE
SELECT * from toolvenuepagelink WHERE venueid = 1862
SELECT * from toolcitypagelink WHERE cityname = 'St Louis'
High On Fire (Canceled)
Delmar Hall St Louis St Louis, MO
Jan 27, 8:00 pm 2019
Sunday
Jan 27
8:00 pm
High On Fire (Canceled)
Delmar Hall, St Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 31921
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
High On Fire (Canceled)
Gas Monkey Live Dallas Dallas, TX
Jan 29, 8:00 pm 2019
Tuesday
Jan 29
8:00 pm
High On Fire (Canceled)
Gas Monkey Live, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 32931
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
High On Fire (Canceled)
White Oak Music Hall Houston Houston, TX
Jan 31, 7:00 pm 2019
Thursday
Jan 31
7:00 pm
High On Fire (Canceled)
White Oak Music Hall, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 1936
SELECT * from toolcitypagelink WHERE cityname = 'New Orleans'

February

High On Fire (Canceled)
House of Blues - New Orleans New Orleans New Orleans, LA
Feb 1, 7:00 pm 2019
Friday
Feb 1
7:00 pm
High On Fire (Canceled)
House of Blues - New Orleans, New Orleans, LA
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football