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 = 3554
SELECT * from toolcitypagelink WHERE cityname = 'Albuquerque'

December

Machine Head
Sunshine Theatre Albuquerque Albuquerque, NM
Dec 27, 7:00 pm 2017
Wednesday
Dec 27
7:00 pm
Machine Head
Sunshine Theatre, Albuquerque, NM
SELECT * from toolvenuepagelink WHERE venueid = 5099
SELECT * from toolcitypagelink WHERE cityname = 'Mesa'

January

Machine Head
Nile Theater Mesa Mesa, AZ
Jan 25, 8:00 pm 2018
Thursday
Jan 25
8:00 pm
Machine Head
Nile Theater, Mesa, AZ
SELECT * from toolvenuepagelink WHERE venueid = 3554
SELECT * from toolcitypagelink WHERE cityname = 'Albuquerque'
Machine Head
Sunshine Theatre Albuquerque Albuquerque, NM
Jan 27, 8:00 pm 2018
Saturday
Jan 27
8:00 pm
Machine Head
Sunshine Theatre, Albuquerque, NM
SELECT * from toolvenuepagelink WHERE venueid = 30567
SELECT * from toolcitypagelink WHERE cityname = 'San Antonio'
Machine Head
Aztec Theater San Antonio San Antonio, TX
Jan 29, 8:00 pm 2018
Monday
Jan 29
8:00 pm
Machine Head
Aztec Theater, San Antonio, TX
SELECT * from toolvenuepagelink WHERE venueid = 30770
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Machine Head
Gas Monkey Bar N’ Grill Dallas Dallas, TX
Jan 30, 8:00 pm 2018
Tuesday
Jan 30
8:00 pm
Machine Head
Gas Monkey Bar N’ Grill, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 5679
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
Machine Head
House of Blues - Houston Houston Houston, TX
Jan 31, 8:00 pm 2018
Wednesday
Jan 31
8:00 pm
Machine Head
House of Blues - Houston, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 32290
SELECT * from toolcitypagelink WHERE cityname = 'Birmingham'

February

Machine Head
Saturn Birmingham Birmingham, AL
Feb 2, 8:00 pm 2018
Friday
Feb 2
8:00 pm
Machine Head
Saturn, Birmingham, AL
SELECT * from toolvenuepagelink WHERE venueid = 5075
SELECT * from toolcitypagelink WHERE cityname = 'Orlando'
Machine Head
The Plaza 'Live' Theatre Orlando Orlando, FL
Feb 5, 8:00 pm 2018
Monday
Feb 5
8:00 pm
Machine Head
The Plaza 'Live' Theatre, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 2298
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Machine Head
Center Stage Theatre - GA Atlanta Atlanta, GA
Feb 6, 8:00 pm 2018
Tuesday
Feb 6
8:00 pm
Machine Head
Center Stage Theatre - GA, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 856
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
Machine Head
Theatre of Living Arts Philadelphia Philadelphia, PA
Feb 8, 8:00 pm 2018
Thursday
Feb 8
8:00 pm
Machine Head
Theatre of Living Arts, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 3649
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Machine Head
Playstation Theater New York New York, NY
Feb 9, 8:00 pm 2018
Friday
Feb 9
8:00 pm
Machine Head
Playstation Theater, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 2254
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Machine Head
Paradise Rock Club Boston Boston, MA
Feb 10, 8:00 pm 2018
Saturday
Feb 10
8:00 pm
Machine Head
Paradise Rock Club, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 304
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Machine Head
Club Soda Montreal Montreal, QC
Feb 11, 8:00 pm 2018
Sunday
Feb 11
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 2992
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Machine Head
Danforth Music Hall Toronto Toronto, ON
Feb 13, 7:00 pm 2018
Tuesday
Feb 13
7:00 pm
Machine Head
Danforth Music Hall, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 4492
SELECT * from toolcitypagelink WHERE cityname = 'Buffalo'
Machine Head
Town Ballroom Buffalo Buffalo, NY
Feb 14, 7:00 pm 2018
Wednesday
Feb 14
7:00 pm
Machine Head
Town Ballroom, Buffalo, NY
SELECT * from toolvenuepagelink WHERE venueid = 7725
SELECT * from toolcitypagelink WHERE cityname = 'Pittsburgh'
Machine Head
Stage AE Pittsburgh Pittsburgh, PA
Feb 15, 7:00 pm 2018
Thursday
Feb 15
7:00 pm
Machine Head
Stage AE, Pittsburgh, PA
SELECT * from toolvenuepagelink WHERE venueid = 15
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
Machine Head
Agora Theatre Cleveland Cleveland, OH
Feb 16, 7:00 pm 2018
Friday
Feb 16
7:00 pm
Machine Head
Agora Theatre, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 905
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
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
NOUVELLES - SPORT