LISTE POUR : Machine Head

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

February

Machine Head
Majestic Theatre Detroit Detroit Detroit, MI
Feb 17, 7:00 pm 2018
Saturday
Feb 17
7:00 pm
Machine Head
Majestic Theatre Detroit, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 28856
SELECT * from toolcitypagelink WHERE cityname = 'Des Moines'
Machine Head
Wooly's Des Moines Des Moines, IA
Feb 20, 8:00 pm 2018
Tuesday
Feb 20
8:00 pm
Machine Head
Wooly's, Des Moines, IA
SELECT * from toolvenuepagelink WHERE venueid = 4106
SELECT * from toolcitypagelink WHERE cityname = 'Madison'
Machine Head
Majestic Theatre Madison Madison, WI
Feb 21, 8:30 pm 2018
Wednesday
Feb 21
8:30 pm
Machine Head
Majestic Theatre, Madison, WI
SELECT * from toolvenuepagelink WHERE venueid = 496
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
Machine Head
First Avenue Minneapolis Minneapolis, MN
Feb 22, 8:00 pm 2018
Thursday
Feb 22
8:00 pm
Machine Head
First Avenue, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 30272
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Machine Head
Concord Music Hall Chicago Chicago, IL
Feb 23, 7:00 pm 2018
Friday
Feb 23
7:00 pm
Machine Head
Concord Music Hall, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 3955
SELECT * from toolcitypagelink WHERE cityname = 'Sauget'
Machine Head
Pops Sauget Sauget, IL
Feb 24, 8:00 pm 2018
Saturday
Feb 24
8:00 pm
Machine Head
Pops, Sauget, IL
SELECT * from toolvenuepagelink WHERE venueid = 7810
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Machine Head
Summit Music Hall Denver Denver, CO
Feb 27, 8:00 pm 2018
Tuesday
Feb 27
8:00 pm
Machine Head
Summit Music Hall, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 682
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'

March

Machine Head
House of Blues - Las Vegas Las Vegas Las Vegas, NV
Mar 1, 8:00 pm 2018
Thursday
Mar 1
8:00 pm
Machine Head
House of Blues - Las Vegas, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 651
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Machine Head
Henry Fonda Theatre Los Angeles Los Angeles, CA
Mar 2, 8:00 pm 2018
Friday
Mar 2
8:00 pm
Machine Head
Henry Fonda Theatre, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 6169
SELECT * from toolcitypagelink WHERE cityname = 'Oakland'
Machine Head
Fox Theater - Oakland Oakland Oakland, CA
Mar 3, 8:00 pm 2018
Saturday
Mar 3
8:00 pm
Machine Head
Fox Theater - Oakland, Oakland, CA
SELECT * from toolvenuepagelink WHERE venueid = 2135
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Machine Head
Roseland Theater Portland Portland, OR
Mar 5, 8:00 pm 2018
Monday
Mar 5
8:00 pm
Machine Head
Roseland Theater, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 1945
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Machine Head
Commodore Ballroom Vancouver Vancouver, BC
Mar 6, 7:00 pm 2018
Tuesday
Mar 6
7:00 pm
Machine Head
Commodore Ballroom, Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 1419
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Machine Head
The Showbox Seattle Seattle, WA
Mar 7, 8:00 pm 2018
Wednesday
Mar 7
8:00 pm
Machine Head
The Showbox, Seattle, WA
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football