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

Philadelphia Flyers at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Dec 27, 7:30 pm 2018
Thursday
Dec 27
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Montreal Canadiens at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Dec 29, 7:00 pm 2018
Saturday
Dec 29
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'

January

Columbus Blue Jackets at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Jan 8, 7:30 pm 2019
Tuesday
Jan 8
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Carolina Hurricanes at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Jan 10, 7:30 pm 2019
Thursday
Jan 10
7:30 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
Jan 17, 7:30 pm 2019
Thursday
Jan 17
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
San Jose Sharks at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Jan 19, 7:00 pm 2019
Saturday
Jan 19
7:00 pm
San Jose Sharks at Tampa Bay Lightning
Amalie Arena, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'

February

Vegas Golden Knights at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Feb 5, 7:30 pm 2019
Tuesday
Feb 5
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
St. Louis Blues at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Feb 7, 7:30 pm 2019
Thursday
Feb 7
7:30 pm
St. Louis Blues at Tampa Bay Lightning
Amalie Arena, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Pittsburgh Penguins at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Feb 9, 7:00 pm 2019
Saturday
Feb 9
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Calgary Flames at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Feb 12, 7:30 pm 2019
Tuesday
Feb 12
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'
Dallas Stars at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Feb 14, 7:30 pm 2019
Thursday
Feb 14
7:30 pm
Dallas Stars 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
Feb 16, 7:00 pm 2019
Saturday
Feb 16
7:00 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 21, 7:30 pm 2019
Thursday
Feb 21
7:30 pm
Buffalo Sabres at Tampa Bay Lightning
Amalie Arena, Tampa, FL
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 25, 7:30 pm 2019
Monday
Feb 25
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'

March

Ottawa Senators at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Mar 2, 7:00 pm 2019
Saturday
Mar 2
7:00 pm
Ottawa Senators at Tampa Bay Lightning
Amalie Arena, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Winnipeg Jets at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Mar 5, 7:30 pm 2019
Tuesday
Mar 5
7:30 pm
Winnipeg Jets 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
Mar 7, 7:30 pm 2019
Thursday
Mar 7
7:30 pm
Minnesota Wild at Tampa Bay Lightning
Amalie Arena, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Detroit Red Wings at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Mar 9, 7:00 pm 2019
Saturday
Mar 9
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Washington Capitals at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Mar 16, 7:00 pm 2019
Saturday
Mar 16
7:00 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 18, 7:30 pm 2019
Monday
Mar 18
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'
Boston Bruins at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Mar 25, 7:30 pm 2019
Monday
Mar 25
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'
Washington Capitals at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Mar 30, 7:00 pm 2019
Saturday
Mar 30
7:00 pm
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football