LISTE POUR : Lord Huron

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

February

Lord Huron
London Music Hall - Ontario London London, ON
Feb 17, 7:00 pm 2019
Sunday
Feb 17
7:00 pm
Lord Huron
London Music Hall - Ontario, London, ON
SELECT * from toolvenuepagelink WHERE venueid = 33855
SELECT * from toolcitypagelink WHERE cityname = 'Chattanooga'

April

Lord Huron
The Signal Chattanooga Chattanooga, TN
Apr 12, 8:30 pm 2019
Friday
Apr 12
8:30 pm
Lord Huron
The Signal, Chattanooga, TN
SELECT * from toolvenuepagelink WHERE venueid = 3555
SELECT * from toolcitypagelink WHERE cityname = 'Raleigh'
Lord Huron
The Ritz Raleigh Raleigh, NC
Apr 14, 8:30 pm 2019
Sunday
Apr 14
8:30 pm
Lord Huron
The Ritz, Raleigh, NC
SELECT * from toolvenuepagelink WHERE venueid = 5177
SELECT * from toolcitypagelink WHERE cityname = 'Richmond'
Lord Huron
The National Richmond Richmond, VA
Apr 16, 7:30 pm 2019
Tuesday
Apr 16
7:30 pm
Lord Huron
The National, Richmond, VA
SELECT * from toolvenuepagelink WHERE venueid = 2232
SELECT * from toolcitypagelink WHERE cityname = 'Norfolk'
Lord Huron
The Norva Norfolk Norfolk, VA
Apr 17, 7:30 pm 2019
Wednesday
Apr 17
7:30 pm
Lord Huron
The Norva, Norfolk, VA
SELECT * from toolvenuepagelink WHERE venueid = 33988
SELECT * from toolcitypagelink WHERE cityname = 'Asheville'
Lord Huron
Highland Brewing Company Asheville Asheville, NC
Apr 19, 7:00 pm 2019
Friday
Apr 19
7:00 pm
Lord Huron
Highland Brewing Company, Asheville, NC
SELECT * from toolvenuepagelink WHERE venueid = 1555
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Lord Huron
The Tabernacle Atlanta Atlanta, GA
Apr 20, 8:00 pm 2019
Saturday
Apr 20
8:00 pm
Lord Huron
The Tabernacle, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 1366
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
Lord Huron
Ryman Auditorium Nashville Nashville, TN
Apr 21, 7:30 pm 2019
Sunday
Apr 21
7:30 pm
Lord Huron
Ryman Auditorium, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 1366
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
Lord Huron
Ryman Auditorium Nashville Nashville, TN
Apr 22, 7:30 pm 2019
Monday
Apr 22
7:30 pm
Lord Huron
Ryman Auditorium, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 869
SELECT * from toolcitypagelink WHERE cityname = 'Louisville'
Lord Huron
Palace Theatre - KY Louisville Louisville, KY
Apr 23, 8:00 pm 2019
Tuesday
Apr 23
8:00 pm
Lord Huron
Palace Theatre - KY, Louisville, KY
SELECT * from toolvenuepagelink WHERE venueid = 30220
SELECT * from toolcitypagelink WHERE cityname = 'Birmingham'
Lord Huron
Iron City - Birmingham Birmingham Birmingham, AL
Apr 25, 8:00 pm 2019
Thursday
Apr 25
8:00 pm
Lord Huron
Iron City - Birmingham, Birmingham, AL
SELECT * from toolvenuepagelink WHERE venueid = 5042
SELECT * from toolcitypagelink WHERE cityname = 'Athens'
Lord Huron
40 Watt Club Athens Athens, GA
Apr 26, 8:00 pm 2019
Friday
Apr 26
8:00 pm
Lord Huron
40 Watt Club, Athens, GA
SELECT * from toolvenuepagelink WHERE venueid = 6693
SELECT * from toolcitypagelink WHERE cityname = 'Charlotte'
Lord Huron
The Underground - Fillmore Charlotte Charlotte Charlotte, NC
Apr 27, 8:00 pm 2019
Saturday
Apr 27
8:00 pm
Lord Huron
The Underground - Fillmore Charlotte, Charlotte, NC
SELECT * from toolvenuepagelink WHERE venueid = 681
SELECT * from toolcitypagelink WHERE cityname = 'Orlando'
Lord Huron
House of Blues - Orlando Orlando Orlando, FL
Apr 29, 7:00 pm 2019
Monday
Apr 29
7:00 pm
Lord Huron
House of Blues - Orlando, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 735
SELECT * from toolcitypagelink WHERE cityname = 'Miami Beach'
Lord Huron
Fillmore Miami Beach at Jackie Gleason Theater Miami Beach Miami Beach, FL
Apr 30, 8:00 pm 2019
Tuesday
Apr 30
8:00 pm
Lord Huron
Fillmore Miami Beach at Jackie Gleason Theater, Miami Beach, FL
SELECT * from toolvenuepagelink WHERE venueid = 6561
SELECT * from toolcitypagelink WHERE cityname = 'Jacksonville'

