LISTE POUR : Shawn Mendes

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

June

Shawn Mendes
Moda Center Portland Portland, OR
Jun 12, 7:30 pm 2019
Wednesday
Jun 12
7:30 pm
Shawn Mendes
Moda Center, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 557
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Shawn Mendes
Rogers Arena Vancouver Vancouver, BC
Jun 14, 7:30 pm 2019
Friday
Jun 14
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 33142
SELECT * from toolcitypagelink WHERE cityname = 'Edmonton'
Shawn Mendes
Rogers Place Edmonton Edmonton, AB
Jun 16, 7:30 pm 2019
Sunday
Jun 16
7:30 pm
Shawn Mendes
Rogers Place, Edmonton, AB
SELECT * from toolvenuepagelink WHERE venueid = 3316
SELECT * from toolcitypagelink WHERE cityname = 'Winnipeg'
Shawn Mendes
Bell MTS Place Winnipeg Winnipeg, MB
Jun 19, 7:30 pm 2019
Wednesday
Jun 19
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 1811
SELECT * from toolcitypagelink WHERE cityname = 'St Paul'
Shawn Mendes
Xcel Energy Center St Paul St Paul, MN
Jun 21, 7:30 pm 2019
Friday
Jun 21
7:30 pm
Shawn Mendes
Xcel Energy Center, St Paul, MN
SELECT * from toolvenuepagelink WHERE venueid = 3536
SELECT * from toolcitypagelink WHERE cityname = 'Des Moines'
Shawn Mendes
Wells Fargo Arena - Des Moines Des Moines Des Moines, IA
Jun 22, 7:30 pm 2019
Saturday
Jun 22
7:30 pm
Shawn Mendes
Wells Fargo Arena - Des Moines, Des Moines, IA
SELECT * from toolvenuepagelink WHERE venueid = 33
SELECT * from toolcitypagelink WHERE cityname = 'Rosemont'
Shawn Mendes
Allstate Arena Rosemont Rosemont, IL
Jun 27, 7:30 pm 2019
Thursday
Jun 27
7:30 pm
Shawn Mendes
Allstate Arena, Rosemont, IL
SELECT * from toolvenuepagelink WHERE venueid = 785
SELECT * from toolcitypagelink WHERE cityname = 'St Louis'
Shawn Mendes
Enterprise Center St Louis St Louis, MO
Jun 30, 7:30 pm 2019
Sunday
Jun 30
7:30 pm
Shawn Mendes
Enterprise Center, St Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 1219
SELECT * from toolcitypagelink WHERE cityname = 'Denver'

July

