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 = 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