May

Lord Huron
Mavericks Jacksonville Jacksonville, FL
May 1, 7:00 pm 2019
Wednesday
May 1
7:00 pm
Lord Huron
Mavericks, Jacksonville, FL
SELECT * from toolvenuepagelink WHERE venueid = 9134
SELECT * from toolcitypagelink WHERE cityname = 'Mobile'
Lord Huron
Soul Kitchen Mobile Mobile, AL
May 3, 8:00 pm 2019
Friday
May 3
8:00 pm
Lord Huron
Soul Kitchen, Mobile, AL
SELECT * from toolvenuepagelink WHERE venueid = 2198
SELECT * from toolcitypagelink WHERE cityname = 'Columbia'
Lord Huron
The Blue Note Columbia Columbia, MO
May 6, 8:00 pm 2019
Monday
May 6
8:00 pm
Lord Huron
The Blue Note, Columbia, MO
SELECT * from toolvenuepagelink WHERE venueid = 32943
SELECT * from toolcitypagelink WHERE cityname = 'Oklahoma City'
Lord Huron
The Criterion Oklahoma City Oklahoma City, OK
May 7, 7:00 pm 2019
Tuesday
May 7
7:00 pm
Lord Huron
The Criterion, Oklahoma City, OK
SELECT * from toolvenuepagelink WHERE venueid = 33081
SELECT * from toolcitypagelink WHERE cityname = 'El Paso'
Lord Huron
Lowbrow Palace El Paso El Paso, TX
May 9, 6:00 pm 2019
Thursday
May 9
6:00 pm
Lord Huron
Lowbrow Palace, El Paso, TX
SELECT * from toolvenuepagelink WHERE venueid = 3554
SELECT * from toolcitypagelink WHERE cityname = 'Albuquerque'
Lord Huron
Sunshine Theatre Albuquerque Albuquerque, NM
May 10, 8:00 pm 2019
Friday
May 10
8:00 pm
Lord Huron
Sunshine Theatre, Albuquerque, NM
SELECT * from toolvenuepagelink WHERE venueid = 2167
SELECT * from toolcitypagelink WHERE cityname = 'Tucson'
Lord Huron
Rialto Theatre - AZ Tucson Tucson, AZ
May 11, 8:00 pm 2019
Saturday
May 11
8:00 pm
Lord Huron
Rialto Theatre - AZ, Tucson, AZ
SELECT * from toolvenuepagelink WHERE venueid = 33533
SELECT * from toolcitypagelink WHERE cityname = 'Phoenix'
Lord Huron
The Van Buren Phoenix Phoenix, AZ
May 12, 8:00 pm 2019
Sunday
May 12
8:00 pm
Lord Huron
The Van Buren, Phoenix, AZ
SELECT * from toolvenuepagelink WHERE venueid = 1290
SELECT * from toolcitypagelink WHERE cityname = 'Morrison'
Lord Huron
Red Rocks Amphitheatre Morrison Morrison, CO
May 14, 7:00 pm 2019
Tuesday
May 14
7:00 pm
Lord Huron
Red Rocks Amphitheatre, Morrison, CO
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football