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 = 1085
SELECT * from toolcitypagelink WHERE cityname = 'Sunrise'

March

Pink
BB&T Center Sunrise Sunrise, FL
Mar 1, 8:00 pm 2019
Friday
Mar 1
8:00 pm
Pink
BB&T Center, Sunrise, FL
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Pink
Amalie Arena Tampa Tampa, FL
Mar 3, 7:30 pm 2019
Sunday
Mar 3
7:30 pm
Pink
Amalie Arena, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 2842
SELECT * from toolcitypagelink WHERE cityname = 'Jacksonville'
Pink
Jacksonville Veterans Memorial Arena Jacksonville Jacksonville, FL
Mar 5, 7:30 pm 2019
Tuesday
Mar 5
7:30 pm
Pink
Jacksonville Veterans Memorial Arena, Jacksonville, FL
SELECT * from toolvenuepagelink WHERE venueid = 5748
SELECT * from toolcitypagelink WHERE cityname = 'Columbia'
Pink
Colonial Life Arena Columbia Columbia, SC
Mar 7, 7:30 pm 2019
Thursday
Mar 7
7:30 pm
Pink
Colonial Life Arena, Columbia, SC
SELECT * from toolvenuepagelink WHERE venueid = 3535
SELECT * from toolcitypagelink WHERE cityname = 'Charlotte'
Pink
Spectrum Center Charlotte Charlotte, NC
Mar 9, 7:30 pm 2019
Saturday
Mar 9
7:30 pm
Pink
Spectrum Center, Charlotte, NC
SELECT * from toolvenuepagelink WHERE venueid = 1080
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
Pink
Bridgestone Arena Nashville Nashville, TN
Mar 10, 7:30 pm 2019
Sunday
Mar 10
7:30 pm
Pink
Bridgestone Arena, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 1228
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Pink
State Farm Arena - GA Atlanta Atlanta, GA
Mar 12, 7:30 pm 2019
Tuesday
Mar 12
7:30 pm
Pink
State Farm Arena - GA, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 149
SELECT * from toolcitypagelink WHERE cityname = 'Birmingham'
Pink
BJCC Arena Birmingham Birmingham, AL
Mar 14, 7:30 pm 2019
Thursday
Mar 14
7:30 pm
Pink
BJCC Arena, Birmingham, AL
SELECT * from toolvenuepagelink WHERE venueid = 1854
SELECT * from toolcitypagelink WHERE cityname = 'Bossier City'
Pink
CenturyLink Center - Bossier City Bossier City Bossier City, LA
Mar 16, 8:00 pm 2019
Saturday
Mar 16
8:00 pm
Pink
CenturyLink Center - Bossier City, Bossier City, LA
SELECT * from toolvenuepagelink WHERE venueid = 1103
SELECT * from toolcitypagelink WHERE cityname = 'New Orleans'
Pink
Smoothie King Center New Orleans New Orleans, LA
Mar 17, 7:30 pm 2019
Sunday
Mar 17
7:30 pm
Pink
Smoothie King Center, New Orleans, LA
SELECT * from toolvenuepagelink WHERE venueid = 2786
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
Pink
Toyota Center Houston Houston, TX
Mar 19, 7:30 pm 2019
Tuesday
Mar 19
7:30 pm
Pink
Toyota Center, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 2259
SELECT * from toolcitypagelink WHERE cityname = 'San Antonio'
Pink
AT&T Center San Antonio San Antonio, TX
Mar 21, 7:30 pm 2019
Thursday
Mar 21
7:30 pm
Pink
AT&T Center, San Antonio, TX
SELECT * from toolvenuepagelink WHERE venueid = 2196
SELECT * from toolcitypagelink WHERE cityname = 'Oklahoma City'
Pink
Chesapeake Energy Arena Oklahoma City Oklahoma City, OK
Mar 22, 8:00 pm 2019
Friday
Mar 22
8:00 pm
Pink
Chesapeake Energy Arena, Oklahoma City, OK
SELECT * from toolvenuepagelink WHERE venueid = 2196
SELECT * from toolcitypagelink WHERE cityname = 'Oklahoma City'
Pink
Chesapeake Energy Arena Oklahoma City Oklahoma City, OK
Mar 23, 8:00 pm 2019
Saturday
Mar 23
8:00 pm
Pink
Chesapeake Energy Arena, Oklahoma City, OK
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Pink
American Airlines Center Dallas Dallas, TX
Mar 24, 7:30 pm 2019
Sunday
Mar 24
7:30 pm
Pink
American Airlines Center, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 33422
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
Pink
Little Caesars Arena Detroit Detroit, MI
Mar 25, 7:30 pm 2019
Monday
Mar 25
7:30 pm
Pink
Little Caesars Arena, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 2763
SELECT * from toolcitypagelink WHERE cityname = 'Glendale'
Pink
Gila River Arena Glendale Glendale, AZ
Mar 30, 8:00 pm 2019
Saturday
Mar 30
8:00 pm
Pink
Gila River Arena, Glendale, AZ
SELECT * from toolvenuepagelink WHERE venueid = 1219
SELECT * from toolcitypagelink WHERE cityname = 'Denver'

April

