LISTE POUR : Lights

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

February

Lights
Kennys Alley Atlanta Atlanta, GA
Feb 20, 7:00 pm 2018
Tuesday
Feb 20
7:00 pm
Lights
Kennys Alley, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 3313
SELECT * from toolcitypagelink WHERE cityname = 'Orlando'
Lights
The Beacham Orlando Orlando, FL
Feb 21, 7:00 pm 2018
Wednesday
Feb 21
7:00 pm
Lights
The Beacham, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 3591
SELECT * from toolcitypagelink WHERE cityname = 'Carrboro'
Lights
Cats Cradle Carrboro Carrboro, NC
Feb 22, 8:00 pm 2018
Thursday
Feb 22
8:00 pm
Lights
Cats Cradle, Carrboro, NC
SELECT * from toolvenuepagelink WHERE venueid = 2232
SELECT * from toolcitypagelink WHERE cityname = 'Norfolk'
Lights
The Norva Norfolk Norfolk, VA
Feb 23, 8:00 pm 2018
Friday
Feb 23
8:00 pm
Lights
The Norva, Norfolk, VA
SELECT * from toolvenuepagelink WHERE venueid = 856
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
Lights
Theatre of Living Arts Philadelphia Philadelphia, PA
Feb 25, 8:00 pm 2018
Sunday
Feb 25
8:00 pm
Lights
Theatre of Living Arts, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 725
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Lights
Irving Plaza New York New York, NY
Feb 26, 7:00 pm 2018
Monday
Feb 26
7:00 pm
Lights
Irving Plaza, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 1959
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Lights
9:30 Club Washington Washington, DC
Feb 27, 7:00 pm 2018
Tuesday
Feb 27
7:00 pm
Lights
9:30 Club, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 2992
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'

March

