LISTE POUR : Rainbow Kitten Surprise

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

June

Rainbow Kitten Surprise
Red Rocks Amphitheatre Morrison Morrison, CO
Jun 11, 7:00 pm 2019
Tuesday
Jun 11
7:00 pm
Rainbow Kitten Surprise
Red Rocks Amphitheatre, Morrison, CO
SELECT * from toolvenuepagelink WHERE venueid = 4341
SELECT * from toolcitypagelink WHERE cityname = 'Aspen'

August

Rainbow Kitten Surprise
Belly Up Aspen Aspen Aspen, CO
Aug 17, 9:00 pm 2019
Saturday
Aug 17
9:00 pm
Rainbow Kitten Surprise
Belly Up Aspen, Aspen, CO
SELECT * from toolvenuepagelink WHERE venueid = 32234
SELECT * from toolcitypagelink WHERE cityname = 'New Haven'

September

Rainbow Kitten Surprise
College Street Music Hall New Haven New Haven, CT
Sep 20, 8:00 pm 2019
Friday
Sep 20
8:00 pm
Rainbow Kitten Surprise
College Street Music Hall, New Haven, CT
SELECT * from toolvenuepagelink WHERE venueid = 30675
SELECT * from toolcitypagelink WHERE cityname = 'Bethlehem'
Rainbow Kitten Surprise
Levitt Pavilion at SteelStacks Bethlehem Bethlehem, PA
Sep 22, 8:00 pm 2019
Sunday
Sep 22
8:00 pm
Rainbow Kitten Surprise
Levitt Pavilion at SteelStacks, Bethlehem, PA
SELECT * from toolvenuepagelink WHERE venueid = 1490
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
Rainbow Kitten Surprise
The Fillmore Detroit Detroit Detroit, MI
Sep 25, 6:30 pm 2019
Wednesday
Sep 25
6:30 pm
Rainbow Kitten Surprise
The Fillmore Detroit, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 8847
SELECT * from toolcitypagelink WHERE cityname = 'Charlotte'
Rainbow Kitten Surprise
Charlotte Metro Credit Union Amphitheatre Charlotte Charlotte, NC
Sep 27, 8:00 pm 2019
Friday
Sep 27
8:00 pm
Rainbow Kitten Surprise
Charlotte Metro Credit Union Amphitheatre, Charlotte, NC
SELECT * from toolvenuepagelink WHERE venueid = 681
SELECT * from toolcitypagelink WHERE cityname = 'Orlando'
Rainbow Kitten Surprise
House of Blues - Orlando Orlando Orlando, FL
Sep 30, 8:00 pm 2019
Monday
Sep 30
8:00 pm
Rainbow Kitten Surprise
House of Blues - Orlando, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 1842
SELECT * from toolcitypagelink WHERE cityname = 'Athens'

October

Rainbow Kitten Surprise
Georgia Theatre Athens Athens, GA
Oct 3, 8:00 pm 2019
Thursday
Oct 3
8:00 pm
Rainbow Kitten Surprise
Georgia Theatre, Athens, GA
SELECT * from toolvenuepagelink WHERE venueid = 1842
SELECT * from toolcitypagelink WHERE cityname = 'Athens'
Rainbow Kitten Surprise
Georgia Theatre Athens Athens, GA
Oct 4, 8:00 pm 2019
Friday
Oct 4
8:00 pm
Rainbow Kitten Surprise
Georgia Theatre, Athens, GA
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football