LISTE POUR : Rod Stewart

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

March

Rod Stewart
Air Canada Centre Toronto Toronto, ON
Mar 22, 7:30 pm 2018
Thursday
Mar 22
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 2061
SELECT * from toolcitypagelink WHERE cityname = 'Uncasville'
Rod Stewart
Mohegan Sun Arena Uncasville Uncasville, CT
Mar 24, 8:00 pm 2018
Saturday
Mar 24
8:00 pm
Rod Stewart
Mohegan Sun Arena, Uncasville, CT
SELECT * from toolvenuepagelink WHERE venueid = 32366
SELECT * from toolcitypagelink WHERE cityname = 'Quebec'
Rod Stewart
Centre Videotron Quebec Quebec, QC
Mar 26, 7:30 pm 2018
Monday
Mar 26
7:30 pm
Rod Stewart
Centre Videotron, Quebec, QC
SELECT * from toolvenuepagelink WHERE venueid = 1036
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Rod Stewart
Bell Centre Montreal Montreal, QC
Mar 27, 7:30 pm 2018
Tuesday
Mar 27
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 345
SELECT * from toolcitypagelink WHERE cityname = 'Kanata'
Rod Stewart
Canadian Tire Centre Kanata Kanata, ON
Mar 30, 7:30 pm 2018
Friday
Mar 30
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 2521
SELECT * from toolcitypagelink WHERE cityname = 'London'
Rod Stewart
Budweiser Gardens (Formerly John Labatt Centre) London London, ON
Mar 31, 7:30 pm 2018
Saturday
Mar 31
7:30 pm
Rod Stewart
Budweiser Gardens (Formerly John Labatt Centre), London, ON
SELECT * from toolvenuepagelink WHERE venueid = 3316
SELECT * from toolcitypagelink WHERE cityname = 'Winnipeg'

April

Rod Stewart
Bell MTS Place Winnipeg Winnipeg, MB
Apr 3, 7:00 pm 2018
Tuesday
Apr 3
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 3308
SELECT * from toolcitypagelink WHERE cityname = 'Saskatoon'
Rod Stewart
SaskTel Centre Saskatoon Saskatoon, SK
Apr 4, 8:00 pm 2018
Wednesday
Apr 4
8:00 pm
Rod Stewart
SaskTel Centre, Saskatoon, SK
SELECT * from toolvenuepagelink WHERE venueid = 33142
SELECT * from toolcitypagelink WHERE cityname = 'Edmonton'
Rod Stewart
Rogers Place Edmonton Edmonton, AB
Apr 6, 7:30 pm 2018
Friday
Apr 6
7:30 pm
Rod Stewart
Rogers Place, Edmonton, AB
SELECT * from toolvenuepagelink WHERE venueid = 1367
SELECT * from toolcitypagelink WHERE cityname = 'Calgary'
Rod Stewart
Scotiabank Saddledome Calgary Calgary, AB
Apr 8, 7:30 pm 2018
Sunday
Apr 8
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 557
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Rod Stewart
Rogers Arena Vancouver Vancouver, BC
Apr 10, 7:30 pm 2018
Tuesday
Apr 10
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 702
SELECT * from toolcitypagelink WHERE cityname = 'Nampa'
Rod Stewart
Ford Idaho Center Nampa Nampa, ID
Apr 12, 7:30 pm 2018
Thursday
Apr 12
7:30 pm
Rod Stewart
Ford Idaho Center, Nampa, ID
SELECT * from toolvenuepagelink WHERE venueid = 988
SELECT * from toolcitypagelink WHERE cityname = 'Billings'
Rod Stewart
Metrapark Arena Billings Billings, Mt
Apr 14, 7:30 pm 2018
Saturday
Apr 14
7:30 pm
Rod Stewart
Metrapark Arena, Billings, Mt
SELECT * from toolvenuepagelink WHERE venueid = 1954
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'

June

