LISTE POUR : Harlem Globetrotters

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

March

Harlem Globetrotters
Cross Insurance Arena Portland Portland, ME
Mar 21, 7:00 pm 2019
Thursday
Mar 21
7:00 pm
Harlem Globetrotters
Cross Insurance Arena, Portland, ME
SELECT * from toolvenuepagelink WHERE venueid = 2073
SELECT * from toolcitypagelink WHERE cityname = 'Manchester'
Harlem Globetrotters
SNHU Arena Manchester Manchester, NH
Mar 22, 7:00 pm 2019
Friday
Mar 22
7:00 pm
Harlem Globetrotters
SNHU Arena, Manchester, NH
SELECT * from toolvenuepagelink WHERE venueid = 2172
SELECT * from toolcitypagelink WHERE cityname = 'Worcester'
Harlem Globetrotters
DCU Center Worcester Worcester, MA
Mar 23, 2:00 pm 2019
Saturday
Mar 23
2:00 pm
Harlem Globetrotters
DCU Center, Worcester, MA
SELECT * from toolvenuepagelink WHERE venueid = 2172
SELECT * from toolcitypagelink WHERE cityname = 'Worcester'
Harlem Globetrotters
DCU Center Worcester Worcester, MA
Mar 23, 7:00 pm 2019
Saturday
Mar 23
7:00 pm
Harlem Globetrotters
DCU Center, Worcester, MA
SELECT * from toolvenuepagelink WHERE venueid = 605
SELECT * from toolcitypagelink WHERE cityname = 'Greensboro'
Harlem Globetrotters
Greensboro Coliseum Greensboro Greensboro, NC
Mar 24, 3:00 pm 2019
Sunday
Mar 24
3:00 pm
Harlem Globetrotters
Greensboro Coliseum, Greensboro, NC
SELECT * from toolvenuepagelink WHERE venueid = 30256
SELECT * from toolcitypagelink WHERE cityname = 'Bangor'
Harlem Globetrotters
Cross Insurance Center Bangor Bangor, Ma
Mar 26, 7:00 pm 2019
Tuesday
Mar 26
7:00 pm
Harlem Globetrotters
Cross Insurance Center, Bangor, Ma
SELECT * from toolvenuepagelink WHERE venueid = 2957
SELECT * from toolcitypagelink WHERE cityname = 'Johnson City'
Harlem Globetrotters
Freedom Hall Civic Center Johnson City Johnson City, TN
Mar 26, 7:00 pm 2019
Tuesday
Mar 26
7:00 pm
Harlem Globetrotters
Freedom Hall Civic Center, Johnson City, TN
SELECT * from toolvenuepagelink WHERE venueid = 32366
SELECT * from toolcitypagelink WHERE cityname = 'Quebec'
Harlem Globetrotters
Centre Videotron Quebec Quebec, QC
Mar 27, 7:00 pm 2019
Wednesday
Mar 27
7:00 pm
Harlem Globetrotters
Centre Videotron, Quebec, QC
SELECT * from toolvenuepagelink WHERE venueid = 392
SELECT * from toolcitypagelink WHERE cityname = 'Duluth'
Harlem Globetrotters
AMSOIL Arena Duluth Duluth, MN
Mar 28, 7:00 pm 2019
Thursday
Mar 28
7:00 pm
Harlem Globetrotters
AMSOIL Arena, Duluth, MN
SELECT * from toolvenuepagelink WHERE venueid = 1036
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Harlem Globetrotters
Bell Centre Montreal Montreal, QC
Mar 29, 7:00 pm 2019
Friday
Mar 29
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 945
SELECT * from toolcitypagelink WHERE cityname = 'Rochester'
Harlem Globetrotters
Mayo Civic Center Presentation Hall Rochester Rochester, MN
Mar 29, 7:00 pm 2019
Friday
Mar 29
7:00 pm
Harlem Globetrotters
Mayo Civic Center Presentation Hall, Rochester, MN
SELECT * from toolvenuepagelink WHERE venueid = 1534
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
Harlem Globetrotters
Target Center Minneapolis Minneapolis, MN
Mar 30, 1:00 pm 2019
Saturday
Mar 30
1:00 pm
Harlem Globetrotters
Target Center, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 33560
SELECT * from toolcitypagelink WHERE cityname = 'Laval'
Harlem Globetrotters
Place Bell Laval Laval, QC
Mar 30, 2:00 pm 2019
Saturday
Mar 30
2:00 pm
Harlem Globetrotters
Place Bell, Laval, QC
SELECT * from toolvenuepagelink WHERE venueid = 345
SELECT * from toolcitypagelink WHERE cityname = 'Kanata'
Harlem Globetrotters
Canadian Tire Centre Kanata Kanata, ON
Mar 31, 2:00 pm 2019
Sunday
Mar 31
2:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 1534
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
Harlem Globetrotters
Target Center Minneapolis Minneapolis, MN
Mar 31, 2:00 pm 2019
Sunday
Mar 31
2:00 pm
Harlem Globetrotters
Target Center, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 114
SELECT * from toolcitypagelink WHERE cityname = 'Barrie'

