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'

February

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
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
NHL Eastern Conference Quarterfinals: TBD at Washington Capitals - Home Game 1 (Date: TBD - If Necessary)
Capital One Arena Washington Washington, DC
Apr 11, 12:00 am 2018
Wednesday
Apr 11
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
NHL Eastern Conference Quarterfinals: TBD at Washington Capitals - Home Game 2 (Date: TBD - If Necessary)
Capital One Arena Washington Washington, DC
Apr 13, 12:00 am 2018
Friday
Apr 13
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
NHL Eastern Conference Quarterfinals: TBD at Washington Capitals - Home Game 3 (Date: TBD - If Necessary)
Capital One Arena Washington Washington, DC
Apr 21, 12:00 am 2018
Saturday
Apr 21
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
NHL Eastern Conference Quarterfinals: TBD at Washington Capitals - Home Game 4 (Date: TBD - If Necessary)
Capital One Arena Washington Washington, DC
Apr 23, 12:00 am 2018
Monday
Apr 23
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
NHL Eastern Conference Semifinals: TBD at Washington Capitals - Home Game 1 (Date: TBD - If Necessary)
Capital One Arena Washington Washington, DC
Apr 25, 12:00 am 2018
Wednesday
Apr 25
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
NHL Eastern Conference Semifinals: TBD at Washington Capitals - Home Game 2 (Date: TBD - If Necessary)
Capital One Arena Washington Washington, DC
Apr 27, 12:00 am 2018
Friday
Apr 27
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'

May

NHL Eastern Conference Semifinals: TBD at Washington Capitals - Home Game 3 (Date: TBD - If Necessary)
Capital One Arena Washington Washington, DC
May 6, 12:00 am 2018
Sunday
May 6
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
NHL Eastern Conference Semifinals: TBD at Washington Capitals - Home Game 4 (Date: TBD - If Necessary)
Capital One Arena Washington Washington, DC
May 9, 12:00 am 2018
Wednesday
May 9
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
NHL Eastern Conference Finals: TBD at Washington Capitals - Home Game 1 (Date: TBD - If Necessary)
Capital One Arena Washington Washington, DC
May 11, 12:00 am 2018
Friday
May 11
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
NHL Eastern Conference Finals: TBD at Washington Capitals - Home Game 2 (Date: TBD - If Necessary)
Capital One Arena Washington Washington, DC
May 13, 12:00 am 2018
Sunday
May 13
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
NHL Eastern Conference Finals: TBD at Washington Capitals- Home Game 3 (Date: TBD - If Necessary)
Capital One Arena Washington Washington, DC
May 19, 12:00 am 2018
Saturday
May 19
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
NHL Eastern Conference Finals: TBD at Washington Capitals - Home Game 4 (Date: TBD - If Necessary)
Capital One Arena Washington Washington, DC
May 21, 12:00 am 2018
Monday
May 21
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Stanley Cup Final: TBD at Washington Capitals - Home Game 1 (Date: TBD - If Necessary)
Capital One Arena Washington Washington, DC
May 28, 12:00 am 2018
Monday
May 28
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Stanley Cup Final: TBD at Washington Capitals - Home Game 2 (Date: TBD - If Necessary)
Capital One Arena Washington Washington, DC
May 30, 12:00 am 2018
Wednesday
May 30
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'

June

Stanley Cup Final: TBD at Washington Capitals - Home Game 4 (Date: TBD - If Necessary)
Capital One Arena Washington Washington, DC
Jun 10, 12:00 am 2018
Sunday
Jun 10
12:00 am
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football