Rod Stewart
The Colosseum - Caesars Palace Las Vegas Las Vegas, NV
Jun 12, 7:30 pm 2018
Tuesday
Jun 12
7:30 pm
Rod Stewart
The Colosseum - Caesars Palace, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 1954
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'
Rod Stewart
The Colosseum - Caesars Palace Las Vegas Las Vegas, NV
Jun 15, 7:30 pm 2018
Friday
Jun 15
7:30 pm
Rod Stewart
The Colosseum - Caesars Palace, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 1954
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'
Rod Stewart
The Colosseum - Caesars Palace Las Vegas Las Vegas, NV
Jun 16, 7:30 pm 2018
Saturday
Jun 16
7:30 pm
Rod Stewart
The Colosseum - Caesars Palace, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 1954
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'
Rod Stewart
The Colosseum - Caesars Palace Las Vegas Las Vegas, NV
Jun 19, 7:30 pm 2018
Tuesday
Jun 19
7:30 pm
Rod Stewart
The Colosseum - Caesars Palace, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 1954
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'
Rod Stewart
The Colosseum - Caesars Palace Las Vegas Las Vegas, NV
Jun 22, 7:30 pm 2018
Friday
Jun 22
7:30 pm
Rod Stewart
The Colosseum - Caesars Palace, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 667
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Rod Stewart
Hollywood Bowl Los Angeles Los Angeles, CA
Jun 25, 7:30 pm 2018
Monday
Jun 25
7:30 pm
Rod Stewart
Hollywood Bowl, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 667
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Rod Stewart with Cyndi Lauper
Hollywood Bowl Los Angeles Los Angeles, CA
Jun 26, 7:30 pm 2018
Tuesday
Jun 26
7:30 pm
Rod Stewart with Cyndi Lauper
Hollywood Bowl, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 1954
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'
Rod Stewart
The Colosseum - Caesars Palace Las Vegas Las Vegas, NV
Jun 29, 7:30 pm 2018
Friday
Jun 29
7:30 pm
Rod Stewart
The Colosseum - Caesars Palace, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 1954
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'
Rod Stewart
The Colosseum - Caesars Palace Las Vegas Las Vegas, NV
Jun 30, 7:30 pm 2018
Saturday
Jun 30
7:30 pm
Rod Stewart
The Colosseum - Caesars Palace, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 3602
SELECT * from toolcitypagelink WHERE cityname = 'Hollywood'

July

Rod Stewart
Seminole Hard Rock Live-Hollywood Hollywood Hollywood, FL
Jul 24, 7:30 pm 2018
Tuesday
Jul 24
7:30 pm
Rod Stewart
Seminole Hard Rock Live-Hollywood, Hollywood, FL
SELECT * from toolvenuepagelink WHERE venueid = 1537
SELECT * from toolcitypagelink WHERE cityname = 'Orlando'
Rod Stewart
Amway Center Orlando Orlando, FL
Jul 26, 7:30 pm 2018
Thursday
Jul 26
7:30 pm
Rod Stewart
Amway Center, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 3535
SELECT * from toolcitypagelink WHERE cityname = 'Charlotte'
Rod Stewart
Spectrum Center Charlotte Charlotte, NC
Jul 28, 7:30 pm 2018
Saturday
Jul 28
7:30 pm
Rod Stewart
Spectrum Center, Charlotte, NC
SELECT * from toolvenuepagelink WHERE venueid = 7419
SELECT * from toolcitypagelink WHERE cityname = 'Louisville'
Rod Stewart
KFC Yum! Center Louisville Louisville, KY
Jul 29, 7:30 pm 2018
Sunday
Jul 29
7:30 pm
Rod Stewart
KFC Yum! Center, Louisville, KY
SELECT * from toolvenuepagelink WHERE venueid = 1080
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'

August

