LISTE POUR : KIDZ BOP Live

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

May

Kidz Bop
Cal Coast Credit Union Open Air Theatre at SDSU San Diego San Diego, CA
May 31, 7:00 pm 2019
Friday
May 31
7:00 pm
Kidz Bop
Cal Coast Credit Union Open Air Theatre at SDSU, San Diego, CA
SELECT * from toolvenuepagelink WHERE venueid = 667
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'

June

Kidz Bop
Hollywood Bowl Los Angeles Los Angeles, CA
Jun 1, 6:00 pm 2019
Saturday
Jun 1
6:00 pm
Kidz Bop
Hollywood Bowl, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 6452
SELECT * from toolcitypagelink WHERE cityname = 'Cedar Park'
Kidz Bop
H-E-B Center Cedar Park Cedar Park, TX
Jun 7, 7:00 pm 2019
Friday
Jun 7
7:00 pm
Kidz Bop
H-E-B Center, Cedar Park, TX
SELECT * from toolvenuepagelink WHERE venueid = 6452
SELECT * from toolcitypagelink WHERE cityname = 'Cedar Park'
Kidz Bop Live
H-E-B Center Cedar Park Cedar Park, TX
Jun 7, 7:00 pm 2019
Friday
Jun 7
7:00 pm
Kidz Bop Live
H-E-B Center, Cedar Park, TX
SELECT * from toolvenuepagelink WHERE venueid = 33479
SELECT * from toolcitypagelink WHERE cityname = 'Irving'
Kidz Bop Live!
The Pavilion at Irving Music Factory Irving Irving, TX
Jun 8, 6:00 pm 2019
Saturday
Jun 8
6:00 pm
Kidz Bop Live!
The Pavilion at Irving Music Factory, Irving, TX
SELECT * from toolvenuepagelink WHERE venueid = 1760
SELECT * from toolcitypagelink WHERE cityname = 'Spring'
Kidz Bop - Spring
The Cynthia Woods Mitchell Pavilion Spring Spring, TX
Jun 9, 4:00 pm 2019
Sunday
Jun 9
4:00 pm
Kidz Bop - Spring
The Cynthia Woods Mitchell Pavilion, Spring, TX
SELECT * from toolvenuepagelink WHERE venueid = 5118
SELECT * from toolcitypagelink WHERE cityname = 'Tulsa'
Kidz Bop
BOK Center Tulsa Tulsa, OK
Jun 14, 7:00 pm 2019
Friday
Jun 14
7:00 pm
Kidz Bop
BOK Center, Tulsa, OK
SELECT * from toolvenuepagelink WHERE venueid = 4521
SELECT * from toolcitypagelink WHERE cityname = 'Maryland Heights'
Kidz Bop
Hollywood Casino Amphitheatre - MO Maryland Heights Maryland Heights, MO
Jun 15, 6:00 pm 2019
Saturday
Jun 15
6:00 pm
Kidz Bop
Hollywood Casino Amphitheatre - MO, Maryland Heights, MO
SELECT * from toolvenuepagelink WHERE venueid = 28555
SELECT * from toolcitypagelink WHERE cityname = 'Lincoln'
Kidz Bop
Pinewood Bowl Theater Lincoln Lincoln, NE
Jun 16, 4:00 pm 2019
Sunday
Jun 16
4:00 pm
Kidz Bop
Pinewood Bowl Theater, Lincoln, NE
SELECT * from toolvenuepagelink WHERE venueid = 32170
SELECT * from toolcitypagelink WHERE cityname = 'Huber Heights'
Kidz Bop
The Rose Music Center at The Heights Huber Heights Huber Heights, OH
Jun 21, 7:00 pm 2019
Friday
Jun 21
7:00 pm
Kidz Bop
The Rose Music Center at The Heights, Huber Heights, OH
SELECT * from toolvenuepagelink WHERE venueid = 1963
SELECT * from toolcitypagelink WHERE cityname = 'Clarkston'
Kidz Bop
DTE Energy Music Theatre Clarkston Clarkston, MI
Jun 22, 6:00 pm 2019
Saturday
Jun 22
6:00 pm
Kidz Bop
DTE Energy Music Theatre, Clarkston, MI
SELECT * from toolvenuepagelink WHERE venueid = 1035
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Kidz Bop
Budweiser Stage Toronto Toronto, ON
Jun 23, 4:00 pm 2019
Sunday
Jun 23
4:00 pm
Kidz Bop
Budweiser Stage, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 30669
SELECT * from toolcitypagelink WHERE cityname = 'Cedar Rapids'
Kidz Bop
McGrath Amphitheatre Cedar Rapids Cedar Rapids, IA
Jun 28, 7:00 pm 2019
Friday
Jun 28
7:00 pm
Kidz Bop
McGrath Amphitheatre, Cedar Rapids, IA
SELECT * from toolvenuepagelink WHERE venueid = 3133
SELECT * from toolcitypagelink WHERE cityname = 'Indianapolis'
Kidz Bop
The Farm Bureau Insurance Lawn at White River State Park Indianapolis Indianapolis, IN
Jun 29, 6:00 pm 2019
Saturday
Jun 29
6:00 pm
Kidz Bop
The Farm Bureau Insurance Lawn at White River State Park, Indianapolis, IN
SELECT * from toolvenuepagelink WHERE venueid = 1953
SELECT * from toolcitypagelink WHERE cityname = 'Charlotte'
Kidz Bop Live
PNC Music Pavilion - Charlotte Charlotte Charlotte, NC
Jun 30, 4:00 pm 2019
Sunday
Jun 30
4:00 pm
Kidz Bop Live
PNC Music Pavilion - Charlotte, Charlotte, NC
SELECT * from toolvenuepagelink WHERE venueid = 1041
SELECT * from toolcitypagelink WHERE cityname = 'Scranton'

