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 = 501
SELECT * from toolcitypagelink WHERE cityname = 'Cincinnati'

May

New Kids on the Block
U.S. Bank Arena Cincinnati Cincinnati, OH
May 2, 7:30 pm 2019
Thursday
May 2
7:30 pm
New Kids on the Block
U.S. Bank Arena, Cincinnati, OH
SELECT * from toolvenuepagelink WHERE venueid = 614
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
New Kids on the Block
Quicken Loans Arena Cleveland Cleveland, OH
May 4, 8:00 pm 2019
Saturday
May 4
8:00 pm
New Kids on the Block
Quicken Loans Arena, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 324
SELECT * from toolcitypagelink WHERE cityname = 'Indianapolis'
New Kids on the Block
Bankers Life Fieldhouse Indianapolis Indianapolis, IN
May 5, 7:30 pm 2019
Sunday
May 5
7:30 pm
New Kids on the Block
Bankers Life Fieldhouse, Indianapolis, IN
SELECT * from toolvenuepagelink WHERE venueid = 4603
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
New Kids on the Block
Sprint Center Kansas City Kansas City, MO
May 7, 7:30 pm 2019
Tuesday
May 7
7:30 pm
New Kids on the Block
Sprint Center, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 785
SELECT * from toolcitypagelink WHERE cityname = 'St Louis'
New Kids on the Block
Enterprise Center St Louis St Louis, MO
May 8, 7:30 pm 2019
Wednesday
May 8
7:30 pm
New Kids on the Block
Enterprise Center, St Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 1080
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
New Kids on the Block
Bridgestone Arena Nashville Nashville, TN
May 9, 7:30 pm 2019
Thursday
May 9
7:30 pm
New Kids on the Block
Bridgestone Arena, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 3123
SELECT * from toolcitypagelink WHERE cityname = 'Memphis'
New Kids on the Block
FedEx Forum Memphis Memphis, TN
May 10, 8:00 pm 2019
Friday
May 10
8:00 pm
New Kids on the Block
FedEx Forum, Memphis, TN
SELECT * from toolvenuepagelink WHERE venueid = 1103
SELECT * from toolcitypagelink WHERE cityname = 'New Orleans'
New Kids on the Block
Smoothie King Center New Orleans New Orleans, LA
May 11, 8:00 pm 2019
Saturday
May 11
8:00 pm
New Kids on the Block
Smoothie King Center, New Orleans, LA
SELECT * from toolvenuepagelink WHERE venueid = 8004
SELECT * from toolcitypagelink WHERE cityname = 'Corpus Christi'
New Kids on the Block
American Bank Center Arena Corpus Christi Corpus Christi, TX
May 13, 7:30 pm 2019
Monday
May 13
7:30 pm
New Kids on the Block
American Bank Center Arena, Corpus Christi, TX
SELECT * from toolvenuepagelink WHERE venueid = 2786
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
New Kids on the Block
Toyota Center Houston Houston, TX
May 15, 7:30 pm 2019
Wednesday
May 15
7:30 pm
New Kids on the Block
Toyota Center, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 2259
SELECT * from toolcitypagelink WHERE cityname = 'San Antonio'
New Kids on the Block
AT&T Center San Antonio San Antonio, TX
May 16, 7:30 pm 2019
Thursday
May 16
7:30 pm
New Kids on the Block
AT&T Center, San Antonio, TX
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
New Kids on the Block
American Airlines Center Dallas Dallas, TX
May 17, 8:00 pm 2019
Friday
May 17
8:00 pm
New Kids on the Block
American Airlines Center, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 2196
SELECT * from toolcitypagelink WHERE cityname = 'Oklahoma City'
New Kids on the Block
Chesapeake Energy Arena Oklahoma City Oklahoma City, OK
May 18, 8:00 pm 2019
Saturday
May 18
8:00 pm
New Kids on the Block
Chesapeake Energy Arena, Oklahoma City, OK
SELECT * from toolvenuepagelink WHERE venueid = 1919
SELECT * from toolcitypagelink WHERE cityname = 'El Paso'
New Kids on the Block
Don Haskins Center El Paso El Paso, TX
May 21, 7:30 pm 2019
Tuesday
May 21
7:30 pm
New Kids on the Block
Don Haskins Center, El Paso, TX
SELECT * from toolvenuepagelink WHERE venueid = 43
SELECT * from toolcitypagelink WHERE cityname = 'Phoenix'
New Kids on the Block
Talking Stick Resort Arena Phoenix Phoenix, AZ
May 22, 7:30 pm 2019
Wednesday
May 22
7:30 pm
New Kids on the Block
Talking Stick Resort Arena, Phoenix, AZ
SELECT * from toolvenuepagelink WHERE venueid = 362
SELECT * from toolcitypagelink WHERE cityname = 'San Diego'
New Kids on the Block
Viejas Arena San Diego San Diego, CA
May 23, 7:30 pm 2019
Thursday
May 23
7:30 pm
New Kids on the Block
Viejas Arena, San Diego, CA
SELECT * from toolvenuepagelink WHERE venueid = 66
SELECT * from toolcitypagelink WHERE cityname = 'Anaheim'
New Kids on the Block
Honda Center Anaheim Anaheim, CA
May 24, 8:00 pm 2019
Friday
May 24
8:00 pm
New Kids on the Block
Honda Center, Anaheim, CA
SELECT * from toolvenuepagelink WHERE venueid = 3571
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'
New Kids on the Block
Mandalay Bay Events Center Las Vegas Las Vegas, NV
May 25, 8:00 pm 2019
Saturday
May 25
8:00 pm
New Kids on the Block
Mandalay Bay Events Center, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 667
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
New Kids on the Block
Hollywood Bowl Los Angeles Los Angeles, CA
May 26, 7:00 pm 2019
Sunday
May 26
7:00 pm
New Kids on the Block
Hollywood Bowl, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 3501
SELECT * from toolcitypagelink WHERE cityname = 'Bakersfield'
New Kids on the Block
Rabobank Arena Bakersfield Bakersfield, CA
May 28, 7:30 pm 2019
Tuesday
May 28
7:30 pm
New Kids on the Block
Rabobank Arena, Bakersfield, CA
SELECT * from toolvenuepagelink WHERE venueid = 1384
SELECT * from toolcitypagelink WHERE cityname = 'San Jose'
New Kids on the Block
SAP Center at San Jose San Jose San Jose, CA
May 29, 7:30 pm 2019
Wednesday
May 29
7:30 pm
New Kids on the Block
SAP Center at San Jose, San Jose, CA
SELECT * from toolvenuepagelink WHERE venueid = 32836
SELECT * from toolcitypagelink WHERE cityname = 'Sacramento'
New Kids on the Block
Golden 1 Center Sacramento Sacramento, CA
May 30, 7:30 pm 2019
Thursday
May 30
7:30 pm
New Kids on the Block
Golden 1 Center, Sacramento, CA
SELECT * from toolvenuepagelink WHERE venueid = 1526
SELECT * from toolcitypagelink WHERE cityname = 'Tacoma'

