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

April

Red Hot Chili Peppers
Amalie Arena Tampa Tampa, FL
Apr 27, 8:00 pm 2017
Thursday
Apr 27
8:00 pm
Red Hot Chili Peppers
Amalie Arena, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 44
SELECT * from toolcitypagelink WHERE cityname = 'Miami'
Red Hot Chili Peppers
American Airlines Arena Miami Miami, FL
Apr 29, 7:00 pm 2017
Saturday
Apr 29
7:00 pm
Red Hot Chili Peppers
American Airlines Arena, Miami, FL
SELECT * from toolvenuepagelink WHERE venueid = 7329
SELECT * from toolcitypagelink WHERE cityname = 'Pittsburgh'

May

Red Hot Chili Peppers
PPG Paints Arena Pittsburgh Pittsburgh, PA
May 11, 7:00 pm 2017
Thursday
May 11
7:00 pm
Red Hot Chili Peppers
PPG Paints Arena, Pittsburgh, PA
SELECT * from toolvenuepagelink WHERE venueid = 614
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
Red Hot Chili Peppers
Quicken Loans Arena Cleveland Cleveland, OH
May 13, 8:00 pm 2017
Saturday
May 13
8:00 pm
Red Hot Chili Peppers
Quicken Loans Arena, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 33304
SELECT * from toolcitypagelink WHERE cityname = 'Columbus'
Red Hot Chili Peppers
Value City Arena at the Jerome Schottenstein Center Columbus Columbus, OH
May 14, 8:00 pm 2017
Sunday
May 14
8:00 pm
Red Hot Chili Peppers
Value City Arena at the Jerome Schottenstein Center, Columbus, OH
SELECT * from toolvenuepagelink WHERE venueid = 7419
SELECT * from toolcitypagelink WHERE cityname = 'Louisville'
Red Hot Chili Peppers
KFC Yum! Center Louisville Louisville, KY
May 16, 8:00 pm 2017
Tuesday
May 16
8:00 pm
Red Hot Chili Peppers
KFC Yum! Center, Louisville, KY
SELECT * from toolvenuepagelink WHERE venueid = 324
SELECT * from toolcitypagelink WHERE cityname = 'Indianapolis'
Red Hot Chili Peppers
Bankers Life Fieldhouse Indianapolis Indianapolis, IN
May 18, 8:00 pm 2017
Thursday
May 18
8:00 pm
Red Hot Chili Peppers
Bankers Life Fieldhouse, Indianapolis, IN
SELECT * from toolvenuepagelink WHERE venueid = 501
SELECT * from toolcitypagelink WHERE cityname = 'Cincinnati'
Red Hot Chili Peppers
U.S. Bank Arena Cincinnati Cincinnati, OH
May 19, 8:00 pm 2017
Friday
May 19
8:00 pm
Red Hot Chili Peppers
U.S. Bank Arena, Cincinnati, OH
SELECT * from toolvenuepagelink WHERE venueid = 4603
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Red Hot Chili Peppers
Sprint Center Kansas City Kansas City, MO
May 21, 8:00 pm 2017
Sunday
May 21
8:00 pm
Red Hot Chili Peppers
Sprint Center, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 3536
SELECT * from toolcitypagelink WHERE cityname = 'Des Moines'
Red Hot Chili Peppers
Wells Fargo Arena - Des Moines Des Moines Des Moines, IA
May 23, 8:00 pm 2017
Tuesday
May 23
8:00 pm
Red Hot Chili Peppers
Wells Fargo Arena - Des Moines, Des Moines, IA
SELECT * from toolvenuepagelink WHERE venueid = 3316
SELECT * from toolcitypagelink WHERE cityname = 'Winnipeg'
Red Hot Chili Peppers
MTS Centre Winnipeg Winnipeg, MB
May 26, 8:00 pm 2017
Friday
May 26
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 33142
SELECT * from toolcitypagelink WHERE cityname = 'Edmonton'
Red Hot Chili Peppers
Rogers Place Edmonton Edmonton, AB
May 28, 7:30 pm 2017
Sunday
May 28
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 1367
SELECT * from toolcitypagelink WHERE cityname = 'Calgary'
Red Hot Chili Peppers
Scotiabank Saddledome Calgary Calgary, AB
May 29, 7:30 pm 2017
Monday
May 29
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 1036
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'

June

Red Hot Chili Peppers
Bell Centre Montreal Montreal, QC
Jun 20, 8:00 pm 2017
Tuesday
Jun 20
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 342
SELECT * from toolcitypagelink WHERE cityname = 'Hamilton'
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