July

Kidz Bop
Toyota Pavilion At Montage Mountain Scranton Scranton, PA
Jul 5, 7:00 pm 2019
Friday
Jul 5
7:00 pm
Kidz Bop
Toyota Pavilion At Montage Mountain, Scranton, PA
SELECT * from toolvenuepagelink WHERE venueid = 963
SELECT * from toolcitypagelink WHERE cityname = 'Gilford'
Kidz Bop Live!
Bank of New Hampshire Pavilion at Meadowbrook Gilford Gilford, NH
Jul 6, 6:00 pm 2019
Saturday
Jul 6
6:00 pm
Kidz Bop Live!
Bank of New Hampshire Pavilion at Meadowbrook, Gilford, NH
SELECT * from toolvenuepagelink WHERE venueid = 381
SELECT * from toolcitypagelink WHERE cityname = 'Darien Center'
Kidz Bop
Darien Lake Performing Arts Center Darien Center Darien Center, NY
Jul 7, 4:00 pm 2019
Sunday
Jul 7
4:00 pm
Kidz Bop
Darien Lake Performing Arts Center, Darien Center, NY
SELECT * from toolvenuepagelink WHERE venueid = 1618
SELECT * from toolcitypagelink WHERE cityname = 'Mansfield'
Kidz Bop
Xfinity Center Mansfield Mansfield, MA
Jul 13, 6:00 pm 2019
Saturday
Jul 13
6:00 pm
Kidz Bop
Xfinity Center, Mansfield, MA
SELECT * from toolvenuepagelink WHERE venueid = 1113
SELECT * from toolcitypagelink WHERE cityname = 'Bristow'
Kidz Bop Live!
Jiffy Lube Live Bristow Bristow, VA
Jul 14, 4:00 pm 2019
Sunday
Jul 14
4:00 pm
Kidz Bop Live!
Jiffy Lube Live, Bristow, VA
SELECT * from toolvenuepagelink WHERE venueid = 220
SELECT * from toolcitypagelink WHERE cityname = 'Hyannis'
Kidz Bop Live!
Cape Cod Melody Tent Hyannis Hyannis, MA
Jul 18, 6:00 pm 2019
Thursday
Jul 18
6:00 pm
Kidz Bop Live!
Cape Cod Melody Tent, Hyannis, MA
SELECT * from toolvenuepagelink WHERE venueid = 155
SELECT * from toolcitypagelink WHERE cityname = 'Camden'
Kidz Bop
BB&T Pavilion Camden Camden, NJ
Jul 19, 7:00 pm 2019
Friday
Jul 19
7:00 pm
Kidz Bop
BB&T Pavilion, Camden, NJ
SELECT * from toolvenuepagelink WHERE venueid = 756
SELECT * from toolcitypagelink WHERE cityname = 'Wantagh'
Kidz Bop
Northwell Health at Jones Beach Theater Wantagh Wantagh, NY
Jul 21, 4:00 pm 2019
Sunday
Jul 21
4:00 pm
Kidz Bop
Northwell Health at Jones Beach Theater, Wantagh, NY
SELECT * from toolvenuepagelink WHERE venueid = 2379
SELECT * from toolcitypagelink WHERE cityname = 'Hershey'
Kidz Bop
Giant Center Hershey Hershey, PA
Jul 26, 7:00 pm 2019
Friday
Jul 26
7:00 pm
Kidz Bop
Giant Center, Hershey, PA
SELECT * from toolvenuepagelink WHERE venueid = 32674
SELECT * from toolcitypagelink WHERE cityname = 'Syracuse'
Kidz Bop
Lakeview Amphitheater Syracuse Syracuse, NY
Jul 27, 6:00 pm 2019
Saturday
Jul 27
6:00 pm
Kidz Bop
Lakeview Amphitheater, Syracuse, NY
SELECT * from toolvenuepagelink WHERE venueid = 1390
SELECT * from toolcitypagelink WHERE cityname = 'Saratoga Springs'
Kidz Bop
Saratoga Performing Arts Center Saratoga Springs Saratoga Springs, NY
Jul 28, 4:00 pm 2019
Sunday
Jul 28
4:00 pm
Kidz Bop
Saratoga Performing Arts Center, Saratoga Springs, NY
SELECT * from toolvenuepagelink WHERE venueid = 35
SELECT * from toolcitypagelink WHERE cityname = 'Raleigh'