June

New Kids on the Block
Tacoma Dome Tacoma Tacoma, WA
Jun 1, 8:00 pm 2019
Saturday
Jun 1
8:00 pm
New Kids on the Block
Tacoma Dome, Tacoma, WA
SELECT * from toolvenuepagelink WHERE venueid = 1343
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
New Kids on the Block
Moda Center Portland Portland, OR
Jun 2, 7:30 pm 2019
Sunday
Jun 2
7:30 pm
New Kids on the Block
Moda Center, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 2162
SELECT * from toolcitypagelink WHERE cityname = 'Boise'
New Kids on the Block
Taco Bell Arena Boise Boise, ID
Jun 4, 7:30 pm 2019
Tuesday
Jun 4
7:30 pm
New Kids on the Block
Taco Bell Arena, Boise, ID
SELECT * from toolvenuepagelink WHERE venueid = 399
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
New Kids on the Block
Vivint Smart Home Arena Salt Lake City Salt Lake City, UT
Jun 6, 7:30 pm 2019
Thursday
Jun 6
7:30 pm
New Kids on the Block
Vivint Smart Home Arena, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 1219
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
New Kids on the Block
Pepsi Center Denver Denver, CO
Jun 7, 8:00 pm 2019
Friday
Jun 7
8:00 pm
New Kids on the Block
Pepsi Center, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 30074
SELECT * from toolcitypagelink WHERE cityname = 'Lincoln'
New Kids on the Block
Pinnacle Bank Arena Lincoln Lincoln, NE
Jun 8, 8:00 pm 2019
Saturday
Jun 8
8:00 pm
New Kids on the Block
Pinnacle Bank Arena, Lincoln, NE
SELECT * from toolvenuepagelink WHERE venueid = 3536
SELECT * from toolcitypagelink WHERE cityname = 'Des Moines'
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