LISTE POUR : Red Hot Chili Peppers

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

June

Red Hot Chili Peppers
First Ontario Centre Hamilton Hamilton, ON
Jun 22, 8:00 pm 2017
Thursday
Jun 22
8:00 pm
Red Hot Chili Peppers
First Ontario Centre, Hamilton, ON
SELECT * from toolvenuepagelink WHERE venueid = 345
SELECT * from toolcitypagelink WHERE cityname = 'Kanata'
Red Hot Chili Peppers
Canadian Tire Centre Kanata Kanata, ON
Jun 23, 8:00 pm 2017
Friday
Jun 23
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 1663
SELECT * from toolcitypagelink WHERE cityname = 'Grand Rapids'
Red Hot Chili Peppers
Van Andel Arena Grand Rapids Grand Rapids, MI
Jun 25, 8:00 pm 2017
Sunday
Jun 25
8:00 pm
Red Hot Chili Peppers
Van Andel Arena, Grand Rapids, MI
SELECT * from toolvenuepagelink WHERE venueid = 920
SELECT * from toolcitypagelink WHERE cityname = 'Milwaukee'
Red Hot Chili Peppers
American Family Insurance Amphitheater Milwaukee Milwaukee, WI
Jun 28, 7:30 pm 2017
Wednesday
Jun 28
7:30 pm
Red Hot Chili Peppers
American Family Insurance Amphitheater, Milwaukee, WI
SELECT * from toolvenuepagelink WHERE venueid = 1633
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Red Hot Chili Peppers
United Center Chicago Chicago, IL
Jun 30, 7:00 pm 2017
Friday
Jun 30
7:00 pm
Red Hot Chili Peppers
United Center, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 1633
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'

July

Red Hot Chili Peppers
United Center Chicago Chicago, IL
Jul 1, 8:00 pm 2017
Saturday
Jul 1
8:00 pm
Red Hot Chili Peppers
United Center, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 32037
SELECT * from toolcitypagelink WHERE cityname = 'Dublin'

September

Red Hot Chili Peppers
3Arena Dublin Dublin, Ir
Sep 20, 6:30 pm 2017
Wednesday
Sep 20
6:30 pm
Red Hot Chili Peppers
3Arena, Dublin, Ir
SELECT * from toolvenuepagelink WHERE venueid = 29001
SELECT * from toolcitypagelink WHERE cityname = 'Mexico City'

October

Red Hot Chili Peppers
Palacio de los Deportes Mexico City Mexico City,
Oct 10, 8:30 pm 2017
Tuesday
Oct 10
8:30 pm
Red Hot Chili Peppers
Palacio de los Deportes, Mexico City,
SELECT * from toolvenuepagelink WHERE venueid = 1219
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Red Hot Chili Peppers (Rescheduled from 3/2)
Pepsi Center Denver Denver, CO
Oct 16, 7:00 pm 2017
Monday
Oct 16
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 2763
SELECT * from toolcitypagelink WHERE cityname = 'Glendale'
Red Hot Chili Peppers (Rescheduled from 3/4)
Gila River Arena Glendale Glendale, AZ
Oct 18, 8:00 pm 2017
Wednesday
Oct 18
8:00 pm
Red Hot Chili Peppers (Rescheduled from 3/4)
Gila River Arena, Glendale, AZ
Billets Coldplay
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football