LISTE POUR : Pink

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

March

Pink
Talking Stick Resort Arena Phoenix Phoenix, AZ
Mar 1, 7:30 pm 2018
Thursday
Mar 1
7:30 pm
Pink
Talking Stick Resort Arena, Phoenix, AZ
SELECT * from toolvenuepagelink WHERE venueid = 7099
SELECT * from toolcitypagelink WHERE cityname = 'Wichita'
Pink
INTRUST Bank Arena Wichita Wichita, KS
Mar 3, 8:00 pm 2018
Saturday
Mar 3
8:00 pm
Pink
INTRUST Bank Arena, Wichita, KS
SELECT * from toolvenuepagelink WHERE venueid = 5118
SELECT * from toolcitypagelink WHERE cityname = 'Tulsa'
Pink
BOK Center Tulsa Tulsa, OK
Mar 5, 7:30 pm 2018
Monday
Mar 5
7:30 pm
Pink
BOK Center, Tulsa, OK
SELECT * from toolvenuepagelink WHERE venueid = 30074
SELECT * from toolcitypagelink WHERE cityname = 'Lincoln'
Pink
Pinnacle Bank Arena Lincoln Lincoln, NE
Mar 6, 7:30 pm 2018
Tuesday
Mar 6
7:30 pm
Pink
Pinnacle Bank Arena, Lincoln, NE
SELECT * from toolvenuepagelink WHERE venueid = 1633
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Pink
United Center Chicago Chicago, IL
Mar 9, 7:30 pm 2018
Friday
Mar 9
7:30 pm
Pink
United Center, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 1633
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Pink
United Center Chicago Chicago, IL
Mar 10, 8:00 pm 2018
Saturday
Mar 10
8:00 pm
Pink
United Center, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 1811
SELECT * from toolcitypagelink WHERE cityname = 'St Paul'
Pink
Xcel Energy Center St Paul St Paul, MN
Mar 12, 7:30 pm 2018
Monday
Mar 12
7:30 pm
Pink
Xcel Energy Center, St Paul, MN
SELECT * from toolvenuepagelink WHERE venueid = 785
SELECT * from toolcitypagelink WHERE cityname = 'St Louis'
Pink
Scottrade Center St Louis St Louis, MO
Mar 14, 7:30 pm 2018
Wednesday
Mar 14
7:30 pm
Pink
Scottrade Center, St Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 4603
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Pink
Sprint Center Kansas City Kansas City, MO
Mar 15, 7:30 pm 2018
Thursday
Mar 15
7:30 pm
Pink
Sprint Center, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 324
SELECT * from toolcitypagelink WHERE cityname = 'Indianapolis'
Pink
Bankers Life Fieldhouse Indianapolis Indianapolis, IN
Mar 17, 8:00 pm 2018
Saturday
Mar 17
8:00 pm
Pink
Bankers Life Fieldhouse, Indianapolis, IN
SELECT * from toolvenuepagelink WHERE venueid = 1663
SELECT * from toolcitypagelink WHERE cityname = 'Grand Rapids'
Pink
Van Andel Arena Grand Rapids Grand Rapids, MI
Mar 18, 7:30 pm 2018
Sunday
Mar 18
7:30 pm
Pink
Van Andel Arena, Grand Rapids, MI
SELECT * from toolvenuepagelink WHERE venueid = 17
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Pink
Air Canada Centre Toronto Toronto, ON
Mar 20, 7:30 pm 2018
Tuesday
Mar 20
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 17
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Pink
Air Canada Centre Toronto Toronto, ON
Mar 21, 7:30 pm 2018
Wednesday
Mar 21
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 1036
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Pink
Bell Centre Montreal Montreal, QC
Mar 23, 7:30 pm 2018
Friday
Mar 23
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 33422
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
Pink
Little Caesars Arena Detroit Detroit, MI
Mar 25, 7:30 pm 2018
Sunday
Mar 25
7:30 pm
Pink
Little Caesars Arena, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 7419
SELECT * from toolcitypagelink WHERE cityname = 'Louisville'
Pink
KFC Yum! Center Louisville Louisville, KY
Mar 27, 7:30 pm 2018
Tuesday
Mar 27
7:30 pm
Pink
KFC Yum! Center, Louisville, KY
SELECT * from toolvenuepagelink WHERE venueid = 614
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
Pink
Quicken Loans Arena Cleveland Cleveland, OH
Mar 28, 7:30 pm 2018
Wednesday
Mar 28
7:30 pm
Pink
Quicken Loans Arena, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 896
SELECT * from toolcitypagelink WHERE cityname = 'New York'