Shawn Mendes
Pepsi Center Denver Denver, CO
Jul 2, 7:30 pm 2019
Tuesday
Jul 2
7:30 pm
Shawn Mendes
Pepsi Center, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 1480
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Shawn Mendes
Staples Center Los Angeles Los Angeles, CA
Jul 5, 7:30 pm 2019
Friday
Jul 5
7:30 pm
Shawn Mendes
Staples Center, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 8000
SELECT * from toolcitypagelink WHERE cityname = 'San Diego'
Shawn Mendes
Pechanga Arena San Diego San Diego, CA
Jul 8, 7:30 pm 2019
Monday
Jul 8
7:30 pm
Shawn Mendes
Pechanga Arena, San Diego, CA
SELECT * from toolvenuepagelink WHERE venueid = 2763
SELECT * from toolcitypagelink WHERE cityname = 'Glendale'
Shawn Mendes
Gila River Arena Glendale Glendale, AZ
Jul 9, 7:30 pm 2019
Tuesday
Jul 9
7:30 pm
Shawn Mendes
Gila River Arena, Glendale, AZ
SELECT * from toolvenuepagelink WHERE venueid = 32836
SELECT * from toolcitypagelink WHERE cityname = 'Sacramento'
Shawn Mendes
Golden 1 Center Sacramento Sacramento, CA
Jul 11, 7:30 pm 2019
Thursday
Jul 11
7:30 pm
Shawn Mendes
Golden 1 Center, Sacramento, CA
SELECT * from toolvenuepagelink WHERE venueid = 1129
SELECT * from toolcitypagelink WHERE cityname = 'Oakland'
Shawn Mendes
Oracle Arena Oakland Oakland, CA
Jul 13, 7:30 pm 2019
Saturday
Jul 13
7:30 pm
Shawn Mendes
Oracle Arena, Oakland, CA
SELECT * from toolvenuepagelink WHERE venueid = 399
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
Shawn Mendes
Vivint Smart Home Arena Salt Lake City Salt Lake City, UT
Jul 16, 7:30 pm 2019
Tuesday
Jul 16
7:30 pm
Shawn Mendes
Vivint Smart Home Arena, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 4603
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Shawn Mendes
Sprint Center Kansas City Kansas City, MO
Jul 19, 7:30 pm 2019
Friday
Jul 19
7:30 pm
Shawn Mendes
Sprint Center, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 5118
SELECT * from toolcitypagelink WHERE cityname = 'Tulsa'
Shawn Mendes
BOK Center Tulsa Tulsa, OK
Jul 20, 7:30 pm 2019
Saturday
Jul 20
7:30 pm
Shawn Mendes
BOK Center, Tulsa, OK
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Shawn Mendes
American Airlines Center Dallas Dallas, TX
Jul 22, 7:30 pm 2019
Monday
Jul 22
7:30 pm
Shawn Mendes
American Airlines Center, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 2259
SELECT * from toolcitypagelink WHERE cityname = 'San Antonio'
Shawn Mendes
AT&T Center San Antonio San Antonio, TX
Jul 23, 7:30 pm 2019
Tuesday
Jul 23
7:30 pm
Shawn Mendes
AT&T Center, San Antonio, TX
SELECT * from toolvenuepagelink WHERE venueid = 2786
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
Shawn Mendes
Toyota Center Houston Houston, TX
Jul 25, 7:30 pm 2019
Thursday
Jul 25
7:30 pm
Shawn Mendes
Toyota Center, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Shawn Mendes
Amalie Arena Tampa Tampa, FL
Jul 27, 7:30 pm 2019
Saturday
Jul 27
7:30 pm
Shawn Mendes
Amalie Arena, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 44
SELECT * from toolcitypagelink WHERE cityname = 'Miami'
Shawn Mendes
American Airlines Arena Miami Miami, FL
Jul 28, 7:30 pm 2019
Sunday
Jul 28
7:30 pm
Shawn Mendes
American Airlines Arena, Miami, FL
SELECT * from toolvenuepagelink WHERE venueid = 1537
SELECT * from toolcitypagelink WHERE cityname = 'Orlando'
Shawn Mendes
Amway Center Orlando Orlando, FL
Jul 30, 7:30 pm 2019
Tuesday
Jul 30
7:30 pm
Shawn Mendes
Amway Center, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 1228
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Shawn Mendes
State Farm Arena - GA Atlanta Atlanta, GA
Jul 31, 7:30 pm 2019
Wednesday
Jul 31
7:30 pm
Shawn Mendes
State Farm Arena - GA, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 1080
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'

August

Shawn Mendes
Bridgestone Arena Nashville Nashville, TN
Aug 2, 7:30 pm 2019
Friday
Aug 2
7:30 pm
Shawn Mendes
Bridgestone Arena, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 33422
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
Shawn Mendes
Little Caesars Arena Detroit Detroit, MI
Aug 5, 7:30 pm 2019
Monday
Aug 5
7:30 pm
Shawn Mendes
Little Caesars Arena, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 7329
SELECT * from toolcitypagelink WHERE cityname = 'Pittsburgh'
Shawn Mendes
PPG Paints Arena Pittsburgh Pittsburgh, PA
Aug 6, 7:30 pm 2019
Tuesday
Aug 6
7:30 pm
Shawn Mendes
PPG Paints Arena, Pittsburgh, PA
SELECT * from toolvenuepagelink WHERE venueid = 4797
SELECT * from toolcitypagelink WHERE cityname = 'Newark'
Shawn Mendes
Prudential Center Newark Newark, NJ
Aug 10, 7:30 pm 2019
Saturday
Aug 10
7:30 pm
Shawn Mendes
Prudential Center, Newark, NJ
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Shawn Mendes
Capital One Arena Washington Washington, DC
Aug 13, 7:30 pm 2019
Tuesday
Aug 13
7:30 pm
Shawn Mendes
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 507
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Shawn Mendes
TD Garden Boston Boston, MA
Aug 15, 7:30 pm 2019
Thursday
Aug 15
7:30 pm
Shawn Mendes
TD Garden, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 1036
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Shawn Mendes
Bell Centre Montreal Montreal, QC
Aug 21, 7:30 pm 2019
Wednesday
Aug 21
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 27950
SELECT * from toolcitypagelink WHERE cityname = 'Brooklyn'
Shawn Mendes
Barclays Center Brooklyn Brooklyn, NY
Aug 24, 7:30 pm 2019
Saturday
Aug 24
7:30 pm
Shawn Mendes
Barclays Center, Brooklyn, NY
SELECT * from toolvenuepagelink WHERE venueid = 1436
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'

September

Shawn Mendes
Rogers Centre Toronto Toronto, ON
Sep 6, 7:30 pm 2019
Friday
Sep 6
7:30 pm
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football