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 = 667
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'

June

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'

October

Rod Stewart (Rescheduled from 9/8)
Laughlin Event Center Laughlin Laughlin, NV
Oct 20, 8:00 pm 2018
Saturday
Oct 20
8:00 pm
Rod Stewart (Rescheduled from 9/8)
Laughlin Event Center, Laughlin, NV
SELECT * from toolvenuepagelink WHERE venueid = 702
SELECT * from toolcitypagelink WHERE cityname = 'Nampa'
Rod Stewart (Rescheduled from 4/12)
Ford Idaho Center Nampa Nampa, ID
Oct 24, 7:30 pm 2018
Wednesday
Oct 24
7:30 pm
Rod Stewart (Rescheduled from 4/12)
Ford Idaho Center, Nampa, ID
SELECT * from toolvenuepagelink WHERE venueid = 988
SELECT * from toolcitypagelink WHERE cityname = 'Billings'
Rod Stewart (Rescheduled from 4/14)
Metrapark Arena Billings Billings, Mt
Oct 26, 7:30 pm 2018
Friday
Oct 26
7:30 pm
Rod Stewart (Rescheduled from 4/14)
Metrapark Arena, Billings, Mt
SELECT * from toolvenuepagelink WHERE venueid = 1954
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'

November

Rod Stewart
The Colosseum - Caesars Palace Las Vegas Las Vegas, NV
Nov 21, 7:30 pm 2018
Wednesday
Nov 21
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
Nov 23, 7:30 pm 2018
Friday
Nov 23
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
Nov 24, 7:30 pm 2018
Saturday
Nov 24
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
Nov 28, 7:30 pm 2018
Wednesday
Nov 28
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'

December

Rod Stewart
The Colosseum - Caesars Palace Las Vegas Las Vegas, NV
Dec 1, 7:30 pm 2018
Saturday
Dec 1
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
Dec 2, 7:30 pm 2018
Sunday
Dec 2
7:30 pm
Rod Stewart
The Colosseum - Caesars Palace, Las Vegas, 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