LISTE POUR : Chicago White Sox

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

June

Washington Nationals at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Jun 10, 7:10 pm 2019
Monday
Jun 10
7:10 pm
Washington Nationals at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Washington Nationals at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Jun 11, 7:10 pm 2019
Tuesday
Jun 11
7:10 pm
Washington Nationals at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
New York Yankees at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Jun 13, 7:10 pm 2019
Thursday
Jun 13
7:10 pm
New York Yankees at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
New York Yankees at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Jun 14, 7:10 pm 2019
Friday
Jun 14
7:10 pm
New York Yankees at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
New York Yankees at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Jun 15, 6:10 pm 2019
Saturday
Jun 15
6:10 pm
New York Yankees at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
New York Yankees at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Jun 16, 1:10 pm 2019
Sunday
Jun 16
1:10 pm
New York Yankees at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Minnesota Twins at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Jun 28, 7:10 pm 2019
Friday
Jun 28
7:10 pm
Minnesota Twins at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Minnesota Twins at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Jun 29, 3:10 pm 2019
Saturday
Jun 29
3:10 pm
Minnesota Twins at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Minnesota Twins at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Jun 30, 1:10 pm 2019
Sunday
Jun 30
1:10 pm
Minnesota Twins at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'

July

Detroit Tigers at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Jul 2, 7:10 pm 2019
Tuesday
Jul 2
7:10 pm
Detroit Tigers at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Detroit Tigers at Chicago White Sox (Rescheduled from 04/27/2019)
Guaranteed Rate Field Chicago Chicago, IL
Jul 3, 1:10 pm 2019
Wednesday
Jul 3
1:10 pm
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Detroit Tigers at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Jul 3, 7:10 pm 2019
Wednesday
Jul 3
7:10 pm
Detroit Tigers at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Detroit Tigers at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Jul 4, 1:10 pm 2019
Thursday
Jul 4
1:10 pm
Detroit Tigers at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Chicago Cubs at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Jul 6, 6:15 pm 2019
Saturday
Jul 6
6:15 pm
Chicago Cubs at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Chicago Cubs at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Jul 7, 1:10 pm 2019
Sunday
Jul 7
1:10 pm
Chicago Cubs at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Miami Marlins at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Jul 22, 7:10 pm 2019
Monday
Jul 22
7:10 pm
Miami Marlins at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Miami Marlins at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Jul 23, 7:10 pm 2019
Tuesday
Jul 23
7:10 pm
Miami Marlins at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Miami Marlins at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Jul 24, 7:10 pm 2019
Wednesday
Jul 24
7:10 pm
Miami Marlins at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Minnesota Twins at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Jul 25, 7:10 pm 2019
Thursday
Jul 25
7:10 pm
Minnesota Twins at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Minnesota Twins at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Jul 26, 7:10 pm 2019
Friday
Jul 26
7:10 pm
Minnesota Twins at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Minnesota Twins at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Jul 27, 6:10 pm 2019
Saturday
Jul 27
6:10 pm
Minnesota Twins at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Minnesota Twins at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Jul 28, 1:10 pm 2019
Sunday
Jul 28
1:10 pm
Minnesota Twins at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
New York Mets at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Jul 30, 7:10 pm 2019
Tuesday
Jul 30
7:10 pm
New York Mets at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
New York Mets at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Jul 31, 7:10 pm 2019
Wednesday
Jul 31
7:10 pm
New York Mets at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'

August

New York Mets at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Aug 1, 1:10 pm 2019
Thursday
Aug 1
1:10 pm
New York Mets at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Oakland Athletics at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Aug 9, 2:10 pm 2019
Friday
Aug 9
2:10 pm
Oakland Athletics at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Oakland Athletics at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Aug 10, 6:10 pm 2019
Saturday
Aug 10
6:10 pm
Oakland Athletics at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Oakland Athletics at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Aug 11, 1:10 pm 2019
Sunday
Aug 11
1:10 pm
Oakland Athletics at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Houston Astros at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Aug 12, 7:10 pm 2019
Monday
Aug 12
7:10 pm
Houston Astros at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Houston Astros at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Aug 13, 7:10 pm 2019
Tuesday
Aug 13
7:10 pm
Houston Astros at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Houston Astros at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Aug 14, 1:10 pm 2019
Wednesday
Aug 14
1:10 pm
Houston Astros at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Texas Rangers at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Aug 22, 7:10 pm 2019
Thursday
Aug 22
7:10 pm
Texas Rangers at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Texas Rangers at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Aug 23, 7:10 pm 2019
Friday
Aug 23
7:10 pm
Texas Rangers at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Texas Rangers at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Aug 24, 6:10 pm 2019
Saturday
Aug 24
6:10 pm
Texas Rangers at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Texas Rangers at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Aug 25, 1:10 pm 2019
Sunday
Aug 25
1:10 pm
Texas Rangers at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Minnesota Twins at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Aug 27, 7:10 pm 2019
Tuesday
Aug 27
7:10 pm
Minnesota Twins at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Minnesota Twins at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Aug 28, 7:10 pm 2019
Wednesday
Aug 28
7:10 pm
Minnesota Twins at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Minnesota Twins at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Aug 29, 1:10 pm 2019
Thursday
Aug 29
1:10 pm
Minnesota Twins at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'

September

Los Angeles Angels at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Sep 6, 7:10 pm 2019
Friday
Sep 6
7:10 pm
Los Angeles Angels at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Los Angeles Angels at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Sep 7, 6:10 pm 2019
Saturday
Sep 7
6:10 pm
Los Angeles Angels at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Los Angeles Angels at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Sep 8, 1:10 pm 2019
Sunday
Sep 8
1:10 pm
Los Angeles Angels at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Kansas City Royals at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Sep 10, 7:10 pm 2019
Tuesday
Sep 10
7:10 pm
Kansas City Royals at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Kansas City Royals at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Sep 11, 7:10 pm 2019
Wednesday
Sep 11
7:10 pm
Kansas City Royals at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Kansas City Royals at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Sep 12, 1:10 pm 2019
Thursday
Sep 12
1:10 pm
Kansas City Royals at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Cleveland Indians at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Sep 24, 7:10 pm 2019
Tuesday
Sep 24
7:10 pm
Cleveland Indians at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Cleveland Indians at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Sep 25, 7:10 pm 2019
Wednesday
Sep 25
7:10 pm
Cleveland Indians at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Cleveland Indians at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Sep 26, 7:10 pm 2019
Thursday
Sep 26
7:10 pm
Cleveland Indians at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Detroit Tigers at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Sep 27, 7:10 pm 2019
Friday
Sep 27
7:10 pm
Detroit Tigers at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Detroit Tigers at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Sep 28, 6:10 pm 2019
Saturday
Sep 28
6:10 pm
Detroit Tigers at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 318
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Detroit Tigers at Chicago White Sox
Guaranteed Rate Field Chicago Chicago, IL
Sep 29, 2:10 pm 2019
Sunday
Sep 29
2:10 pm
Detroit Tigers at Chicago White Sox
Guaranteed Rate Field, Chicago, IL
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football