LISTE POUR : Sam Smith

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

March

Sam Smith
SSE Hydro Glasgow Glasgow, UK
Mar 23, 12:00 am 2018
Friday
Mar 23
12:00 am
Sam Smith
SSE Hydro, Glasgow, UK
SELECT * from toolvenuepagelink WHERE venueid = 17
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'

June

Sam Smith
Air Canada Centre Toronto Toronto, ON
Jun 18, 8:00 pm 2018
Monday
Jun 18
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 1036
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Sam Smith
Bell Centre Montreal Montreal, QC
Jun 19, 8:00 pm 2018
Tuesday
Jun 19
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 33422
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
Sam Smith
Little Caesars Arena Detroit Detroit, MI
Jun 22, 8:00 pm 2018
Friday
Jun 22
8:00 pm
Sam Smith
Little Caesars Arena, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 1790
SELECT * from toolcitypagelink WHERE cityname = 'Columbus'
Sam Smith
Nationwide Arena Columbus Columbus, OH
Jun 23, 8:00 pm 2018
Saturday
Jun 23
8:00 pm
Sam Smith
Nationwide Arena, Columbus, OH
SELECT * from toolvenuepagelink WHERE venueid = 507
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Sam Smith
TD Garden Boston Boston, MA
Jun 26, 8:00 pm 2018
Tuesday
Jun 26
8:00 pm
Sam Smith
TD Garden, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 27950
SELECT * from toolcitypagelink WHERE cityname = 'Brooklyn'
Sam Smith
Barclays Center Brooklyn Brooklyn, NY
Jun 27, 8:00 pm 2018
Wednesday
Jun 27
8:00 pm
Sam Smith
Barclays Center, Brooklyn, NY
SELECT * from toolvenuepagelink WHERE venueid = 896
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Sam Smith
Madison Square Garden New York New York, NY
Jun 29, 8:00 pm 2018
Friday
Jun 29
8:00 pm
Sam Smith
Madison Square Garden, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'

July

Sam Smith
Capital One Arena Washington Washington, DC
Jul 3, 7:00 pm 2018
Tuesday
Jul 3
7:00 pm
Sam Smith
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 499
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
Sam Smith
Wells Fargo Center Philadelphia Philadelphia, PA
Jul 4, 8:00 pm 2018
Wednesday
Jul 4
8:00 pm
Sam Smith
Wells Fargo Center, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 3535
SELECT * from toolcitypagelink WHERE cityname = 'Charlotte'
Sam Smith
Spectrum Center Charlotte Charlotte, NC
Jul 6, 8:00 pm 2018
Friday
Jul 6
8:00 pm
Sam Smith
Spectrum Center, Charlotte, NC
SELECT * from toolvenuepagelink WHERE venueid = 1080
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
Sam Smith
Bridgestone Arena Nashville Nashville, TN
Jul 7, 8:00 pm 2018
Saturday
Jul 7
8:00 pm
Sam Smith
Bridgestone Arena, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 617
SELECT * from toolcitypagelink WHERE cityname = 'Duluth'
Sam Smith
Infinite Energy Arena Duluth Duluth, GA
Jul 10, 8:00 pm 2018
Tuesday
Jul 10
8:00 pm
Sam Smith
Infinite Energy Arena, Duluth, GA
SELECT * from toolvenuepagelink WHERE venueid = 1537
SELECT * from toolcitypagelink WHERE cityname = 'Orlando'
Sam Smith
Amway Center Orlando Orlando, FL
Jul 11, 8:00 pm 2018
Wednesday
Jul 11
8:00 pm
Sam Smith
Amway Center, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Sam Smith
Amalie Arena Tampa Tampa, FL
Jul 13, 8:00 pm 2018
Friday
Jul 13
8:00 pm
Sam Smith
Amalie Arena, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 44
SELECT * from toolcitypagelink WHERE cityname = 'Miami'
Sam Smith
American Airlines Arena Miami Miami, FL
Jul 14, 8:00 pm 2018
Saturday
Jul 14
8:00 pm
Sam Smith
American Airlines Arena, Miami, FL
SELECT * from toolvenuepagelink WHERE venueid = 1103
SELECT * from toolcitypagelink WHERE cityname = 'New Orleans'
Sam Smith
Smoothie King Center New Orleans New Orleans, LA
Jul 17, 8:00 pm 2018
Tuesday
Jul 17
8:00 pm
Sam Smith
Smoothie King Center, New Orleans, LA
SELECT * from toolvenuepagelink WHERE venueid = 2786
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
Sam Smith
Toyota Center Houston Houston, TX
Jul 18, 7:00 pm 2018
Wednesday
Jul 18
7:00 pm
Sam Smith
Toyota Center, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Sam Smith
American Airlines Center Dallas Dallas, TX
Jul 20, 8:00 pm 2018
Friday
Jul 20
8:00 pm
Sam Smith
American Airlines Center, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 460
SELECT * from toolcitypagelink WHERE cityname = 'Austin'
Sam Smith
Frank Erwin Events Center Austin Austin, TX
Jul 21, 7:00 pm 2018
Saturday
Jul 21
7:00 pm
Sam Smith
Frank Erwin Events Center, Austin, TX
SELECT * from toolvenuepagelink WHERE venueid = 29001
SELECT * from toolcitypagelink WHERE cityname = 'Mexico City'
Sam Smith
Palacio de los Deportes Mexico City Mexico City,
Jul 27, 12:00 am 2018
Friday
Jul 27
12:00 am
Sam Smith
Palacio de los Deportes, Mexico City,
SELECT * from toolvenuepagelink WHERE venueid = 1811
SELECT * from toolcitypagelink WHERE cityname = 'St Paul'

