LISTE POUR : Hayes Carll

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

March

Hayes Carll
Wooly's Des Moines Des Moines, IA
Mar 28, 9:00 pm 2019
Thursday
Mar 28
9:00 pm
Hayes Carll
Wooly's, Des Moines, IA
SELECT * from toolvenuepagelink WHERE venueid = 8089
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
Hayes Carll
Cedar Cultural Center Minneapolis Minneapolis, MN
Mar 29, 8:00 pm 2019
Friday
Mar 29
8:00 pm
Hayes Carll
Cedar Cultural Center, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 153
SELECT * from toolcitypagelink WHERE cityname = 'Ann Arbor Charter Township'
Hayes Carll
Blind Pig Ann Arbor Charter Township Ann Arbor Charter Township, MI
Mar 31, 8:00 pm 2019
Sunday
Mar 31
8:00 pm
Hayes Carll
Blind Pig, Ann Arbor Charter Township, MI
SELECT * from toolvenuepagelink WHERE venueid = 3142
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'

April

Hayes Carll
Mod Club Theatre Toronto Toronto, ON
Apr 1, 7:30 pm 2019
Monday
Apr 1
7:30 pm
Hayes Carll
Mod Club Theatre, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 1822
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Hayes Carll
Bowery Ballroom New York New York, NY
Apr 3, 8:00 pm 2019
Wednesday
Apr 3
8:00 pm
Hayes Carll
Bowery Ballroom, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 32083
SELECT * from toolcitypagelink WHERE cityname = 'Ardmore'
Hayes Carll
The Ardmore Music Hall Ardmore Ardmore, PA
Apr 4, 8:00 pm 2019
Thursday
Apr 4
8:00 pm
Hayes Carll
The Ardmore Music Hall, Ardmore, PA
SELECT * from toolvenuepagelink WHERE venueid = 3878
SELECT * from toolcitypagelink WHERE cityname = 'Pittsburgh'
Hayes Carll
Club Cafe Pittsburgh Pittsburgh, PA
Apr 5, 7:00 pm 2019
Friday
Apr 5
7:00 pm
Hayes Carll
Club Cafe, Pittsburgh, PA
SELECT * from toolvenuepagelink WHERE venueid = 4276
SELECT * from toolcitypagelink WHERE cityname = 'Louisville'
Hayes Carll
Headliners Music Hall Louisville Louisville, KY
Apr 10, 8:00 pm 2019
Wednesday
Apr 10
8:00 pm
Hayes Carll
Headliners Music Hall, Louisville, KY
SELECT * from toolvenuepagelink WHERE venueid = 28769
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
Hayes Carll
The Basement - TN Nashville Nashville, TN
Apr 11, 8:00 pm 2019
Thursday
Apr 11
8:00 pm
Hayes Carll
The Basement - TN, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 28994
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Hayes Carll
Terminal West Atlanta Atlanta, GA
Apr 12, 9:00 pm 2019
Friday
Apr 12
9:00 pm
Hayes Carll
Terminal West, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 159
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Hayes Carll
Bluebird Theater Denver Denver, CO
Apr 25, 8:00 pm 2019
Thursday
Apr 25
8:00 pm
Hayes Carll
Bluebird Theater, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 33877
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
Hayes Carll
The Commonwealth Room Salt Lake City Salt Lake City, UT
Apr 26, 9:00 pm 2019
Friday
Apr 26
9:00 pm
Hayes Carll
The Commonwealth Room, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 5648
SELECT * from toolcitypagelink WHERE cityname = 'Boise'
Hayes Carll
Neurolux Lounge Boise Boise, ID
Apr 27, 8:30 pm 2019
Saturday
Apr 27
8:30 pm
Hayes Carll
Neurolux Lounge, Boise, ID
SELECT * from toolvenuepagelink WHERE venueid = 8412
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Hayes Carll
Aladdin Theater Portland Portland, OR
Apr 30, 8:00 pm 2019
Tuesday
Apr 30
8:00 pm
Hayes Carll
Aladdin Theater, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 1926
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'

May

Hayes Carll
Great American Music Hall San Francisco San Francisco, CA
May 2, 8:00 pm 2019
Thursday
May 2
8:00 pm
Hayes Carll
Great American Music Hall, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 1606
SELECT * from toolcitypagelink WHERE cityname = 'West Hollywood'
Hayes Carll
Troubadour West Hollywood West Hollywood, CA
May 3, 8:00 pm 2019
Friday
May 3
8:00 pm
Hayes Carll
Troubadour, West Hollywood, CA
SELECT * from toolvenuepagelink WHERE venueid = 28863
SELECT * from toolcitypagelink WHERE cityname = 'Phoenix'
Hayes Carll
Crescent Ballroom - AZ Phoenix Phoenix, AZ
May 5, 8:00 pm 2019
Sunday
May 5
8:00 pm
Hayes Carll
Crescent Ballroom - AZ, Phoenix, AZ
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football