April

Pink
Madison Square Garden New York New York, NY
Apr 4, 7:30 pm 2018
Wednesday
Apr 4
7:30 pm
Pink
Madison Square Garden, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 896
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Pink
Madison Square Garden New York New York, NY
Apr 5, 7:30 pm 2018
Thursday
Apr 5
7:30 pm
Pink
Madison Square Garden, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 7329
SELECT * from toolcitypagelink WHERE cityname = 'Pittsburgh'
Pink
PPG Paints Arena Pittsburgh Pittsburgh, PA
Apr 7, 7:30 pm 2018
Saturday
Apr 7
7:30 pm
Pink
PPG Paints Arena, Pittsburgh, PA
SELECT * from toolvenuepagelink WHERE venueid = 507
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Pink
TD Garden Boston Boston, MA
Apr 9, 7:30 pm 2018
Monday
Apr 9
7:30 pm
Pink
TD Garden, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 507
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Pink
TD Garden Boston Boston, MA
Apr 10, 7:30 pm 2018
Tuesday
Apr 10
7:30 pm
Pink
TD Garden, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 499
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
Pink
Wells Fargo Center Philadelphia Philadelphia, PA
Apr 13, 7:30 pm 2018
Friday
Apr 13
7:30 pm
Pink
Wells Fargo Center, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 4797
SELECT * from toolcitypagelink WHERE cityname = 'Newark'
Pink
Prudential Center Newark Newark, NJ
Apr 14, 7:30 pm 2018
Saturday
Apr 14
7:30 pm
Pink
Prudential Center, Newark, NJ
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Pink
Capital One Arena Washington Washington, DC
Apr 16, 7:30 pm 2018
Monday
Apr 16
7:30 pm
Pink
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Pink
Capital One Arena Washington Washington, DC
Apr 17, 7:30 pm 2018
Tuesday
Apr 17
7:30 pm
Pink
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 4054
SELECT * from toolcitypagelink WHERE cityname = 'Charlottesville'
Pink
John Paul Jones Arena Charlottesville Charlottesville, VA
Apr 19, 7:30 pm 2018
Thursday
Apr 19
7:30 pm
Pink
John Paul Jones Arena, Charlottesville, VA
SELECT * from toolvenuepagelink WHERE venueid = 1228
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Pink
Philips Arena Atlanta Atlanta, GA
Apr 21, 8:00 pm 2018
Saturday
Apr 21
8:00 pm
Pink
Philips Arena, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 1537
SELECT * from toolcitypagelink WHERE cityname = 'Orlando'
Pink
Amway Center Orlando Orlando, FL
Apr 24, 7:30 pm 2018
Tuesday
Apr 24
7:30 pm
Pink
Amway Center, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 1085
SELECT * from toolcitypagelink WHERE cityname = 'Sunrise'
Pink
BB&T Center Sunrise Sunrise, FL
Apr 25, 7:30 pm 2018
Wednesday
Apr 25
7:30 pm
Pink
BB&T Center, Sunrise, FL
SELECT * from toolvenuepagelink WHERE venueid = 2786
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
Pink
Toyota Center Houston Houston, TX
Apr 28, 8:00 pm 2018
Saturday
Apr 28
8:00 pm
Pink
Toyota Center, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 2786
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
Pink
Toyota Center Houston Houston, TX
Apr 29, 7:30 pm 2018
Sunday
Apr 29
7:30 pm
Pink
Toyota Center, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'

May

