LISTE POUR : Washington Capitals

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

December

Colorado Avalanche at Washington Capitals
Capital One Arena Washington Washington, DC
Dec 12, 7:00 pm 2017
Tuesday
Dec 12
7:00 pm
Colorado Avalanche at Washington Capitals
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Anaheim Ducks at Washington Capitals
Capital One Arena Washington Washington, DC
Dec 16, 7:30 pm 2017
Saturday
Dec 16
7:30 pm
Anaheim Ducks at Washington Capitals
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Boston Bruins at Washington Capitals
Capital One Arena Washington Washington, DC
Dec 28, 7:00 pm 2017
Thursday
Dec 28
7:00 pm
Boston Bruins at Washington Capitals
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
New Jersey Devils at Washington Capitals
Capital One Arena Washington Washington, DC
Dec 30, 7:00 pm 2017
Saturday
Dec 30
7:00 pm
New Jersey Devils at Washington Capitals
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'

January

St. Louis Blues at Washington Capitals
Capital One Arena Washington Washington, DC
Jan 7, 3:00 pm 2018
Sunday
Jan 7
3:00 pm
St. Louis Blues at Washington Capitals
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Vancouver Canucks at Washington Capitals
Capital One Arena Washington Washington, DC
Jan 9, 7:00 pm 2018
Tuesday
Jan 9
7:00 pm
Vancouver Canucks at Washington Capitals
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Carolina Hurricanes at Washington Capitals
Capital One Arena Washington Washington, DC
Jan 11, 7:00 pm 2018
Thursday
Jan 11
7:00 pm
Carolina Hurricanes at Washington Capitals
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Montreal Canadiens at Washington Capitals
Capital One Arena Washington Washington, DC
Jan 19, 7:30 pm 2018
Friday
Jan 19
7:30 pm
Montreal Canadiens at Washington Capitals
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Philadelphia Flyers at Washington Capitals
Capital One Arena Washington Washington, DC
Jan 21, 12:30 pm 2018
Sunday
Jan 21
12:30 pm
Philadelphia Flyers at Washington Capitals
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Philadelphia Flyers at Washington Capitals
Capital One Arena Washington Washington, DC
Jan 31, 8:00 pm 2018
Wednesday
Jan 31
8:00 pm
Philadelphia Flyers at Washington Capitals
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'

February

Vegas Golden Knights at Washington Capitals
Capital One Arena Washington Washington, DC
Feb 4, 12:30 pm 2018
Sunday
Feb 4
12:30 pm
Vegas Golden Knights at Washington Capitals
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Columbus Blue Jackets at Washington Capitals
Capital One Arena Washington Washington, DC
Feb 9, 7:00 pm 2018
Friday
Feb 9
7:00 pm
Columbus Blue Jackets at Washington Capitals
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Detroit Red Wings at Washington Capitals
Capital One Arena Washington Washington, DC
Feb 11, 3:00 pm 2018
Sunday
Feb 11
3:00 pm
Detroit Red Wings at Washington Capitals
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Tampa Bay Lightning at Washington Capitals
Capital One Arena Washington Washington, DC
Feb 20, 7:00 pm 2018
Tuesday
Feb 20
7:00 pm
Tampa Bay Lightning at Washington Capitals
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Buffalo Sabres at Washington Capitals
Capital One Arena Washington Washington, DC
Feb 24, 7:00 pm 2018
Saturday
Feb 24
7:00 pm
Buffalo Sabres at Washington Capitals
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Ottawa Senators at Washington Capitals
Capital One Arena Washington Washington, DC
Feb 27, 7:00 pm 2018
Tuesday
Feb 27
7:00 pm
Ottawa Senators at Washington Capitals
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 3205
SELECT * from toolcitypagelink WHERE cityname = 'Annapolis'

March

NHL Stadium Series - Toronto Maple Leafs vs. Washington Capitals
Navy Marine Corps Memorial Stadium Annapolis Annapolis, MD
Mar 3, 12:00 am 2018
Saturday
Mar 3
12:00 am
NHL Stadium Series - Toronto Maple Leafs vs. Washington Capitals
Navy Marine Corps Memorial Stadium, Annapolis, MD
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Toronto Maple Leafs at Washington Capitals
Capital One Arena Washington Washington, DC
Mar 3, 8:00 pm 2018
Saturday
Mar 3
8:00 pm
Toronto Maple Leafs at Washington Capitals
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Winnipeg Jets at Washington Capitals
Capital One Arena Washington Washington, DC
Mar 12, 7:00 pm 2018
Monday
Mar 12
7:00 pm
Winnipeg Jets at Washington Capitals
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
New York Islanders at Washington Capitals
Capital One Arena Washington Washington, DC
Mar 16, 7:00 pm 2018
Friday
Mar 16
7:00 pm
New York Islanders at Washington Capitals
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Dallas Stars at Washington Capitals
Capital One Arena Washington Washington, DC
Mar 20, 7:00 pm 2018
Tuesday
Mar 20
7:00 pm
Dallas Stars at Washington Capitals
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
New York Rangers at Washington Capitals
Capital One Arena Washington Washington, DC
Mar 28, 8:00 pm 2018
Wednesday
Mar 28
8:00 pm
New York Rangers at Washington Capitals
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Carolina Hurricanes at Washington Capitals
Capital One Arena Washington Washington, DC
Mar 30, 7:00 pm 2018
Friday
Mar 30
7:00 pm
Carolina Hurricanes at Washington Capitals
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'

April

Nashville Predators at Washington Capitals
Capital One Arena Washington Washington, DC
Apr 5, 7:00 pm 2018
Thursday
Apr 5
7:00 pm
Nashville Predators at Washington Capitals
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
New Jersey Devils at Washington Capitals
Capital One Arena Washington Washington, DC
Apr 7, 7:00 pm 2018
Saturday
Apr 7
7:00 pm
New Jersey Devils at Washington Capitals
Capital One Arena, Washington, DC
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football