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 = 1811
SELECT * from toolcitypagelink WHERE cityname = 'St Paul'

October

Rod Stewart (Rescheduled from 8/15/18)
Xcel Energy Center St Paul St Paul, MN
Oct 14, 8:00 pm 2018
Sunday
Oct 14
8:00 pm
Rod Stewart (Rescheduled from 8/15/18)
Xcel Energy Center, St Paul, MN
SELECT * from toolvenuepagelink WHERE venueid = 4603
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Rod Stewart (Rescheduled from 8/14)
Sprint Center Kansas City Kansas City, MO
Oct 16, 7:00 pm 2018
Tuesday
Oct 16
7:00 pm
Rod Stewart (Rescheduled from 8/14)
Sprint Center, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 2196
SELECT * from toolcitypagelink WHERE cityname = 'Oklahoma City'
Rod Stewart with Pat Benatar
Chesapeake Energy Arena Oklahoma City Oklahoma City, OK
Oct 18, 7:30 pm 2018
Thursday
Oct 18
7:30 pm
Rod Stewart with Pat Benatar
Chesapeake Energy Arena, Oklahoma City, OK
SELECT * from toolvenuepagelink WHERE venueid = 30605
SELECT * from toolcitypagelink WHERE cityname = 'Laughlin'
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 = 1388
SELECT * from toolcitypagelink WHERE cityname = 'Santa Barbara'
Rod Stewart
Santa Barbara Bowl Santa Barbara Santa Barbara, CA
Oct 21, 7:00 pm 2018
Sunday
Oct 21
7:00 pm
Rod Stewart
Santa Barbara Bowl, Santa Barbara, CA
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 = 5575
SELECT * from toolcitypagelink WHERE cityname = 'Ontario'
Rod Stewart with Pat Benatar
Citizens Business Bank Arena Ontario Ontario, CA
Oct 28, 7:30 pm 2018
Sunday
Oct 28
7:30 pm
Rod Stewart with Pat Benatar
Citizens Business Bank Arena, Ontario, CA
SELECT * from toolvenuepagelink WHERE venueid = 3317
SELECT * from toolcitypagelink WHERE cityname = 'Victoria'
Rod Stewart
Save On Foods Memorial Centre Victoria Victoria, BC
Oct 30, 7:30 pm 2018
Tuesday
Oct 30
7:30 pm
Rod Stewart
Save On Foods Memorial Centre, Victoria, BC
SELECT * from toolvenuepagelink WHERE venueid = 2996
SELECT * from toolcitypagelink WHERE cityname = 'Kelowna'

November

Rod Stewart
Prospera Place Kelowna Kelowna, BC
Nov 1, 7:30 pm 2018
Thursday
Nov 1
7:30 pm
Rod Stewart
Prospera Place, Kelowna, BC
SELECT * from toolvenuepagelink WHERE venueid = 3326
SELECT * from toolcitypagelink WHERE cityname = 'Reno'
Rod Stewart (Rescheduled from August 28th, 2018)
Reno Events Center Reno Reno, NV
Nov 3, 7:30 pm 2018
Saturday
Nov 3
7:30 pm
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 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