LISTE POUR : Dallas Stars

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

February

Calgary Flames at Dallas Stars
American Airlines Center Dallas Dallas, TX
Feb 27, 7:30 pm 2018
Tuesday
Feb 27
7:30 pm
Calgary Flames at Dallas Stars
American Airlines Center, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'

March

Tampa Bay Lightning at Dallas Stars
American Airlines Center Dallas Dallas, TX
Mar 1, 7:30 pm 2018
Thursday
Mar 1
7:30 pm
Tampa Bay Lightning at Dallas Stars
American Airlines Center, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
St. Louis Blues at Dallas Stars
American Airlines Center Dallas Dallas, TX
Mar 3, 1:00 pm 2018
Saturday
Mar 3
1:00 pm
St. Louis Blues at Dallas Stars
American Airlines Center, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Ottawa Senators at Dallas Stars
American Airlines Center Dallas Dallas, TX
Mar 5, 7:30 pm 2018
Monday
Mar 5
7:30 pm
Ottawa Senators at Dallas Stars
American Airlines Center, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Anaheim Ducks at Dallas Stars
American Airlines Center Dallas Dallas, TX
Mar 9, 7:30 pm 2018
Friday
Mar 9
7:30 pm
Anaheim Ducks at Dallas Stars
American Airlines Center, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Boston Bruins at Dallas Stars
American Airlines Center Dallas Dallas, TX
Mar 23, 7:30 pm 2018
Friday
Mar 23
7:30 pm
Boston Bruins at Dallas Stars
American Airlines Center, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Vancouver Canucks at Dallas Stars
American Airlines Center Dallas Dallas, TX
Mar 25, 6:00 pm 2018
Sunday
Mar 25
6:00 pm
Vancouver Canucks at Dallas Stars
American Airlines Center, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Philadelphia Flyers at Dallas Stars
American Airlines Center Dallas Dallas, TX
Mar 27, 7:30 pm 2018
Tuesday
Mar 27
7:30 pm
Philadelphia Flyers at Dallas Stars
American Airlines Center, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Minnesota Wild at Dallas Stars
American Airlines Center Dallas Dallas, TX
Mar 31, 7:00 pm 2018
Saturday
Mar 31
7:00 pm
Minnesota Wild at Dallas Stars
American Airlines Center, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'

April

NHL Western Conference Quarterfinals: TBD at Dallas Stars - Home Game 1 (Date: TBD - If Necessary)
American Airlines Center Dallas Dallas, TX
Apr 11, 12:00 am 2018
Wednesday
Apr 11
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
NHL Western Conference Quarterfinals: TBD at Dallas Stars - Home Game 2 (Date: TBD - If Necessary)
American Airlines Center Dallas Dallas, TX
Apr 13, 12:00 am 2018
Friday
Apr 13
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
NHL Western Conference Quarterfinals: TBD at Dallas Stars - Home Game 3 (Date: TBD - If Necessary)
American Airlines Center Dallas Dallas, TX
Apr 21, 12:00 am 2018
Saturday
Apr 21
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
NHL Western Conference Quarterfinals: TBD at Dallas Stars - Home Game 4 (Date: TBD - If Necessary)
American Airlines Center Dallas Dallas, TX
Apr 23, 12:00 am 2018
Monday
Apr 23
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
NHL Western Conference Semifinals: TBD at Dallas Stars - Home Game 1 (Date: TBD - If Necessary)
American Airlines Center Dallas Dallas, TX
Apr 25, 12:00 am 2018
Wednesday
Apr 25
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
NHL Western Conference Semifinals: TBD at Dallas Stars - Home Game 2 (Date: TBD - If Necessary)
American Airlines Center Dallas Dallas, TX
Apr 27, 12:00 am 2018
Friday
Apr 27
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'

May

NHL Western Conference Semifinals: TBD at Dallas Stars - Home Game 3 (Date: TBD - If Necessary)
American Airlines Center Dallas Dallas, TX
May 6, 12:00 am 2018
Sunday
May 6
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
NHL Western Conference Semifinals: TBD at Dallas Stars - Home Game 4 (Date: TBD - If Necessary)
American Airlines Center Dallas Dallas, TX
May 9, 12:00 am 2018
Wednesday
May 9
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
NHL Western Conference Finals: TBD at Dallas Stars - Home Game 1 (Date: TBD - If Necessary)
American Airlines Center Dallas Dallas, TX
May 11, 12:00 am 2018
Friday
May 11
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
NHL Western Conference Finals: TBD at Dallas Stars - Home Game 2 (Date: TBD - If Necessary)
American Airlines Center Dallas Dallas, TX
May 13, 12:00 am 2018
Sunday
May 13
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
NHL Western Conference Finals: TBD at Dallas Stars - Home Game 3 (Date: TBD - If Necessary)
American Airlines Center Dallas Dallas, TX
May 19, 12:00 am 2018
Saturday
May 19
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
NHL Western Conference Finals: TBD at Dallas Stars - Home Game 4 (Date: TBD - If Necessary)
American Airlines Center Dallas Dallas, TX
May 21, 12:00 am 2018
Monday
May 21
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
NHL Stanley Cup Finals: TBD at Dallas Stars - Home Game 1 (Date: TBD - If Necessary)
American Airlines Center Dallas Dallas, TX
May 29, 12:00 am 2018
Tuesday
May 29
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
NHL Stanley Cup Finals: TBD at Dallas Stars - Home Game 2 (Date: TBD - If Necessary)
American Airlines Center Dallas Dallas, TX
May 30, 12:00 am 2018
Wednesday
May 30
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'

June

NHL Stanley Cup Finals: TBD at Dallas Stars - Home Game 3 (Date: TBD - If Necessary)
American Airlines Center Dallas Dallas, TX
Jun 7, 12:00 am 2018
Thursday
Jun 7
12:00 am
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
NHL Stanley Cup Finals: TBD at Dallas Stars - Home Game 4 (Date: TBD - If Necessary)
American Airlines Center Dallas Dallas, TX
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