LISTE POUR : Shakira

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

August

Shakira (Rescheduled from 1/23)
United Center Chicago Chicago, IL
Aug 3, 7:30 pm 2018
Friday
Aug 3
7:30 pm
Shakira (Rescheduled from 1/23)
United Center, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 33422
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
Shakira (Rescheduled from 1/22)
Little Caesars Arena Detroit Detroit, MI
Aug 4, 7:30 pm 2018
Saturday
Aug 4
7:30 pm
Shakira (Rescheduled from 1/22)
Little Caesars Arena, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 17
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Shakira (Rescheduled from 1/20)
Air Canada Centre Toronto Toronto, ON
Aug 7, 7:30 pm 2018
Tuesday
Aug 7
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 1036
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Shakira (Rescheduled from 1/19)
Bell Centre Montreal Montreal, QC
Aug 8, 7:30 pm 2018
Wednesday
Aug 8
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 896
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Shakira (Rescheduled from 1/17)
Madison Square Garden New York New York, NY
Aug 10, 7:30 pm 2018
Friday
Aug 10
7:30 pm
Shakira (Rescheduled from 1/17)
Madison Square Garden, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Shakira (Rescheduled from 1/16)
Capital One Arena Washington Washington, DC
Aug 11, 7:30 pm 2018
Saturday
Aug 11
7:30 pm
Shakira (Rescheduled from 1/16)
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 1537
SELECT * from toolcitypagelink WHERE cityname = 'Orlando'
Shakira (Rescheduled from 1/9)
Amway Center Orlando Orlando, FL
Aug 14, 7:30 pm 2018
Tuesday
Aug 14
7:30 pm
Shakira (Rescheduled from 1/9)
Amway Center, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 1085
SELECT * from toolcitypagelink WHERE cityname = 'Sunrise'
Shakira (Rescheduled from 1/11)
BB&T Center Sunrise Sunrise, FL
Aug 15, 7:30 pm 2018
Wednesday
Aug 15
7:30 pm
Shakira (Rescheduled from 1/11)
BB&T Center, Sunrise, FL
SELECT * from toolvenuepagelink WHERE venueid = 44
SELECT * from toolcitypagelink WHERE cityname = 'Miami'
Shakira (Rescheduled from 1/12)
American Airlines Arena Miami Miami, FL
Aug 17, 7:30 pm 2018
Friday
Aug 17
7:30 pm
Shakira (Rescheduled from 1/12)
American Airlines Arena, Miami, FL
SELECT * from toolvenuepagelink WHERE venueid = 44
SELECT * from toolcitypagelink WHERE cityname = 'Miami'
Shakira (Rescheduled from 1/13)
American Airlines Arena Miami Miami, FL
Aug 18, 7:30 pm 2018
Saturday
Aug 18
7:30 pm
Shakira (Rescheduled from 1/13)
American Airlines Arena, Miami, FL
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Shakira (Rescheduled from 1/28)
American Airlines Center Dallas Dallas, TX
Aug 21, 7:30 pm 2018
Tuesday
Aug 21
7:30 pm
Shakira (Rescheduled from 1/28)
American Airlines Center, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 2786
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
Shakira (Rescheduled from 1/26)
Toyota Center Houston Houston, TX
Aug 22, 7:30 pm 2018
Wednesday
Aug 22
7:30 pm
Shakira (Rescheduled from 1/26)
Toyota Center, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 2259
SELECT * from toolcitypagelink WHERE cityname = 'San Antonio'
Shakira (Rescheduled from 1/29)
AT&T Center San Antonio San Antonio, TX
Aug 24, 7:30 pm 2018
Friday
Aug 24
7:30 pm
Shakira (Rescheduled from 1/29)
AT&T Center, San Antonio, TX
SELECT * from toolvenuepagelink WHERE venueid = 43
SELECT * from toolcitypagelink WHERE cityname = 'Phoenix'
Shakira (Rescheduled from 2/3)
Talking Stick Resort Arena Phoenix Phoenix, AZ
Aug 26, 8:00 pm 2018
Sunday
Aug 26
8:00 pm
Shakira (Rescheduled from 2/3)
Talking Stick Resort Arena, Phoenix, AZ
SELECT * from toolvenuepagelink WHERE venueid = 602
SELECT * from toolcitypagelink WHERE cityname = 'Inglewood'
Shakira (Rescheduled from 2/1)
The Forum Inglewood Inglewood, CA
Aug 28, 7:30 pm 2018
Tuesday
Aug 28
7:30 pm
Shakira (Rescheduled from 2/1)
The Forum, Inglewood, CA
SELECT * from toolvenuepagelink WHERE venueid = 602
SELECT * from toolcitypagelink WHERE cityname = 'Inglewood'
Shakira
The Forum Inglewood Inglewood, CA
Aug 29, 7:30 pm 2018
Wednesday
Aug 29
7:30 pm
Shakira
The Forum, Inglewood, CA
SELECT * from toolvenuepagelink WHERE venueid = 66
SELECT * from toolcitypagelink WHERE cityname = 'Anaheim'
Shakira (Rescheduled from 2/6)
Honda Center Anaheim Anaheim, CA
Aug 31, 7:30 pm 2018
Friday
Aug 31
7:30 pm
Shakira (Rescheduled from 2/6)
Honda Center, Anaheim, CA
SELECT * from toolvenuepagelink WHERE venueid = 996
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'

September

Shakira (Rescheduled from 2/10)
MGM Grand Garden Arena Las Vegas Las Vegas, NV
Sep 1, 7:30 pm 2018
Saturday
Sep 1
7:30 pm
Shakira (Rescheduled from 2/10)
MGM Grand Garden Arena, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 8000
SELECT * from toolcitypagelink WHERE cityname = 'San Diego'
Shakira (Rescheduled from 2/9)
Valley View Casino Center San Diego San Diego, CA
Sep 5, 7:00 pm 2018
Wednesday
Sep 5
7:00 pm
Shakira (Rescheduled from 2/9)
Valley View Casino Center, San Diego, CA
SELECT * from toolvenuepagelink WHERE venueid = 1384
SELECT * from toolcitypagelink WHERE cityname = 'San Jose'
Shakira (Rescheduled from 2/7)
SAP Center at San Jose San Jose San Jose, CA
Sep 6, 7:30 pm 2018
Thursday
Sep 6
7:30 pm
Shakira (Rescheduled from 2/7)
SAP Center at San Jose, San Jose, CA
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football