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

February

Hayes Carll
3Ten Austin City Limits Live Austin Austin, TX
Feb 22, 8:30 pm 2019
Friday
Feb 22
8:30 pm
Hayes Carll
3Ten Austin City Limits Live, Austin, TX
SELECT * from toolvenuepagelink WHERE venueid = 2849
SELECT * from toolcitypagelink WHERE cityname = 'Austin'
Hayes Carll
Antones Austin Austin, TX
Feb 23, 9:00 pm 2019
Saturday
Feb 23
9:00 pm
Hayes Carll
Antones, Austin, TX
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 = 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 = 1606
SELECT * from toolcitypagelink WHERE cityname = 'West Hollywood'

May

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
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football