LISTE POUR : Game of Thrones Live

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

September

Game of Thrones Live Concert Experience
Rogers Arena Vancouver Vancouver, BC
Sep 5, 8:00 pm 2018
Wednesday
Sep 5
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 781
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Game of Thrones Live Concert Experience
Key Arena Seattle Seattle, WA
Sep 6, 8:00 pm 2018
Thursday
Sep 6
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 1384
SELECT * from toolcitypagelink WHERE cityname = 'San Jose'
Game of Thrones Live Concert Experience
SAP Center at San Jose San Jose San Jose, CA
Sep 8, 8:00 pm 2018
Saturday
Sep 8
8:00 pm
Game of Thrones Live Concert Experience
SAP Center at San Jose, San Jose, CA
SELECT * from toolvenuepagelink WHERE venueid = 602
SELECT * from toolcitypagelink WHERE cityname = 'Inglewood'
Game of Thrones Live Concert Experience
The Forum Inglewood Inglewood, CA
Sep 9, 8:00 pm 2018
Sunday
Sep 9
8:00 pm
Game of Thrones Live Concert Experience
The Forum, Inglewood, CA
SELECT * from toolvenuepagelink WHERE venueid = 362
SELECT * from toolcitypagelink WHERE cityname = 'San Diego'
Game of Thrones Live Concert Experience
Viejas Arena San Diego San Diego, CA
Sep 11, 8:00 pm 2018
Tuesday
Sep 11
8:00 pm
Game of Thrones Live Concert Experience
Viejas Arena, San Diego, CA
SELECT * from toolvenuepagelink WHERE venueid = 2763
SELECT * from toolcitypagelink WHERE cityname = 'Glendale'
Game of Thrones Live Concert Experience
Gila River Arena Glendale Glendale, AZ
Sep 12, 8:00 pm 2018
Wednesday
Sep 12
8:00 pm
Game of Thrones Live Concert Experience
Gila River Arena, Glendale, AZ
SELECT * from toolvenuepagelink WHERE venueid = 1219
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Game of Thrones Live Concert Experience
Pepsi Center Denver Denver, CO
Sep 14, 8:00 pm 2018
Friday
Sep 14
8:00 pm
Game of Thrones Live Concert Experience
Pepsi Center, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Game of Thrones Live Concert Experience
American Airlines Center Dallas Dallas, TX
Sep 16, 8:00 pm 2018
Sunday
Sep 16
8:00 pm
Game of Thrones Live Concert Experience
American Airlines Center, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 2786
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
Game of Thrones Live Concert Experience
Toyota Center Houston Houston, TX
Sep 17, 8:00 pm 2018
Monday
Sep 17
8:00 pm
Game of Thrones Live Concert Experience
Toyota Center, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 460
SELECT * from toolcitypagelink WHERE cityname = 'Austin'
Game of Thrones Live Concert Experience
Frank Erwin Events Center Austin Austin, TX
Sep 18, 7:00 pm 2018
Tuesday
Sep 18
7:00 pm
Game of Thrones Live Concert Experience
Frank Erwin Events Center, Austin, TX
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Game of Thrones Live Concert Experience
Amalie Arena Tampa Tampa, FL
Sep 21, 8:00 pm 2018
Friday
Sep 21
8:00 pm
Game of Thrones Live Concert Experience
Amalie Arena, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 1085
SELECT * from toolcitypagelink WHERE cityname = 'Sunrise'
Game of Thrones Live Concert Experience
BB&T Center Sunrise Sunrise, FL
Sep 22, 8:00 pm 2018
Saturday
Sep 22
8:00 pm
Game of Thrones Live Concert Experience
BB&T Center, Sunrise, FL
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Game of Thrones Live Concert Experience
Capital One Arena Washington Washington, DC
Sep 25, 8:00 pm 2018
Tuesday
Sep 25
8:00 pm
Game of Thrones Live Concert Experience
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 4797
SELECT * from toolcitypagelink WHERE cityname = 'Newark'
Game of Thrones Live Concert Experience
Prudential Center Newark Newark, NJ
Sep 26, 8:00 pm 2018
Wednesday
Sep 26
8:00 pm
Game of Thrones Live Concert Experience
Prudential Center, Newark, NJ
SELECT * from toolvenuepagelink WHERE venueid = 2061
SELECT * from toolcitypagelink WHERE cityname = 'Uncasville'
Game of Thrones Live Concert Experience
Mohegan Sun Arena Uncasville Uncasville, CT
Sep 28, 8:00 pm 2018
Friday
Sep 28
8:00 pm
Game of Thrones Live Concert Experience
Mohegan Sun Arena, Uncasville, CT
SELECT * from toolvenuepagelink WHERE venueid = 2172
SELECT * from toolcitypagelink WHERE cityname = 'Worcester'
Game of Thrones Live Concert Experience
DCU Center Worcester Worcester, MA
Sep 29, 8:00 pm 2018
Saturday
Sep 29
8:00 pm
Game of Thrones Live Concert Experience
DCU Center, Worcester, MA
SELECT * from toolvenuepagelink WHERE venueid = 196
SELECT * from toolcitypagelink WHERE cityname = 'State College'
Game of Thrones Live Concert Experience
Bryce Jordan Center State College State College, PA
Sep 30, 8:00 pm 2018
Sunday
Sep 30
8:00 pm
Game of Thrones Live Concert Experience
Bryce Jordan Center, State College, PA
SELECT * from toolvenuepagelink WHERE venueid = 499
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'