April

Harlem Globetrotters
Barrie Molson Centre Barrie Barrie, ON
Apr 3, 7:00 pm 2019
Wednesday
Apr 3
7:00 pm
Harlem Globetrotters
Barrie Molson Centre, Barrie, ON
SELECT * from toolvenuepagelink WHERE venueid = 31889
SELECT * from toolcitypagelink WHERE cityname = 'Binghamton'
Harlem Globetrotters
Floyd L. Maines Veterans Memorial Arena Binghamton Binghamton, NY
Apr 4, 7:00 pm 2019
Thursday
Apr 4
7:00 pm
Harlem Globetrotters
Floyd L. Maines Veterans Memorial Arena, Binghamton, NY
SELECT * from toolvenuepagelink WHERE venueid = 6156
SELECT * from toolcitypagelink WHERE cityname = 'Peterborough'
Harlem Globetrotters
Peterborough Memorial Centre Peterborough Peterborough, ON
Apr 4, 7:00 pm 2019
Thursday
Apr 4
7:00 pm
Harlem Globetrotters
Peterborough Memorial Centre, Peterborough, ON
SELECT * from toolvenuepagelink WHERE venueid = 342
SELECT * from toolcitypagelink WHERE cityname = 'Hamilton'
Harlem Globetrotters
First Ontario Centre Hamilton Hamilton, ON
Apr 5, 7:00 pm 2019
Friday
Apr 5
7:00 pm
Harlem Globetrotters
First Ontario Centre, Hamilton, ON
SELECT * from toolvenuepagelink WHERE venueid = 2045
SELECT * from toolcitypagelink WHERE cityname = 'Providence'
Harlem Globetrotters
Dunkin Donuts Center Providence Providence, RI
Apr 6, 2:00 pm 2019
Saturday
Apr 6
2:00 pm
Harlem Globetrotters
Dunkin Donuts Center, Providence, RI
SELECT * from toolvenuepagelink WHERE venueid = 655
SELECT * from toolcitypagelink WHERE cityname = 'Mississauga'
Harlem Globetrotters
Hershey Centre Mississauga Mississauga, ON
Apr 6, 2:00 pm 2019
Saturday
Apr 6
2:00 pm
Harlem Globetrotters
Hershey Centre, Mississauga, ON
SELECT * from toolvenuepagelink WHERE venueid = 2045
SELECT * from toolcitypagelink WHERE cityname = 'Providence'
Harlem Globetrotters
Dunkin Donuts Center Providence Providence, RI
Apr 6, 7:00 pm 2019
Saturday
Apr 6
7:00 pm
Harlem Globetrotters
Dunkin Donuts Center, Providence, RI
SELECT * from toolvenuepagelink WHERE venueid = 655
SELECT * from toolcitypagelink WHERE cityname = 'Mississauga'
Harlem Globetrotters
Hershey Centre Mississauga Mississauga, ON
Apr 6, 7:00 pm 2019
Saturday
Apr 6
7:00 pm
Harlem Globetrotters
Hershey Centre, Mississauga, ON
SELECT * from toolvenuepagelink WHERE venueid = 2804
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Harlem Globetrotters
Coca-Cola Coliseum Toronto Toronto, ON
Apr 7, 2:00 pm 2019
Sunday
Apr 7
2:00 pm
Harlem Globetrotters
Coca-Cola Coliseum, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 1057
SELECT * from toolcitypagelink WHERE cityname = 'Amherst'
Harlem Globetrotters
Mullins Center Amherst Amherst, MA
Apr 7, 2:00 pm 2019
Sunday
Apr 7
2:00 pm
Harlem Globetrotters
Mullins Center, Amherst, MA
SELECT * from toolvenuepagelink WHERE venueid = 33891
SELECT * from toolcitypagelink WHERE cityname = 'Kingston'
Harlem Globetrotters
Leons Centre Kingston Kingston, ON
Apr 11, 7:00 pm 2019
Thursday
Apr 11
7:00 pm
Harlem Globetrotters
Leons Centre, Kingston, ON
SELECT * from toolvenuepagelink WHERE venueid = 506
SELECT * from toolcitypagelink WHERE cityname = 'Dubuque'
Harlem Globetrotters
Five Flags Center Dubuque Dubuque, IA
Apr 11, 7:00 pm 2019
Thursday
Apr 11
7:00 pm
Harlem Globetrotters
Five Flags Center, Dubuque, IA
SELECT * from toolvenuepagelink WHERE venueid = 31765
SELECT * from toolcitypagelink WHERE cityname = 'St Catharines'
Harlem Globetrotters
Meridian Centre St Catharines St Catharines, ON
Apr 12, 7:00 pm 2019
Friday
Apr 12
7:00 pm
Harlem Globetrotters
Meridian Centre, St Catharines, ON
SELECT * from toolvenuepagelink WHERE venueid = 2524
SELECT * from toolcitypagelink WHERE cityname = 'Cedar Rapids'
Harlem Globetrotters
US Cellular Center Cedar Rapids Cedar Rapids, IA
Apr 12, 7:00 pm 2019
Friday
Apr 12
7:00 pm
Harlem Globetrotters
US Cellular Center, Cedar Rapids, IA
SELECT * from toolvenuepagelink WHERE venueid = 926
SELECT * from toolcitypagelink WHERE cityname = 'Moline'
Harlem Globetrotters
TaxSlayer Center Moline Moline, IL
Apr 13, 2:00 pm 2019
Saturday
Apr 13
2:00 pm
Harlem Globetrotters
TaxSlayer Center, Moline, IL
SELECT * from toolvenuepagelink WHERE venueid = 5044
SELECT * from toolcitypagelink WHERE cityname = 'Oshawa'
Harlem Globetrotters
Tribute Communities Centre Oshawa Oshawa, ON
Apr 14, 2:00 pm 2019
Sunday
Apr 14
2:00 pm
Harlem Globetrotters
Tribute Communities Centre, Oshawa, ON
SELECT * from toolvenuepagelink WHERE venueid = 3536
SELECT * from toolcitypagelink WHERE cityname = 'Des Moines'
Harlem Globetrotters
Wells Fargo Arena - Des Moines Des Moines Des Moines, IA
Apr 14, 2:00 pm 2019
Sunday
Apr 14
2:00 pm
Harlem Globetrotters
Wells Fargo Arena - Des Moines, Des Moines, IA
SELECT * from toolvenuepagelink WHERE venueid = 30766
SELECT * from toolcitypagelink WHERE cityname = 'Sioux Falls'
Harlem Globetrotters
Denny Sanford Premier Center Sioux Falls Sioux Falls, SD
Apr 15, 7:00 pm 2019
Monday
Apr 15
7:00 pm
Harlem Globetrotters
Denny Sanford Premier Center, Sioux Falls, SD
SELECT * from toolvenuepagelink WHERE venueid = 2075
SELECT * from toolcitypagelink WHERE cityname = 'La Crosse'
Harlem Globetrotters
La Crosse Center La Crosse La Crosse, WI
Apr 16, 7:00 pm 2019
Tuesday
Apr 16
7:00 pm
Harlem Globetrotters
La Crosse Center, La Crosse, WI
SELECT * from toolvenuepagelink WHERE venueid = 1880
SELECT * from toolcitypagelink WHERE cityname = 'Grand Forks'
Harlem Globetrotters
Alerus Center Grand Forks Grand Forks, ND
Apr 18, 7:00 pm 2019
Thursday
Apr 18
7:00 pm
Harlem Globetrotters
Alerus Center, Grand Forks, ND
SELECT * from toolvenuepagelink WHERE venueid = 2322
SELECT * from toolcitypagelink WHERE cityname = 'Wildwood'