Pink
Pepsi Center Denver Denver, CO
Apr 1, 7:30 pm 2019
Monday
Apr 1
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
Apr 3, 7:30 pm 2019
Wednesday
Apr 3
7:30 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
Apr 5, 8:00 pm 2019
Friday
Apr 5
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 557
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Pink
Rogers Arena Vancouver Vancouver, BC
Apr 6, 8:00 pm 2019
Saturday
Apr 6
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 1343
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Pink
Moda Center Portland Portland, OR
Apr 8, 7:30 pm 2019
Monday
Apr 8
7:30 pm
Pink
Moda Center, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 32836
SELECT * from toolcitypagelink WHERE cityname = 'Sacramento'
Pink
Golden 1 Center Sacramento Sacramento, CA
Apr 10, 7:30 pm 2019
Wednesday
Apr 10
7:30 pm
Pink
Golden 1 Center, Sacramento, CA
SELECT * from toolvenuepagelink WHERE venueid = 32725
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'
Pink
T-Mobile Arena Las Vegas Las Vegas, NV
Apr 12, 8:00 pm 2019
Friday
Apr 12
8:00 pm
Pink
T-Mobile Arena, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 1480
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Pink
Staples Center Los Angeles Los Angeles, CA
Apr 15, 7:30 pm 2019
Monday
Apr 15
7:30 pm
Pink
Staples Center, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 1384
SELECT * from toolcitypagelink WHERE cityname = 'San Jose'
Pink
SAP Center at San Jose San Jose San Jose, CA
Apr 17, 7:30 pm 2019
Wednesday
Apr 17
7:30 pm
Pink
SAP Center at San Jose, San Jose, CA
SELECT * from toolvenuepagelink WHERE venueid = 602
SELECT * from toolcitypagelink WHERE cityname = 'Inglewood'
Pink
The Forum Inglewood Inglewood, CA
Apr 19, 7:30 pm 2019
Friday
Apr 19
7:30 pm
Pink
The Forum, Inglewood, CA
SELECT * from toolvenuepagelink WHERE venueid = 33422
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
Pink
Little Caesars Arena Detroit Detroit, MI
Apr 26, 7:30 pm 2019
Friday
Apr 26
7:30 pm
Pink
Little Caesars Arena, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 33422
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
Pink
Little Caesars Arena Detroit Detroit, MI
Apr 27, 8:00 pm 2019
Saturday
Apr 27
8:00 pm
Pink
Little Caesars Arena, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 324
SELECT * from toolcitypagelink WHERE cityname = 'Indianapolis'
Pink
Bankers Life Fieldhouse Indianapolis Indianapolis, IN
Apr 30, 7:30 pm 2019
Tuesday
Apr 30
7:30 pm
Pink
Bankers Life Fieldhouse, Indianapolis, IN
SELECT * from toolvenuepagelink WHERE venueid = 33662
SELECT * from toolcitypagelink WHERE cityname = 'Milwaukee'

May

Pink
Fiserv Forum Milwaukee Milwaukee, WI
May 2, 7:30 pm 2019
Thursday
May 2
7:30 pm
Pink
Fiserv Forum, Milwaukee, WI
SELECT * from toolvenuepagelink WHERE venueid = 481
SELECT * from toolcitypagelink WHERE cityname = 'Fargo'
Pink
Fargodome Fargo Fargo, ND
May 4, 8:00 pm 2019
Saturday
May 4
8:00 pm
Pink
Fargodome, Fargo, ND
SELECT * from toolvenuepagelink WHERE venueid = 1811
SELECT * from toolcitypagelink WHERE cityname = 'St Paul'
Pink
Xcel Energy Center St Paul St Paul, MN
May 5, 7:30 pm 2019
Sunday
May 5
7:30 pm
Pink
Xcel Energy Center, St Paul, MN
SELECT * from toolvenuepagelink WHERE venueid = 2766
SELECT * from toolcitypagelink WHERE cityname = 'Omaha'
Pink
CHI Health Center Omaha Omaha Omaha, NE
May 7, 7:30 pm 2019
Tuesday
May 7
7:30 pm
Pink
CHI Health Center Omaha, Omaha, NE
SELECT * from toolvenuepagelink WHERE venueid = 1362
SELECT * from toolcitypagelink WHERE cityname = 'Lexington'
Pink
Rupp Arena Lexington Lexington, KY
May 9, 7:30 pm 2019
Thursday
May 9
7:30 pm
Pink
Rupp Arena, Lexington, KY
SELECT * from toolvenuepagelink WHERE venueid = 33304
SELECT * from toolcitypagelink WHERE cityname = 'Columbus'
Pink
Value City Arena at the Jerome Schottenstein Center Columbus Columbus, OH
May 11, 8:00 pm 2019
Saturday
May 11
8:00 pm
Pink
Value City Arena at the Jerome Schottenstein Center, Columbus, OH
SELECT * from toolvenuepagelink WHERE venueid = 17
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Pink
Scotiabank Arena Toronto Toronto, ON
May 13, 7:30 pm 2019
Monday
May 13
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 17
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Pink
Scotiabank Arena Toronto Toronto, ON
May 14, 7:30 pm 2019
Tuesday
May 14
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 1036
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Pink
Bell Centre Montreal Montreal, QC
May 17, 8:00 pm 2019
Friday
May 17
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 1036
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Pink
Bell Centre Montreal Montreal, QC
May 18, 8:00 pm 2019
Saturday
May 18
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 896
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Pink
Madison Square Garden New York New York, NY
May 21, 7:30 pm 2019
Tuesday
May 21
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
May 22, 7:30 pm 2019
Wednesday
May 22
7:30 pm
Pink
Madison Square Garden, New York, NY
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football