LISTE POUR : New Kids on the Block

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

June

New Kids on the Block
Wells Fargo Arena - Des Moines Des Moines Des Moines, IA
Jun 9, 7:30 pm 2019
Sunday
Jun 9
7:30 pm
New Kids on the Block
Wells Fargo Arena - Des Moines, Des Moines, IA
SELECT * from toolvenuepagelink WHERE venueid = 1811
SELECT * from toolcitypagelink WHERE cityname = 'St Paul'
New Kids on the Block
Xcel Energy Center St Paul St Paul, MN
Jun 11, 7:30 pm 2019
Tuesday
Jun 11
7:30 pm
New Kids on the Block
Xcel Energy Center, St Paul, MN
SELECT * from toolvenuepagelink WHERE venueid = 33662
SELECT * from toolcitypagelink WHERE cityname = 'Milwaukee'
New Kids on the Block
Fiserv Forum Milwaukee Milwaukee, WI
Jun 12, 7:30 pm 2019
Wednesday
Jun 12
7:30 pm
New Kids on the Block
Fiserv Forum, Milwaukee, WI
SELECT * from toolvenuepagelink WHERE venueid = 1663
SELECT * from toolcitypagelink WHERE cityname = 'Grand Rapids'
New Kids on the Block
Van Andel Arena Grand Rapids Grand Rapids, MI
Jun 13, 7:30 pm 2019
Thursday
Jun 13
7:30 pm
New Kids on the Block
Van Andel Arena, Grand Rapids, MI
SELECT * from toolvenuepagelink WHERE venueid = 33
SELECT * from toolcitypagelink WHERE cityname = 'Rosemont'
New Kids on the Block
Allstate Arena Rosemont Rosemont, IL
Jun 14, 8:00 pm 2019
Friday
Jun 14
8:00 pm
New Kids on the Block
Allstate Arena, Rosemont, IL
SELECT * from toolvenuepagelink WHERE venueid = 33
SELECT * from toolcitypagelink WHERE cityname = 'Rosemont'
New Kids on the Block
Allstate Arena Rosemont Rosemont, IL
Jun 15, 8:00 pm 2019
Saturday
Jun 15
8:00 pm
New Kids on the Block
Allstate Arena, Rosemont, IL
SELECT * from toolvenuepagelink WHERE venueid = 33422
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
New Kids on the Block
Little Caesars Arena Detroit Detroit, MI
Jun 18, 7:30 pm 2019
Tuesday
Jun 18
7:30 pm
New Kids on the Block
Little Caesars Arena, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 17
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
New Kids on the Block
Scotiabank Arena Toronto Toronto, ON
Jun 19, 7:30 pm 2019
Wednesday
Jun 19
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 1786
SELECT * from toolcitypagelink WHERE cityname = 'Buffalo'
New Kids on the Block
KeyBank Center Buffalo Buffalo, NY
Jun 21, 8:00 pm 2019
Friday
Jun 21
8:00 pm
New Kids on the Block
KeyBank Center, Buffalo, NY
SELECT * from toolvenuepagelink WHERE venueid = 33304
SELECT * from toolcitypagelink WHERE cityname = 'Columbus'
New Kids on the Block
Value City Arena at the Jerome Schottenstein Center Columbus Columbus, OH
Jun 22, 8:00 pm 2019
Saturday
Jun 22
8:00 pm
New Kids on the Block
Value City Arena at the Jerome Schottenstein Center, Columbus, OH
SELECT * from toolvenuepagelink WHERE venueid = 7329
SELECT * from toolcitypagelink WHERE cityname = 'Pittsburgh'
New Kids on the Block
PPG Paints Arena Pittsburgh Pittsburgh, PA
Jun 23, 7:30 pm 2019
Sunday
Jun 23
7:30 pm
New Kids on the Block
PPG Paints Arena, Pittsburgh, PA
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
New Kids on the Block
Capital One Arena Washington Washington, DC
Jun 25, 7:30 pm 2019
Tuesday
Jun 25
7:30 pm
New Kids on the Block
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 499
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
New Kids on the Block
Wells Fargo Center Philadelphia Philadelphia, PA
Jun 27, 7:30 pm 2019
Thursday
Jun 27
7:30 pm
New Kids on the Block
Wells Fargo Center, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 507
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
New Kids on the Block
TD Garden Boston Boston, MA
Jun 28, 8:00 pm 2019
Friday
Jun 28
8:00 pm
New Kids on the Block
TD Garden, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 507
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
New Kids on the Block
TD Garden Boston Boston, MA
Jun 29, 8:00 pm 2019
Saturday
Jun 29
8:00 pm
New Kids on the Block
TD Garden, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 1082
SELECT * from toolcitypagelink WHERE cityname = 'Uniondale'
New Kids on the Block
The New Coliseum Uniondale Uniondale, NY
Jun 30, 7:30 pm 2019
Sunday
Jun 30
7:30 pm
New Kids on the Block
The New Coliseum, Uniondale, NY
SELECT * from toolvenuepagelink WHERE venueid = 4797
SELECT * from toolcitypagelink WHERE cityname = 'Newark'