August

Harlem Globetrotters
Wildwood Convention Center Wildwood Wildwood, NJ
Aug 14, 7:00 pm 2019
Wednesday
Aug 14
7:00 pm
Harlem Globetrotters
Wildwood Convention Center, Wildwood, NJ
SELECT * from toolvenuepagelink WHERE venueid = 2322
SELECT * from toolcitypagelink WHERE cityname = 'Wildwood'
Harlem Globetrotters
Wildwood Convention Center Wildwood Wildwood, NJ
Aug 15, 7:00 pm 2019
Thursday
Aug 15
7:00 pm
Harlem Globetrotters
Wildwood Convention Center, Wildwood, NJ
SELECT * from toolvenuepagelink WHERE venueid = 2322
SELECT * from toolcitypagelink WHERE cityname = 'Wildwood'
Harlem Globetrotters
Wildwood Convention Center Wildwood Wildwood, NJ
Aug 16, 7:00 pm 2019
Friday
Aug 16
7:00 pm
Harlem Globetrotters
Wildwood Convention Center, Wildwood, NJ
SELECT * from toolvenuepagelink WHERE venueid = 2322
SELECT * from toolcitypagelink WHERE cityname = 'Wildwood'
Harlem Globetrotters
Wildwood Convention Center Wildwood Wildwood, NJ
Aug 17, 7:00 pm 2019
Saturday
Aug 17
7:00 pm
Harlem Globetrotters
Wildwood Convention Center, Wildwood, NJ
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football