Lights
Danforth Music Hall Toronto Toronto, ON
Mar 1, 7:00 pm 2018
Thursday
Mar 1
7:00 pm
Lights
Danforth Music Hall, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 2992
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Lights
Danforth Music Hall Toronto Toronto, ON
Mar 2, 7:00 pm 2018
Friday
Mar 2
7:00 pm
Lights
Danforth Music Hall, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 2254
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Lights
Paradise Rock Club Boston Boston, MA
Mar 3, 7:00 pm 2018
Saturday
Mar 3
7:00 pm
Lights
Paradise Rock Club, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 255
SELECT * from toolcitypagelink WHERE cityname = 'Lancaster'
Lights
Chameleon Club Lancaster Lancaster, PA
Mar 4, 6:00 pm 2018
Sunday
Mar 4
6:00 pm
Lights
Chameleon Club, Lancaster, PA
SELECT * from toolvenuepagelink WHERE venueid = 4492
SELECT * from toolcitypagelink WHERE cityname = 'Buffalo'
Lights
Town Ballroom Buffalo Buffalo, NY
Mar 6, 7:00 pm 2018
Tuesday
Mar 6
7:00 pm
Lights
Town Ballroom, Buffalo, NY
SELECT * from toolvenuepagelink WHERE venueid = 3052
SELECT * from toolcitypagelink WHERE cityname = 'Millvale'
Lights
Mr Smalls Theater Millvale Millvale, PA
Mar 7, 8:00 pm 2018
Wednesday
Mar 7
8:00 pm
Lights
Mr Smalls Theater, Millvale, PA
SELECT * from toolvenuepagelink WHERE venueid = 1857
SELECT * from toolcitypagelink WHERE cityname = 'Cincinnati'
Lights
Bogarts Cincinnati Cincinnati, OH
Mar 8, 8:00 pm 2018
Thursday
Mar 8
8:00 pm
Lights
Bogarts, Cincinnati, OH
SELECT * from toolvenuepagelink WHERE venueid = 1371
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
Lights
St. Andrews Hall Detroit Detroit, MI
Mar 9, 7:00 pm 2018
Friday
Mar 9
7:00 pm
Lights
St. Andrews Hall, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 1110
SELECT * from toolcitypagelink WHERE cityname = 'Columbus'
Lights
Newport Music Hall Columbus Columbus, OH
Mar 10, 6:30 pm 2018
Saturday
Mar 10
6:30 pm
Lights
Newport Music Hall, Columbus, OH
SELECT * from toolvenuepagelink WHERE venueid = 680
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Lights
House of Blues - Chicago Chicago Chicago, IL
Mar 12, 6:30 pm 2018
Monday
Mar 12
6:30 pm
Lights
House of Blues - Chicago, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 4106
SELECT * from toolcitypagelink WHERE cityname = 'Madison'
Lights
Majestic Theatre Madison Madison, WI
Mar 13, 8:00 pm 2018
Tuesday
Mar 13
8:00 pm
Lights
Majestic Theatre, Madison, WI
SELECT * from toolvenuepagelink WHERE venueid = 1862
SELECT * from toolcitypagelink WHERE cityname = 'St Louis'
Lights
Delmar Hall St Louis St Louis, MO
Mar 14, 8:00 pm 2018
Wednesday
Mar 14
8:00 pm
Lights
Delmar Hall, St Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 5161
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Lights
Madrid Theatre Kansas City Kansas City, MO
Mar 15, 8:00 pm 2018
Thursday
Mar 15
8:00 pm
Lights
Madrid Theatre, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 5080
SELECT * from toolcitypagelink WHERE cityname = 'Omaha'
Lights
The Waiting Room Omaha Omaha, NE
Mar 16, 9:00 pm 2018
Friday
Mar 16
9:00 pm
Lights
The Waiting Room, Omaha, NE
SELECT * from toolvenuepagelink WHERE venueid = 33473
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
Lights
Music Hall Minneapolis Minneapolis, MN
Mar 17, 8:00 pm 2018
Saturday
Mar 17
8:00 pm
Lights
Music Hall, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 493
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
Lights
Fine Line Music Cafe Minneapolis Minneapolis, MN
Mar 17, 8:00 pm 2018
Saturday
Mar 17
8:00 pm
Lights
Fine Line Music Cafe, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 1645
SELECT * from toolcitypagelink WHERE cityname = 'Calgary'
Lights
MacEwan Hall Calgary Calgary, AB
Mar 27, 7:00 pm 2018
Tuesday
Mar 27
7:00 pm
Lights
MacEwan Hall, Calgary, AB
SELECT * from toolvenuepagelink WHERE venueid = 3608
SELECT * from toolcitypagelink WHERE cityname = 'Edmonton'
Lights
Francis Winspear Centre for Music Edmonton Edmonton, AB
Mar 29, 8:00 pm 2018
Thursday
Mar 29
8:00 pm
Lights
Francis Winspear Centre for Music, Edmonton, AB
SELECT * from toolvenuepagelink WHERE venueid = 31782
SELECT * from toolcitypagelink WHERE cityname = 'Saskatoon'
Lights
O'Brians Event Centre Saskatoon Saskatoon, CA
Mar 30, 8:00 pm 2018
Friday
Mar 30
8:00 pm
Lights
O'Brians Event Centre, Saskatoon, CA
SELECT * from toolvenuepagelink WHERE venueid = 3021
SELECT * from toolcitypagelink WHERE cityname = 'Winnipeg'
Lights with Dear Rouge
Burton Cummings Theatre Winnipeg Winnipeg, MB
Mar 31, 8:00 pm 2018
Saturday
Mar 31
8:00 pm
Lights with Dear Rouge
Burton Cummings Theatre, Winnipeg, MB
SELECT * from toolvenuepagelink WHERE venueid = 31613
SELECT * from toolcitypagelink WHERE cityname = 'Ottawa'

April

Lights
Algonquin College Commons Ottawa Ottawa, ON
Apr 4, 7:00 pm 2018
Wednesday
Apr 4
7:00 pm
Lights
Algonquin College Commons, Ottawa, ON
SELECT * from toolvenuepagelink WHERE venueid = 26058
SELECT * from toolcitypagelink WHERE cityname = 'Kitchener'
Lights with Dear Rouge
Elements Night Club Kitchener Kitchener, ON
Apr 6, 7:00 pm 2018
Friday
Apr 6
7:00 pm
Lights with Dear Rouge
Elements Night Club, Kitchener, ON
SELECT * from toolvenuepagelink WHERE venueid = 5798
SELECT * from toolcitypagelink WHERE cityname = 'London'
Lights
London Music Hall - Ontario London London, ON
Apr 7, 7:00 pm 2018
Saturday
Apr 7
7:00 pm
Lights
London Music Hall - Ontario, London, ON
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football