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'

September

Preseason: Nashville Predators at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Sep 22, 7:00 pm 2018
Saturday
Sep 22
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Preseason: Florida Panthers at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Sep 25, 7:30 pm 2018
Tuesday
Sep 25
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 1537
SELECT * from toolcitypagelink WHERE cityname = 'Orlando'
Florida Panthers at Tampa Bay Lightning
Amway Center Orlando Orlando, FL
Sep 27, 7:00 pm 2018
Thursday
Sep 27
7:00 pm
Florida Panthers at Tampa Bay Lightning
Amway Center, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'

October

Florida Panthers at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Oct 6, 7:00 pm 2018
Saturday
Oct 6
7:00 pm
Florida Panthers at Tampa Bay Lightning
Amalie Arena, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Vancouver Canucks at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Oct 11, 7:30 pm 2018
Thursday
Oct 11
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Columbus Blue Jackets at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Oct 13, 7:00 pm 2018
Saturday
Oct 13
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Carolina Hurricanes at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Oct 16, 7:30 pm 2018
Tuesday
Oct 16
7:30 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
Oct 18, 7:30 pm 2018
Thursday
Oct 18
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
Oct 30, 7:30 pm 2018
Tuesday
Oct 30
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'

November

Nashville Predators at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Nov 1, 7:00 pm 2018
Thursday
Nov 1
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Edmonton Oilers at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Nov 6, 7:30 pm 2018
Tuesday
Nov 6
7:30 pm
Edmonton Oilers at Tampa Bay Lightning
Amalie Arena, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
New York Islanders at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Nov 8, 7:30 pm 2018
Thursday
Nov 8
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Ottawa Senators at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Nov 10, 7:00 pm 2018
Saturday
Nov 10
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'
Florida Panthers at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Nov 21, 7:30 pm 2018
Wednesday
Nov 21
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'
Chicago Blackhawks at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Nov 23, 7:30 pm 2018
Friday
Nov 23
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
Nov 25, 7:00 pm 2018
Sunday
Nov 25
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Anaheim Ducks at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Nov 27, 7:30 pm 2018
Tuesday
Nov 27
7:30 pm
Anaheim Ducks 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
Nov 29, 7:30 pm 2018
Thursday
Nov 29
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'

December

Boston Bruins at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Dec 6, 7:30 pm 2018
Thursday
Dec 6
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'
Colorado Avalanche at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Dec 8, 7:00 pm 2018
Saturday
Dec 8
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
New York Rangers at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Dec 10, 7:30 pm 2018
Monday
Dec 10
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'
Toronto Maple Leafs at Tampa Bay Lightning
Amalie Arena Tampa Tampa, FL
Dec 13, 7:30 pm 2018
Thursday
Dec 13
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 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 Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football