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

January

Lights
Vogue Theatre Vancouver Vancouver, BC
Jan 30, 8:00 pm 2018
Tuesday
Jan 30
8:00 pm
Lights
Vogue Theatre, Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 1692
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Lights
Vogue Theatre Vancouver Vancouver, BC
Jan 31, 8:00 pm 2018
Wednesday
Jan 31
8:00 pm
Lights
Vogue Theatre, Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 4059
SELECT * from toolcitypagelink WHERE cityname = 'Portland'

February

Lights
Wonder Ballroom Portland Portland, OR
Feb 3, 9:00 pm 2018
Saturday
Feb 3
9:00 pm
Lights
Wonder Ballroom, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 492
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Lights
The Fillmore San Francisco San Francisco, CA
Feb 5, 8:00 pm 2018
Monday
Feb 5
8:00 pm
Lights
The Fillmore, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 30153
SELECT * from toolcitypagelink WHERE cityname = 'Picton'
Lights
Regent Theatre - Ontario Picton Picton, ON
Feb 6, 8:00 pm 2018
Tuesday
Feb 6
8:00 pm
Lights
Regent Theatre - Ontario, Picton, ON
SELECT * from toolvenuepagelink WHERE venueid = 28217
SELECT * from toolcitypagelink WHERE cityname = 'San Diego'
Lights
The Observatory North Park (Formerly Birch North Park Theatre) San Diego San Diego, CA
Feb 7, 8:00 pm 2018
Wednesday
Feb 7
8:00 pm
Lights
The Observatory North Park (Formerly Birch North Park Theatre), San Diego, CA
SELECT * from toolvenuepagelink WHERE venueid = 2624
SELECT * from toolcitypagelink WHERE cityname = 'Tempe'
Lights
Marquee Theatre Tempe Tempe, AZ
Feb 8, 12:00 am 2018
Thursday
Feb 8
12:00 am
Lights
Marquee Theatre, Tempe, AZ
SELECT * from toolvenuepagelink WHERE venueid = 32944
SELECT * from toolcitypagelink WHERE cityname = 'Pomona'
Lights
The Glass House Pomona Pomona, CA
Feb 10, 8:00 pm 2018
Saturday
Feb 10
8:00 pm
Lights
The Glass House, Pomona, CA
SELECT * from toolvenuepagelink WHERE venueid = 9539
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
Lights
The Complex Salt Lake City Salt Lake City, UT
Feb 12, 7:00 pm 2018
Monday
Feb 12
7:00 pm
Lights
The Complex, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 7810
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Lights
Summit Music Hall Denver Denver, CO
Feb 13, 7:00 pm 2018
Tuesday
Feb 13
7:00 pm
Lights
Summit Music Hall, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 2329
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Lights
Granada Theater - TX Dallas Dallas, TX
Feb 15, 8:00 pm 2018
Thursday
Feb 15
8:00 pm
Lights
Granada Theater - TX, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 2171
SELECT * from toolcitypagelink WHERE cityname = 'Austin'
Lights
Emo's East Austin Austin, TX
Feb 16, 8:00 pm 2018
Friday
Feb 16
8:00 pm
Lights
Emo's East, Austin, TX
SELECT * from toolvenuepagelink WHERE venueid = 32931
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
Lights
White Oak Music Hall Houston Houston, TX
Feb 17, 7:00 pm 2018
Saturday
Feb 17
7:00 pm
Lights
White Oak Music Hall, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 3312
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
Lights
Mercy Lounge Nashville Nashville, TN
Feb 19, 7:30 pm 2018
Monday
Feb 19
7:30 pm
Lights
Mercy Lounge, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 1972
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
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 = 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 = 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
NOUVELLES - SPORT