October

Game of Thrones Live Concert Experience
Wells Fargo Center Philadelphia Philadelphia, PA
Oct 2, 8:00 pm 2018
Tuesday
Oct 2
8:00 pm
Game of Thrones Live Concert Experience
Wells Fargo Center, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 896
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Game of Thrones Live Concert Experience
Madison Square Garden New York New York, NY
Oct 3, 8:00 pm 2018
Wednesday
Oct 3
8:00 pm
Game of Thrones Live Concert Experience
Madison Square Garden, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 785
SELECT * from toolcitypagelink WHERE cityname = 'St Louis'
Game of Thrones Live Concert Experience
Scottrade Center St Louis St Louis, MO
Oct 5, 8:00 pm 2018
Friday
Oct 5
8:00 pm
Game of Thrones Live Concert Experience
Scottrade Center, St Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 33
SELECT * from toolcitypagelink WHERE cityname = 'Rosemont'
Game of Thrones Live Concert Experience
Allstate Arena Rosemont Rosemont, IL
Oct 6, 8:00 pm 2018
Saturday
Oct 6
8:00 pm
Game of Thrones Live Concert Experience
Allstate Arena, Rosemont, IL
SELECT * from toolvenuepagelink WHERE venueid = 33422
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
Game of Thrones Live Concert Experience
Little Caesars Arena Detroit Detroit, MI
Oct 9, 8:00 pm 2018
Tuesday
Oct 9
8:00 pm
Game of Thrones Live Concert Experience
Little Caesars Arena, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 33304
SELECT * from toolcitypagelink WHERE cityname = 'Columbus'
Game of Thrones Live Concert Experience
Value City Arena at the Jerome Schottenstein Center Columbus Columbus, OH
Oct 10, 8:00 pm 2018
Wednesday
Oct 10
8:00 pm
Game of Thrones Live Concert Experience
Value City Arena at the Jerome Schottenstein Center, Columbus, OH
SELECT * from toolvenuepagelink WHERE venueid = 1036
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Game of Thrones Live Concert Experience
Bell Centre Montreal Montreal, QC
Oct 12, 8:00 pm 2018
Friday
Oct 12
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 17
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Game of Thrones Live Concert Experience
Air Canada Centre Toronto Toronto, ON
Oct 14, 8:00 pm 2018
Sunday
Oct 14
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