Pink
American Airlines Center Dallas Dallas, TX
May 1, 7:30 pm 2018
Tuesday
May 1
7:30 pm
Pink
American Airlines Center, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Pink
American Airlines Center Dallas Dallas, TX
May 2, 7:30 pm 2018
Wednesday
May 2
7:30 pm
Pink
American Airlines Center, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 1219
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Pink
Pepsi Center Denver Denver, CO
May 8, 7:30 pm 2018
Tuesday
May 8
7:30 pm
Pink
Pepsi Center, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 399
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
Pink
Vivint Smart Home Arena Salt Lake City Salt Lake City, UT
May 9, 8:00 pm 2018
Wednesday
May 9
8:00 pm
Pink
Vivint Smart Home Arena, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 557
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Pink
Rogers Arena Vancouver Vancouver, BC
May 12, 8:00 pm 2018
Saturday
May 12
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 781
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Pink
Key Arena Seattle Seattle, WA
May 13, 7:30 pm 2018
Sunday
May 13
7:30 pm
Pink
Key Arena, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 1343
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Pink
Moda Center Portland Portland, OR
May 15, 7:30 pm 2018
Tuesday
May 15
7:30 pm
Pink
Moda Center, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 1129
SELECT * from toolcitypagelink WHERE cityname = 'Oakland'
Pink
Oracle Arena Oakland Oakland, CA
May 18, 7:30 pm 2018
Friday
May 18
7:30 pm
Pink
Oracle Arena, Oakland, CA
SELECT * from toolvenuepagelink WHERE venueid = 1129
SELECT * from toolcitypagelink WHERE cityname = 'Oakland'
Pink
Oracle Arena Oakland Oakland, CA
May 19, 8:00 pm 2018
Saturday
May 19
8:00 pm
Pink
Oracle Arena, Oakland, CA
SELECT * from toolvenuepagelink WHERE venueid = 2839
SELECT * from toolcitypagelink WHERE cityname = 'Fresno'
Pink
Save Mart Center Fresno Fresno, CA
May 22, 7:30 pm 2018
Tuesday
May 22
7:30 pm
Pink
Save Mart Center, Fresno, CA
SELECT * from toolvenuepagelink WHERE venueid = 5575
SELECT * from toolcitypagelink WHERE cityname = 'Ontario'
Pink
Citizens Business Bank Arena Ontario Ontario, CA
May 23, 7:30 pm 2018
Wednesday
May 23
7:30 pm
Pink
Citizens Business Bank Arena, Ontario, CA
SELECT * from toolvenuepagelink WHERE venueid = 66
SELECT * from toolcitypagelink WHERE cityname = 'Anaheim'
Pink
Honda Center Anaheim Anaheim, CA
May 25, 8:00 pm 2018
Friday
May 25
8:00 pm
Pink
Honda Center, Anaheim, CA
SELECT * from toolvenuepagelink WHERE venueid = 32725
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'
Pink
T-Mobile Arena Las Vegas Las Vegas, NV
May 26, 8:00 pm 2018
Saturday
May 26
8:00 pm
Pink
T-Mobile Arena, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 8000
SELECT * from toolcitypagelink WHERE cityname = 'San Diego'
Pink
Valley View Casino Center San Diego San Diego, CA
May 28, 7:30 pm 2018
Monday
May 28
7:30 pm
Pink
Valley View Casino Center, San Diego, CA
SELECT * from toolvenuepagelink WHERE venueid = 1480
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Pink
Staples Center Los Angeles Los Angeles, CA
May 31, 7:30 pm 2018
Thursday
May 31
7:30 pm
Pink
Staples Center, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 602
SELECT * from toolcitypagelink WHERE cityname = 'Inglewood'

June

Pink
The Forum Inglewood Inglewood, CA
Jun 1, 8:00 pm 2018
Friday
Jun 1
8:00 pm
Pink
The Forum, Inglewood, CA
SELECT * from toolvenuepagelink WHERE venueid = 602
SELECT * from toolcitypagelink WHERE cityname = 'Inglewood'
Pink
The Forum Inglewood Inglewood, CA
Jun 2, 8:00 pm 2018
Saturday
Jun 2
8:00 pm
Pink
The Forum, Inglewood, 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
NOUVELLES - SPORT