Rod Stewart
Bridgestone Arena Nashville Nashville, TN
Aug 1, 7:30 pm 2018
Wednesday
Aug 1
7:30 pm
Rod Stewart
Bridgestone Arena, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 30704
SELECT * from toolcitypagelink WHERE cityname = 'Allentown'
Rod Stewart
PPL Center Allentown Allentown, PA
Aug 3, 7:30 pm 2018
Friday
Aug 3
7:30 pm
Rod Stewart
PPL Center, Allentown, PA
SELECT * from toolvenuepagelink WHERE venueid = 2048
SELECT * from toolcitypagelink WHERE cityname = 'Atlantic City'
Rod Stewart
Boardwalk Hall Atlantic City Atlantic City, NJ
Aug 4, 7:30 pm 2018
Saturday
Aug 4
7:30 pm
Rod Stewart
Boardwalk Hall, Atlantic City, NJ
SELECT * from toolvenuepagelink WHERE venueid = 896
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Rod Stewart
Madison Square Garden New York New York, NY
Aug 7, 7:30 pm 2018
Tuesday
Aug 7
7:30 pm
Rod Stewart
Madison Square Garden, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 1035
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Rod Stewart
Budweiser Stage Toronto Toronto, ON
Aug 10, 7:30 pm 2018
Friday
Aug 10
7:30 pm
Rod Stewart
Budweiser Stage, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 7329
SELECT * from toolcitypagelink WHERE cityname = 'Pittsburgh'
Rod Stewart
PPG Paints Arena Pittsburgh Pittsburgh, PA
Aug 11, 7:00 pm 2018
Saturday
Aug 11
7:00 pm
Rod Stewart
PPG Paints Arena, Pittsburgh, PA
SELECT * from toolvenuepagelink WHERE venueid = 4603
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Rod Stewart
Sprint Center Kansas City Kansas City, MO
Aug 14, 7:00 pm 2018
Tuesday
Aug 14
7:00 pm
Rod Stewart
Sprint Center, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 1811
SELECT * from toolcitypagelink WHERE cityname = 'St Paul'
Rod Stewart
Xcel Energy Center St Paul St Paul, MN
Aug 15, 8:00 pm 2018
Wednesday
Aug 15
8:00 pm
Rod Stewart
Xcel Energy Center, St Paul, MN
SELECT * from toolvenuepagelink WHERE venueid = 1937
SELECT * from toolcitypagelink WHERE cityname = 'Noblesville'
Rod Stewart
Ruoff Home Mortgage Music Center Noblesville Noblesville, IN
Aug 18, 7:00 pm 2018
Saturday
Aug 18
7:00 pm
Rod Stewart
Ruoff Home Mortgage Music Center, Noblesville, IN
SELECT * from toolvenuepagelink WHERE venueid = 4521
SELECT * from toolcitypagelink WHERE cityname = 'Maryland Heights'
Rod Stewart
Hollywood Casino Amphitheatre - MO Maryland Heights Maryland Heights, MO
Aug 19, 7:30 pm 2018
Sunday
Aug 19
7:30 pm
Rod Stewart
Hollywood Casino Amphitheatre - MO, Maryland Heights, MO
SELECT * from toolvenuepagelink WHERE venueid = 1219
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Rod Stewart
Pepsi Center Denver Denver, CO
Aug 22, 7:30 pm 2018
Wednesday
Aug 22
7:30 pm
Rod Stewart
Pepsi Center, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 43
SELECT * from toolcitypagelink WHERE cityname = 'Phoenix'
Rod Stewart
Talking Stick Resort Arena Phoenix Phoenix, AZ
Aug 24, 7:00 pm 2018
Friday
Aug 24
7:00 pm
Rod Stewart
Talking Stick Resort Arena, Phoenix, AZ
SELECT * from toolvenuepagelink WHERE venueid = 338
SELECT * from toolcitypagelink WHERE cityname = 'Chula Vista'
Rod Stewart
Mattress Firm Amphitheatre Chula Vista Chula Vista, CA
Aug 26, 7:00 pm 2018
Sunday
Aug 26
7:00 pm
Rod Stewart
Mattress Firm Amphitheatre, Chula Vista, CA
SELECT * from toolvenuepagelink WHERE venueid = 3326
SELECT * from toolcitypagelink WHERE cityname = 'Reno'
Rod Stewart
Reno Events Center Reno Reno, NV
Aug 28, 7:30 pm 2018
Tuesday
Aug 28
7:30 pm
Rod Stewart
Reno Events Center, Reno, NV
SELECT * from toolvenuepagelink WHERE venueid = 1418
SELECT * from toolcitypagelink WHERE cityname = 'Mountain View'
Rod Stewart
Shoreline Amphitheatre - CA Mountain View Mountain View, CA
Aug 29, 7:00 pm 2018
Wednesday
Aug 29
7:00 pm
Rod Stewart
Shoreline Amphitheatre - CA, Mountain View, CA
SELECT * from toolvenuepagelink WHERE venueid = 2631
SELECT * from toolcitypagelink WHERE cityname = 'Ridgefield'
Rod Stewart
Sunlight Supply Amphitheater Ridgefield Ridgefield, WA
Aug 31, 7:00 pm 2018
Friday
Aug 31
7:00 pm
Rod Stewart
Sunlight Supply Amphitheater, Ridgefield, WA
SELECT * from toolvenuepagelink WHERE venueid = 2546
SELECT * from toolcitypagelink WHERE cityname = 'Auburn'

September

Rod Stewart
White River Amphitheatre Auburn Auburn, WA
Sep 1, 7:00 pm 2018
Saturday
Sep 1
7:00 pm
Rod Stewart
White River Amphitheatre, Auburn, WA
SELECT * from toolvenuepagelink WHERE venueid = 30605
SELECT * from toolcitypagelink WHERE cityname = 'Laughlin'
Rod Stewart
Laughlin Event Center Laughlin Laughlin, NV
Sep 8, 8:00 pm 2018
Saturday
Sep 8
8:00 pm
Rod Stewart
Laughlin Event Center, Laughlin, NV
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football