August

Kidz Bop Live!
Coastal Credit Union Music Park at Walnut Creek Raleigh Raleigh, NC
Aug 2, 7:00 pm 2019
Friday
Aug 2
7:00 pm
Kidz Bop Live!
Coastal Credit Union Music Park at Walnut Creek, Raleigh, NC
SELECT * from toolvenuepagelink WHERE venueid = 1798
SELECT * from toolcitypagelink WHERE cityname = 'Baltimore'
Kidz Bop
MECU Pavilion Baltimore Baltimore, MD
Aug 3, 6:00 pm 2019
Saturday
Aug 3
6:00 pm
Kidz Bop
MECU Pavilion, Baltimore, MD
SELECT * from toolvenuepagelink WHERE venueid = 2640
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
Kidz Bop
Jacobs Pavilion at Nautica Cleveland Cleveland, OH
Aug 4, 4:00 pm 2019
Sunday
Aug 4
4:00 pm
Kidz Bop
Jacobs Pavilion at Nautica, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 1816
SELECT * from toolcitypagelink WHERE cityname = 'West Allis'
Kidz Bop Live!
Wisconsin State Fair West Allis West Allis, WI
Aug 6, 7:00 pm 2019
Tuesday
Aug 6
7:00 pm
Kidz Bop Live!
Wisconsin State Fair, West Allis, WI
SELECT * from toolvenuepagelink WHERE venueid = 1996
SELECT * from toolcitypagelink WHERE cityname = 'Virginia Beach'
Kidz Bop Live!
Veterans United Home Loans Amphitheater Virginia Beach Virginia Beach, VA
Aug 9, 12:00 pm 2019
Friday
Aug 9
12:00 pm
Kidz Bop Live!
Veterans United Home Loans Amphitheater, Virginia Beach, VA
SELECT * from toolvenuepagelink WHERE venueid = 1996
SELECT * from toolcitypagelink WHERE cityname = 'Virginia Beach'
Kidz Bop Live!
Veterans United Home Loans Amphitheater Virginia Beach Virginia Beach, VA
Aug 9, 6:00 pm 2019
Friday
Aug 9
6:00 pm
Kidz Bop Live!
Veterans United Home Loans Amphitheater, Virginia Beach, VA
SELECT * from toolvenuepagelink WHERE venueid = 5261
SELECT * from toolcitypagelink WHERE cityname = 'Alpharetta'
Kidz Bop Live!
Ameris Bank Amphitheatre Alpharetta Alpharetta, GA
Aug 10, 6:00 pm 2019
Saturday
Aug 10
6:00 pm
Kidz Bop Live!
Ameris Bank Amphitheatre, Alpharetta, GA
SELECT * from toolvenuepagelink WHERE venueid = 1953
SELECT * from toolcitypagelink WHERE cityname = 'Charlotte'
Kidz Bop Live!
PNC Music Pavilion - Charlotte Charlotte Charlotte, NC
Aug 11, 4:00 pm 2019
Sunday
Aug 11
4:00 pm
Kidz Bop Live!
PNC Music Pavilion - Charlotte, Charlotte, NC
SELECT * from toolvenuepagelink WHERE venueid = 33677
SELECT * from toolcitypagelink WHERE cityname = 'Brandon'
Kidz Bop
Brandon Amphitheater Brandon Brandon, MS
Aug 16, 7:00 pm 2019
Friday
Aug 16
7:00 pm
Kidz Bop
Brandon Amphitheater, Brandon, MS
SELECT * from toolvenuepagelink WHERE venueid = 7682
SELECT * from toolcitypagelink WHERE cityname = 'Tuscaloosa'
Kidz Bop Live!
Tuscaloosa Amphitheater Tuscaloosa Tuscaloosa, AL
Aug 17, 6:00 pm 2019
Saturday
Aug 17
6:00 pm
Kidz Bop Live!
Tuscaloosa Amphitheater, Tuscaloosa, AL
SELECT * from toolvenuepagelink WHERE venueid = 2013
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Kidz Bop
Starlight Theatre Kansas City Kansas City, MO
Aug 23, 7:00 pm 2019
Friday
Aug 23
7:00 pm
Kidz Bop
Starlight Theatre, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 28704
SELECT * from toolcitypagelink WHERE cityname = 'Mankato'
Kidz Bop Live!
Vetter Stone Amphitheater Mankato Mankato, MN
Aug 24, 6:00 pm 2019
Saturday
Aug 24
6:00 pm
Kidz Bop Live!
Vetter Stone Amphitheater, Mankato, MN
SELECT * from toolvenuepagelink WHERE venueid = 1105
SELECT * from toolcitypagelink WHERE cityname = 'Tinley Park'
Kidz Bop
Hollywood Casino Amphitheatre - IL Tinley Park Tinley Park, IL
Aug 25, 4:00 pm 2019
Sunday
Aug 25
4:00 pm
Kidz Bop
Hollywood Casino Amphitheatre - IL, Tinley Park, IL
SELECT * from toolvenuepagelink WHERE venueid = 1290
SELECT * from toolcitypagelink WHERE cityname = 'Morrison'

September

Kidz Bop
Red Rocks Amphitheatre Morrison Morrison, CO
Sep 1, 4:00 pm 2019
Sunday
Sep 1
4:00 pm
Kidz Bop
Red Rocks Amphitheatre, Morrison, CO
SELECT * from toolvenuepagelink WHERE venueid = 33555
SELECT * from toolcitypagelink WHERE cityname = 'Irvine'
Kidz Bop
FivePoint Amphitheatre Irvine Irvine, CA
Sep 7, 6:00 pm 2019
Saturday
Sep 7
6:00 pm
Kidz Bop
FivePoint Amphitheatre, Irvine, CA
SELECT * from toolvenuepagelink WHERE venueid = 1418
SELECT * from toolcitypagelink WHERE cityname = 'Mountain View'
Kidz Bop Live!
Shoreline Amphitheatre - CA Mountain View Mountain View, CA
Sep 8, 4:00 pm 2019
Sunday
Sep 8
4:00 pm
Kidz Bop Live!
Shoreline Amphitheatre - CA, Mountain View, CA
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football