LISTE POUR : Jay Leno

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

February

Jay Leno
McCallum Theatre Palm Desert Palm Desert, CA
Feb 2, 3:00 pm 2019
Saturday
Feb 2
3:00 pm
Jay Leno
McCallum Theatre, Palm Desert, CA
SELECT * from toolvenuepagelink WHERE venueid = 951
SELECT * from toolcitypagelink WHERE cityname = 'Palm Desert'
Jay Leno
McCallum Theatre Palm Desert Palm Desert, CA
Feb 2, 8:00 pm 2019
Saturday
Feb 2
8:00 pm
Jay Leno
McCallum Theatre, Palm Desert, CA
SELECT * from toolvenuepagelink WHERE venueid = 31728
SELECT * from toolcitypagelink WHERE cityname = 'Charles Town'
Jay Leno
Event Center at Hollywood Casino Charles Town Charles Town, WV
Feb 16, 6:00 pm 2019
Saturday
Feb 16
6:00 pm
Jay Leno
Event Center at Hollywood Casino, Charles Town, WV
SELECT * from toolvenuepagelink WHERE venueid = 31728
SELECT * from toolcitypagelink WHERE cityname = 'Charles Town'
Jay Leno
Event Center at Hollywood Casino Charles Town Charles Town, WV
Feb 16, 9:00 pm 2019
Saturday
Feb 16
9:00 pm
Jay Leno
Event Center at Hollywood Casino, Charles Town, WV
SELECT * from toolvenuepagelink WHERE venueid = 33534
SELECT * from toolcitypagelink WHERE cityname = 'Waterloo'

March

Jay Leno
The Vine at Del Lago Resort Waterloo Waterloo, NY
Mar 16, 8:00 pm 2019
Saturday
Mar 16
8:00 pm
Jay Leno
The Vine at Del Lago Resort, Waterloo, NY
SELECT * from toolvenuepagelink WHERE venueid = 29174
SELECT * from toolcitypagelink WHERE cityname = 'Omaha'
Jay Leno
Kiewit Hall Omaha Omaha, NE
Mar 29, 7:30 pm 2019
Friday
Mar 29
7:30 pm
Jay Leno
Kiewit Hall, Omaha, NE
SELECT * from toolvenuepagelink WHERE venueid = 1977
SELECT * from toolcitypagelink WHERE cityname = 'Newark'

April

Jay Leno
New Jersey Performing Arts Center Newark Newark, NJ
Apr 25, 8:00 pm 2019
Thursday
Apr 25
8:00 pm
Jay Leno
New Jersey Performing Arts Center, Newark, NJ
SELECT * from toolvenuepagelink WHERE venueid = 7486
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Jay Leno
Kennedy Center - Terrace Theater Washington Washington, DC
Apr 26, 8:00 pm 2019
Friday
Apr 26
8:00 pm
Jay Leno
Kennedy Center - Terrace Theater, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 1353
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Jay Leno
Roy Thomson Hall Toronto Toronto, ON
Apr 27, 8:00 pm 2019
Saturday
Apr 27
8:00 pm
Jay Leno
Roy Thomson Hall, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 7407
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'

May

Jay Leno
Terry Fator Theatre - Mirage Las Vegas Las Vegas Las Vegas, NV
May 17, 10:00 pm 2019
Friday
May 17
10:00 pm
Jay Leno
Terry Fator Theatre - Mirage Las Vegas, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 3239
SELECT * from toolcitypagelink WHERE cityname = 'Burlington'
Jay Leno
Flynn Center for the Performing Arts Burlington Burlington, VT
May 30, 7:30 pm 2019
Thursday
May 30
7:30 pm
Jay Leno
Flynn Center for the Performing Arts, Burlington, VT
SELECT * from toolvenuepagelink WHERE venueid = 2656
SELECT * from toolcitypagelink WHERE cityname = 'Hampton'
Jay Leno
Hampton Beach Casino Ballroom Hampton Hampton, NH
May 31, 8:00 pm 2019
Friday
May 31
8:00 pm
Jay Leno
Hampton Beach Casino Ballroom, Hampton, NH
SELECT * from toolvenuepagelink WHERE venueid = 7407
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'

June

Jay Leno
Terry Fator Theatre - Mirage Las Vegas Las Vegas Las Vegas, NV
Jun 22, 10:00 pm 2019
Saturday
Jun 22
10:00 pm
Jay Leno
Terry Fator Theatre - Mirage Las Vegas, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 7407
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'

July

Jay Leno
Terry Fator Theatre - Mirage Las Vegas Las Vegas Las Vegas, NV
Jul 26, 10:00 pm 2019
Friday
Jul 26
10:00 pm
Jay Leno
Terry Fator Theatre - Mirage Las Vegas, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 7407
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'

December

Jay Leno
Terry Fator Theatre - Mirage Las Vegas Las Vegas Las Vegas, NV
Dec 28, 10:00 pm 2019
Saturday
Dec 28
10:00 pm
Jay Leno
Terry Fator Theatre - Mirage Las Vegas, Las Vegas, NV
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football