LISTE POUR : Tampa Bay Lightning

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

December

Ottawa Senators at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Dec 21, 7:30 pm 2017
Thursday
Dec 21
7:30 pm
Ottawa Senators at Tampa Bay Lightning
Amalie Arena, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Minnesota Wild at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Dec 23, 7:00 pm 2017
Saturday
Dec 23
7:00 pm
Minnesota Wild at Tampa Bay Lightning
Amalie Arena, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Montreal Canadiens at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Dec 28, 7:30 pm 2017
Thursday
Dec 28
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Philadelphia Flyers at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Dec 29, 7:30 pm 2017
Friday
Dec 29
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'

January

Carolina Hurricanes at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Jan 9, 7:30 pm 2018
Tuesday
Jan 9
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Calgary Flames at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Jan 11, 7:30 pm 2018
Thursday
Jan 11
7:30 pm
Calgary Flames at Tampa Bay Lightning
Amalie Arena, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Vegas Golden Knights at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Jan 18, 7:30 pm 2018
Thursday
Jan 18
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'

February

Vancouver Canucks at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Feb 8, 7:30 pm 2018
Thursday
Feb 8
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Los Angeles Kings at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Feb 10, 7:00 pm 2018
Saturday
Feb 10
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Detroit Red Wings at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Feb 15, 7:30 pm 2018
Thursday
Feb 15
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
New Jersey Devils at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Feb 17, 7:00 pm 2018
Saturday
Feb 17
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Toronto Maple Leafs at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Feb 26, 7:30 pm 2018
Monday
Feb 26
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Buffalo Sabres at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Feb 28, 7:00 pm 2018
Wednesday
Feb 28
7:00 pm
Buffalo Sabres at Tampa Bay Lightning
Amalie Arena, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'

March

Philadelphia Flyers at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Mar 3, 1:00 pm 2018
Saturday
Mar 3
1:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Florida Panthers at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Mar 6, 7:30 pm 2018
Tuesday
Mar 6
7:30 pm
Florida Panthers at Tampa Bay Lightning
Amalie Arena, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
New York Rangers at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Mar 8, 7:30 pm 2018
Thursday
Mar 8
7:30 pm
New York Rangers at Tampa Bay Lightning
Amalie Arena, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Montreal Canadiens at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Mar 10, 1:00 pm 2018
Saturday
Mar 10
1:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Ottawa Senators at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Mar 13, 7:30 pm 2018
Tuesday
Mar 13
7:30 pm
Ottawa Senators at Tampa Bay Lightning
Amalie Arena, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Boston Bruins at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Mar 17, 7:00 pm 2018
Saturday
Mar 17
7:00 pm
Boston Bruins at Tampa Bay Lightning
Amalie Arena, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Edmonton Oilers at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Mar 18, 5:00 pm 2018
Sunday
Mar 18
5:00 pm
Edmonton Oilers at Tampa Bay Lightning
Amalie Arena, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Toronto Maple Leafs at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Mar 20, 7:30 pm 2018
Tuesday
Mar 20
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Arizona Coyotes at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Mar 26, 7:30 pm 2018
Monday
Mar 26
7:30 pm
Arizona Coyotes at Tampa Bay Lightning
Amalie Arena, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'

April

Nashville Predators at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Apr 1, 6:00 pm 2018
Sunday
Apr 1
6:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Boston Bruins at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Apr 3, 7:30 pm 2018
Tuesday
Apr 3
7:30 pm
Boston Bruins at Tampa Bay Lightning
Amalie Arena, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Buffalo Sabres at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Apr 6, 7:30 pm 2018
Friday
Apr 6
7:30 pm
Buffalo Sabres at Tampa Bay Lightning
Amalie Arena, Tampa, FL
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football