August

Sam Smith
Xcel Energy Center St Paul St Paul, MN
Aug 14, 8:00 pm 2018
Tuesday
Aug 14
8:00 pm
Sam Smith
Xcel Energy Center, St Paul, MN
SELECT * from toolvenuepagelink WHERE venueid = 1633
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Sam Smith
United Center Chicago Chicago, IL
Aug 15, 8:00 pm 2018
Wednesday
Aug 15
8:00 pm
Sam Smith
United Center, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 5263
SELECT * from toolcitypagelink WHERE cityname = 'St Louis'
Sam Smith
Chaifetz Arena St Louis St Louis, MO
Aug 17, 8:00 pm 2018
Friday
Aug 17
8:00 pm
Sam Smith
Chaifetz Arena, St Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 4603
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Sam Smith
Sprint Center Kansas City Kansas City, MO
Aug 18, 8:00 pm 2018
Saturday
Aug 18
8:00 pm
Sam Smith
Sprint Center, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 1219
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Sam Smith
Pepsi Center Denver Denver, CO
Aug 21, 8:00 pm 2018
Tuesday
Aug 21
8:00 pm
Sam Smith
Pepsi Center, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 399
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
Sam Smith
Vivint Smart Home Arena Salt Lake City Salt Lake City, UT
Aug 22, 8:00 pm 2018
Wednesday
Aug 22
8:00 pm
Sam Smith
Vivint Smart Home Arena, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 32836
SELECT * from toolcitypagelink WHERE cityname = 'Sacramento'
Sam Smith
Golden 1 Center Sacramento Sacramento, CA
Aug 24, 8:00 pm 2018
Friday
Aug 24
8:00 pm
Sam Smith
Golden 1 Center, Sacramento, CA
SELECT * from toolvenuepagelink WHERE venueid = 1480
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Sam Smith
Staples Center Los Angeles Los Angeles, CA
Aug 28, 8:00 pm 2018
Tuesday
Aug 28
8:00 pm
Sam Smith
Staples Center, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 1480
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Sam Smith
Staples Center Los Angeles Los Angeles, CA
Aug 29, 8:00 pm 2018
Wednesday
Aug 29
8:00 pm
Sam Smith
Staples Center, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 2763
SELECT * from toolcitypagelink WHERE cityname = 'Glendale'
Sam Smith
Gila River Arena Glendale Glendale, AZ
Aug 31, 8:00 pm 2018
Friday
Aug 31
8:00 pm
Sam Smith
Gila River Arena, Glendale, AZ
SELECT * from toolvenuepagelink WHERE venueid = 8000
SELECT * from toolcitypagelink WHERE cityname = 'San Diego'

September

Sam Smith
Valley View Casino Center San Diego San Diego, CA
Sep 1, 8:00 pm 2018
Saturday
Sep 1
8:00 pm
Sam Smith
Valley View Casino Center, San Diego, CA
SELECT * from toolvenuepagelink WHERE venueid = 1129
SELECT * from toolcitypagelink WHERE cityname = 'Oakland'
Sam Smith
Oracle Arena Oakland Oakland, CA
Sep 4, 8:00 pm 2018
Tuesday
Sep 4
8:00 pm
Sam Smith
Oracle Arena, Oakland, CA
SELECT * from toolvenuepagelink WHERE venueid = 1384
SELECT * from toolcitypagelink WHERE cityname = 'San Jose'
Sam Smith
SAP Center at San Jose San Jose San Jose, CA
Sep 5, 8:00 pm 2018
Wednesday
Sep 5
8:00 pm
Sam Smith
SAP Center at San Jose, San Jose, CA
SELECT * from toolvenuepagelink WHERE venueid = 1343
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Sam Smith
Moda Center Portland Portland, OR
Sep 7, 8:00 pm 2018
Friday
Sep 7
8:00 pm
Sam Smith
Moda Center, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 781
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Sam Smith
Key Arena Seattle Seattle, WA
Sep 8, 8:00 pm 2018
Saturday
Sep 8
8:00 pm
Sam Smith
Key Arena, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 557
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Sam Smith
Rogers Arena Vancouver Vancouver, BC
Sep 10, 8:00 pm 2018
Monday
Sep 10
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 33142
SELECT * from toolcitypagelink WHERE cityname = 'Edmonton'
Sam Smith
Rogers Place Edmonton Edmonton, AB
Sep 12, 8:00 pm 2018
Wednesday
Sep 12
8:00 pm
Sam Smith
Rogers Place, Edmonton, AB
SELECT * from toolvenuepagelink WHERE venueid = 1367
SELECT * from toolcitypagelink WHERE cityname = 'Calgary'
Sam Smith
Scotiabank Saddledome Calgary Calgary, AB
Sep 13, 8:00 pm 2018
Thursday
Sep 13
8:00 pm
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football