LISTE POUR : Kansas City Royals

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

June

Chicago White Sox at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Jun 9, 1:15 pm 2019
Sunday
Jun 9
1:15 pm
Chicago White Sox at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Detroit Tigers at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Jun 11, 7:15 pm 2019
Tuesday
Jun 11
7:15 pm
Detroit Tigers at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Detroit Tigers at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Jun 12, 7:15 pm 2019
Wednesday
Jun 12
7:15 pm
Detroit Tigers at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 7759
SELECT * from toolcitypagelink WHERE cityname = 'Omaha'
Detroit Tigers at Kansas City Royals
TD Ameritrade Park Omaha Omaha, NE
Jun 13, 7:05 pm 2019
Thursday
Jun 13
7:05 pm
Detroit Tigers at Kansas City Royals
TD Ameritrade Park, Omaha, NE
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Minnesota Twins at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Jun 20, 7:15 pm 2019
Thursday
Jun 20
7:15 pm
Minnesota Twins at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Minnesota Twins at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Jun 21, 7:15 pm 2019
Friday
Jun 21
7:15 pm
Minnesota Twins at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Minnesota Twins at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Jun 22, 1:15 pm 2019
Saturday
Jun 22
1:15 pm
Minnesota Twins at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Minnesota Twins at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Jun 23, 1:15 pm 2019
Sunday
Jun 23
1:15 pm
Minnesota Twins at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'

July

Cleveland Indians at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Jul 2, 7:15 pm 2019
Tuesday
Jul 2
7:15 pm
Cleveland Indians at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Cleveland Indians at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Jul 3, 7:15 pm 2019
Wednesday
Jul 3
7:15 pm
Cleveland Indians at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Cleveland Indians at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Jul 4, 12:15 pm 2019
Thursday
Jul 4
12:15 pm
Cleveland Indians at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Detroit Tigers at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Jul 12, 7:15 pm 2019
Friday
Jul 12
7:15 pm
Detroit Tigers at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Detroit Tigers at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Jul 13, 6:15 pm 2019
Saturday
Jul 13
6:15 pm
Detroit Tigers at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Detroit Tigers at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Jul 14, 1:15 pm 2019
Sunday
Jul 14
1:15 pm
Detroit Tigers at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Chicago White Sox at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Jul 15, 7:15 pm 2019
Monday
Jul 15
7:15 pm
Chicago White Sox at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Chicago White Sox at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Jul 16, 7:15 pm 2019
Tuesday
Jul 16
7:15 pm
Chicago White Sox at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Chicago White Sox at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Jul 17, 7:15 pm 2019
Wednesday
Jul 17
7:15 pm
Chicago White Sox at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Chicago White Sox at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Jul 18, 12:15 pm 2019
Thursday
Jul 18
12:15 pm
Chicago White Sox at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Cleveland Indians at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Jul 25, 7:15 pm 2019
Thursday
Jul 25
7:15 pm
Cleveland Indians at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Cleveland Indians at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Jul 26, 7:15 pm 2019
Friday
Jul 26
7:15 pm
Cleveland Indians at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Cleveland Indians at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Jul 27, 7:15 pm 2019
Saturday
Jul 27
7:15 pm
Cleveland Indians at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Cleveland Indians at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Jul 28, 1:15 pm 2019
Sunday
Jul 28
1:15 pm
Cleveland Indians at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Toronto Blue Jays at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Jul 29, 8:15 pm 2019
Monday
Jul 29
8:15 pm
Toronto Blue Jays at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Toronto Blue Jays at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Jul 30, 8:15 pm 2019
Tuesday
Jul 30
8:15 pm
Toronto Blue Jays at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Toronto Blue Jays at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Jul 31, 1:15 pm 2019
Wednesday
Jul 31
1:15 pm
Toronto Blue Jays at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'

August

St. Louis Cardinals at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Aug 13, 7:15 pm 2019
Tuesday
Aug 13
7:15 pm
St. Louis Cardinals at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
St. Louis Cardinals at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Aug 14, 7:15 pm 2019
Wednesday
Aug 14
7:15 pm
St. Louis Cardinals at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
New York Mets at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Aug 16, 7:15 pm 2019
Friday
Aug 16
7:15 pm
New York Mets at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
New York Mets at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Aug 17, 6:15 pm 2019
Saturday
Aug 17
6:15 pm
New York Mets at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
New York Mets at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Aug 18, 1:15 pm 2019
Sunday
Aug 18
1:15 pm
New York Mets at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Oakland Athletics at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Aug 26, 7:15 pm 2019
Monday
Aug 26
7:15 pm
Oakland Athletics at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Oakland Athletics at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Aug 27, 7:15 pm 2019
Tuesday
Aug 27
7:15 pm
Oakland Athletics at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Oakland Athletics at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Aug 28, 7:15 pm 2019
Wednesday
Aug 28
7:15 pm
Oakland Athletics at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Oakland Athletics at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Aug 29, 12:15 pm 2019
Thursday
Aug 29
12:15 pm
Oakland Athletics at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Baltimore Orioles at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Aug 30, 7:15 pm 2019
Friday
Aug 30
7:15 pm
Baltimore Orioles at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Baltimore Orioles at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Aug 31, 6:15 pm 2019
Saturday
Aug 31
6:15 pm
Baltimore Orioles at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'

September

Baltimore Orioles at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Sep 1, 1:15 pm 2019
Sunday
Sep 1
1:15 pm
Baltimore Orioles at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Detroit Tigers at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Sep 3, 7:15 pm 2019
Tuesday
Sep 3
7:15 pm
Detroit Tigers at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Detroit Tigers at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Sep 4, 7:15 pm 2019
Wednesday
Sep 4
7:15 pm
Detroit Tigers at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Detroit Tigers at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Sep 5, 12:15 pm 2019
Thursday
Sep 5
12:15 pm
Detroit Tigers at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Houston Astros at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Sep 13, 7:15 pm 2019
Friday
Sep 13
7:15 pm
Houston Astros at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Houston Astros at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Sep 14, 1:00 pm 2019
Saturday
Sep 14
1:00 pm
Houston Astros at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Houston Astros at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Sep 15, 1:15 pm 2019
Sunday
Sep 15
1:15 pm
Houston Astros at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Atlanta Braves at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Sep 24, 7:15 pm 2019
Tuesday
Sep 24
7:15 pm
Atlanta Braves at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Atlanta Braves at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Sep 25, 7:15 am 2019
Wednesday
Sep 25
7:15 am
Atlanta Braves at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Minnesota Twins at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Sep 27, 7:15 pm 2019
Friday
Sep 27
7:15 pm
Minnesota Twins at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Minnesota Twins at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Sep 28, 6:15 pm 2019
Saturday
Sep 28
6:15 pm
Minnesota Twins at Kansas City Royals
Kauffman Stadium, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 767
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Minnesota Twins at Kansas City Royals
Kauffman Stadium Kansas City Kansas City, MO
Sep 29, 2:15 pm 2019
Sunday
Sep 29
2:15 pm
Minnesota Twins at Kansas City Royals
Kauffman Stadium, Kansas City, MO
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football