LISTE POUR : Queen

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

July

Queen with Adam Lambert
Rogers Arena Vancouver Vancouver, BC
Jul 10, 7:00 pm 2019
Wednesday
Jul 10
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 1526
SELECT * from toolcitypagelink WHERE cityname = 'Tacoma'
Queen with Adam Lambert
Tacoma Dome Tacoma Tacoma, WA
Jul 12, 7:00 pm 2019
Friday
Jul 12
7:00 pm
Queen with Adam Lambert
Tacoma Dome, Tacoma, WA
SELECT * from toolvenuepagelink WHERE venueid = 1384
SELECT * from toolcitypagelink WHERE cityname = 'San Jose'
Queen with Adam Lambert
SAP Center at San Jose San Jose San Jose, CA
Jul 14, 7:00 pm 2019
Sunday
Jul 14
7:00 pm
Queen with Adam Lambert
SAP Center at San Jose, San Jose, CA
SELECT * from toolvenuepagelink WHERE venueid = 43
SELECT * from toolcitypagelink WHERE cityname = 'Phoenix'
Queen with Adam Lambert
Talking Stick Resort Arena Phoenix Phoenix, AZ
Jul 16, 7:00 pm 2019
Tuesday
Jul 16
7:00 pm
Queen with Adam Lambert
Talking Stick Resort Arena, Phoenix, AZ
SELECT * from toolvenuepagelink WHERE venueid = 602
SELECT * from toolcitypagelink WHERE cityname = 'Inglewood'
Queen with Adam Lambert
The Forum Inglewood Inglewood, CA
Jul 19, 7:00 pm 2019
Friday
Jul 19
7:00 pm
Queen with Adam Lambert
The Forum, Inglewood, CA
SELECT * from toolvenuepagelink WHERE venueid = 602
SELECT * from toolcitypagelink WHERE cityname = 'Inglewood'
Queen with Adam Lambert
The Forum Inglewood Inglewood, CA
Jul 20, 8:00 pm 2019
Saturday
Jul 20
8:00 pm
Queen with Adam Lambert
The Forum, Inglewood, CA
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Queen with Adam Lambert
American Airlines Center Dallas Dallas, TX
Jul 23, 7:00 pm 2019
Tuesday
Jul 23
7:00 pm
Queen with Adam Lambert
American Airlines Center, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 2786
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
Queen with Adam Lambert
Toyota Center Houston Houston, TX
Jul 24, 7:00 pm 2019
Wednesday
Jul 24
7:00 pm
Queen with Adam Lambert
Toyota Center, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 33422
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
Queen with Adam Lambert
Little Caesars Arena Detroit Detroit, MI
Jul 27, 7:00 pm 2019
Saturday
Jul 27
7:00 pm
Queen with Adam Lambert
Little Caesars Arena, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 17
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Queen with Adam Lambert
Scotiabank Arena Toronto Toronto, ON
Jul 28, 7:00 pm 2019
Sunday
Jul 28
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Queen with Adam Lambert
Capital One Arena Washington Washington, DC
Jul 30, 7:00 pm 2019
Tuesday
Jul 30
7:00 pm
Queen with Adam Lambert
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 7329
SELECT * from toolcitypagelink WHERE cityname = 'Pittsburgh'
Queen with Adam Lambert
PPG Paints Arena Pittsburgh Pittsburgh, PA
Jul 31, 7:00 pm 2019
Wednesday
Jul 31
7:00 pm
Queen with Adam Lambert
PPG Paints Arena, Pittsburgh, PA
SELECT * from toolvenuepagelink WHERE venueid = 499
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'

August

Queen with Adam Lambert
Wells Fargo Center Philadelphia Philadelphia, PA
Aug 3, 7:00 pm 2019
Saturday
Aug 3
7:00 pm
Queen with Adam Lambert
Wells Fargo Center, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 1618
SELECT * from toolcitypagelink WHERE cityname = 'Mansfield'
Queen with Adam Lambert
Xfinity Center Mansfield Mansfield, MA
Aug 4, 7:00 pm 2019
Sunday
Aug 4
7:00 pm
Queen with Adam Lambert
Xfinity Center, Mansfield, MA
SELECT * from toolvenuepagelink WHERE venueid = 896
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Queen with Adam Lambert
Madison Square Garden New York New York, NY
Aug 6, 7:00 pm 2019
Tuesday
Aug 6
7:00 pm
Queen with Adam Lambert
Madison Square Garden, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 896
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Queen with Adam Lambert
Madison Square Garden New York New York, NY
Aug 7, 8:00 pm 2019
Wednesday
Aug 7
8:00 pm
Queen with Adam Lambert
Madison Square Garden, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 1633
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Queen with Adam Lambert
United Center Chicago Chicago, IL
Aug 9, 7:00 pm 2019
Friday
Aug 9
7:00 pm
Queen with Adam Lambert
United Center, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 1811
SELECT * from toolcitypagelink WHERE cityname = 'St Paul'
Queen with Adam Lambert
Xcel Energy Center St Paul St Paul, MN
Aug 10, 7:00 pm 2019
Saturday
Aug 10
7:00 pm
Queen with Adam Lambert
Xcel Energy Center, St Paul, MN
SELECT * from toolvenuepagelink WHERE venueid = 1790
SELECT * from toolcitypagelink WHERE cityname = 'Columbus'
Queen with Adam Lambert
Nationwide Arena Columbus Columbus, OH
Aug 13, 7:00 pm 2019
Tuesday
Aug 13
7:00 pm
Queen with Adam Lambert
Nationwide Arena, Columbus, OH
SELECT * from toolvenuepagelink WHERE venueid = 1080
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
Queen with Adam Lambert
Bridgestone Arena Nashville Nashville, TN
Aug 15, 7:00 pm 2019
Thursday
Aug 15
7:00 pm
Queen with Adam Lambert
Bridgestone Arena, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 1085
SELECT * from toolcitypagelink WHERE cityname = 'Sunrise'
Queen with Adam Lambert
BB&T Center Sunrise Sunrise, FL
Aug 17, 7:00 pm 2019
Saturday
Aug 17
7:00 pm
Queen with Adam Lambert
BB&T Center, Sunrise, FL
SELECT * from toolvenuepagelink WHERE venueid = 701
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Queen with Adam Lambert
Amalie Arena Tampa Tampa, FL
Aug 18, 7:00 pm 2019
Sunday
Aug 18
7:00 pm
Queen with Adam Lambert
Amalie Arena, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 1103
SELECT * from toolcitypagelink WHERE cityname = 'New Orleans'
Queen with Adam Lambert
Smoothie King Center New Orleans New Orleans, LA
Aug 20, 7:00 pm 2019
Tuesday
Aug 20
7:00 pm
Queen with Adam Lambert
Smoothie King Center, New Orleans, LA
SELECT * from toolvenuepagelink WHERE venueid = 1228
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Queen with Adam Lambert
State Farm Arena - GA Atlanta Atlanta, GA
Aug 22, 7:00 pm 2019
Thursday
Aug 22
7:00 pm
Queen with Adam Lambert
State Farm Arena - GA, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 3535
SELECT * from toolcitypagelink WHERE cityname = 'Charlotte'
Queen with Adam Lambert
Spectrum Center Charlotte Charlotte, NC
Aug 23, 7:00 pm 2019
Friday
Aug 23
7:00 pm
Queen with Adam Lambert
Spectrum Center, Charlotte, NC
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football
NOUVELLES - SPORT