July

New Kids on the Block
Prudential Center Newark Newark, NJ
Jul 2, 7:30 pm 2019
Tuesday
Jul 2
7:30 pm
New Kids on the Block
Prudential Center, Newark, NJ
SELECT * from toolvenuepagelink WHERE venueid = 2061
SELECT * from toolcitypagelink WHERE cityname = 'Uncasville'
New Kids on the Block
Mohegan Sun Arena Uncasville Uncasville, CT
Jul 3, 7:30 pm 2019
Wednesday
Jul 3
7:30 pm
New Kids on the Block
Mohegan Sun Arena, Uncasville, CT
SELECT * from toolvenuepagelink WHERE venueid = 2730
SELECT * from toolcitypagelink WHERE cityname = 'Atlantic City'
New Kids on the Block
Borgata Casino Event Center Atlantic City Atlantic City, NJ
Jul 5, 8:00 pm 2019
Friday
Jul 5
8:00 pm
New Kids on the Block
Borgata Casino Event Center, Atlantic City, NJ
SELECT * from toolvenuepagelink WHERE venueid = 657
SELECT * from toolcitypagelink WHERE cityname = 'Hershey'
New Kids on the Block
Hersheypark Stadium Hershey Hershey, PA
Jul 6, 7:30 pm 2019
Saturday
Jul 6
7:30 pm
New Kids on the Block
Hersheypark Stadium, Hershey, PA
SELECT * from toolvenuepagelink WHERE venueid = 1278
SELECT * from toolcitypagelink WHERE cityname = 'Raleigh'
New Kids on the Block
PNC Arena Raleigh Raleigh, NC
Jul 7, 7:30 pm 2019
Sunday
Jul 7
7:30 pm
New Kids on the Block
PNC Arena, Raleigh, NC
SELECT * from toolvenuepagelink WHERE venueid = 3535
SELECT * from toolcitypagelink WHERE cityname = 'Charlotte'
New Kids on the Block
Spectrum Center Charlotte Charlotte, NC
Jul 9, 7:30 pm 2019
Tuesday
Jul 9
7:30 pm
New Kids on the Block
Spectrum Center, Charlotte, NC
SELECT * from toolvenuepagelink WHERE venueid = 141
SELECT * from toolcitypagelink WHERE cityname = 'Greenville'
New Kids on the Block
Bon Secours Wellness Arena Greenville Greenville, SC
Jul 10, 7:30 pm 2019
Wednesday
Jul 10
7:30 pm
New Kids on the Block
Bon Secours Wellness Arena, Greenville, SC
SELECT * from toolvenuepagelink WHERE venueid = 1228
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
New Kids on the Block
State Farm Arena - GA Atlanta Atlanta, GA
Jul 11, 7:30 pm 2019
Thursday
Jul 11
7:30 pm
New Kids on the Block
State Farm Arena - GA, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 2842
SELECT * from toolcitypagelink WHERE cityname = 'Jacksonville'
New Kids on the Block
Vystar Veterans Memorial Arena Jacksonville Jacksonville, FL
Jul 12, 8:00 pm 2019
Friday
Jul 12
8:00 pm
New Kids on the Block
Vystar Veterans Memorial Arena, Jacksonville, FL
SELECT * from toolvenuepagelink WHERE venueid = 1537
SELECT * from toolcitypagelink WHERE cityname = 'Orlando'
New Kids on the Block
Amway Center Orlando Orlando, FL
Jul 13, 8:00 pm 2019
Saturday
Jul 13
8:00 pm
New Kids on the Block
Amway Center, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 1085
SELECT * from toolcitypagelink WHERE cityname = 'Sunrise'
New Kids on the Block
BB&T Center Sunrise Sunrise, FL
Jul 14, 7:30 pm 2019
Sunday
Jul 14
7:30 pm
New Kids on the Block
BB&T Center, Sunrise, FL
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football
NOUVELLES - SPORT