LISTE POUR : Weezer

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

March

Weezer and Pixies
KFC Yum! Center Louisville Louisville, KY
Mar 8, 7:00 pm 2019
Friday
Mar 8
7:00 pm
Weezer and Pixies
KFC Yum! Center, Louisville, KY
SELECT * from toolvenuepagelink WHERE venueid = 5748
SELECT * from toolcitypagelink WHERE cityname = 'Columbia'
Weezer and Pixies
Colonial Life Arena Columbia Columbia, SC
Mar 10, 7:00 pm 2019
Sunday
Mar 10
7:00 pm
Weezer and Pixies
Colonial Life Arena, Columbia, SC
SELECT * from toolvenuepagelink WHERE venueid = 896
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Pixies with Weezer
Madison Square Garden New York New York, NY
Mar 12, 7:00 pm 2019
Tuesday
Mar 12
7:00 pm
Pixies with Weezer
Madison Square Garden, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 1036
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Weezer
Bell Centre Montreal Montreal, QC
Mar 13, 7:00 pm 2019
Wednesday
Mar 13
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 1218
SELECT * from toolcitypagelink WHERE cityname = 'Albany'
Weezer and Pixies
Times Union Center Albany Albany, NY
Mar 14, 7:00 pm 2019
Thursday
Mar 14
7:00 pm
Weezer and Pixies
Times Union Center, Albany, NY
SELECT * from toolvenuepagelink WHERE venueid = 5410
SELECT * from toolcitypagelink WHERE cityname = 'Mashantucket'
Weezer with Pixies
Grand Theater at Foxwoods Mashantucket Mashantucket, CT
Mar 16, 7:00 pm 2019
Saturday
Mar 16
7:00 pm
Weezer with Pixies
Grand Theater at Foxwoods, Mashantucket, CT
SELECT * from toolvenuepagelink WHERE venueid = 103
SELECT * from toolcitypagelink WHERE cityname = 'Baltimore'
Weezer and Pixies
Royal Farms Arena Baltimore Baltimore, MD
Mar 17, 7:00 pm 2019
Sunday
Mar 17
7:00 pm
Weezer and Pixies
Royal Farms Arena, Baltimore, MD
SELECT * from toolvenuepagelink WHERE venueid = 33304
SELECT * from toolcitypagelink WHERE cityname = 'Columbus'
Weezer and Pixies
Value City Arena at the Jerome Schottenstein Center Columbus Columbus, OH
Mar 19, 7:00 pm 2019
Tuesday
Mar 19
7:00 pm
Weezer and Pixies
Value City Arena at the Jerome Schottenstein Center, Columbus, OH
SELECT * from toolvenuepagelink WHERE venueid = 1663
SELECT * from toolcitypagelink WHERE cityname = 'Grand Rapids'
Weezer and Pixies
Van Andel Arena Grand Rapids Grand Rapids, MI
Mar 20, 7:00 pm 2019
Wednesday
Mar 20
7:00 pm
Weezer and Pixies
Van Andel Arena, Grand Rapids, MI
SELECT * from toolvenuepagelink WHERE venueid = 3123
SELECT * from toolcitypagelink WHERE cityname = 'Memphis'
Weezer and Pixies
FedEx Forum Memphis Memphis, TN
Mar 22, 7:00 pm 2019
Friday
Mar 22
7:00 pm
Weezer and Pixies
FedEx Forum, Memphis, TN
SELECT * from toolvenuepagelink WHERE venueid = 785
SELECT * from toolcitypagelink WHERE cityname = 'St Louis'
Weezer and Pixies
Enterprise Center St Louis St Louis, MO
Mar 24, 7:00 pm 2019
Sunday
Mar 24
7:00 pm
Weezer and Pixies
Enterprise Center, St Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 4603
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Weezer and Pixies
Sprint Center Kansas City Kansas City, MO
Mar 26, 7:00 pm 2019
Tuesday
Mar 26
7:00 pm
Weezer and Pixies
Sprint Center, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 5118
SELECT * from toolcitypagelink WHERE cityname = 'Tulsa'
Weezer and Pixies
BOK Center Tulsa Tulsa, OK
Mar 27, 7:00 pm 2019
Wednesday
Mar 27
7:00 pm
Weezer and Pixies
BOK Center, Tulsa, OK
SELECT * from toolvenuepagelink WHERE venueid = 3536
SELECT * from toolcitypagelink WHERE cityname = 'Des Moines'
Weezer
Wells Fargo Arena - Des Moines Des Moines Des Moines, IA
Mar 28, 7:00 pm 2019
Thursday
Mar 28
7:00 pm
Weezer
Wells Fargo Arena - Des Moines, Des Moines, IA
SELECT * from toolvenuepagelink WHERE venueid = 1811
SELECT * from toolcitypagelink WHERE cityname = 'St Paul'
Weezer and Pixies
Xcel Energy Center St Paul St Paul, MN
Mar 30, 7:00 pm 2019
Saturday
Mar 30
7:00 pm
Weezer and Pixies
Xcel Energy Center, St Paul, MN
SELECT * from toolvenuepagelink WHERE venueid = 380
SELECT * from toolcitypagelink WHERE cityname = 'Madison'
Weezer and Pixies
Coliseum at Alliant Energy Center Madison Madison, WI
Mar 31, 7:00 pm 2019
Sunday
Mar 31
7:00 pm
Weezer and Pixies
Coliseum at Alliant Energy Center, Madison, WI
SELECT * from toolvenuepagelink WHERE venueid = 702
SELECT * from toolcitypagelink WHERE cityname = 'Nampa'

April

Weezer
Ford Idaho Center Nampa Nampa, ID
Apr 5, 7:00 pm 2019
Friday
Apr 5
7:00 pm
Weezer
Ford Idaho Center, Nampa, ID
SELECT * from toolvenuepagelink WHERE venueid = 1343
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Weezer and Pixies
Moda Center Portland Portland, OR
Apr 6, 7:00 pm 2019
Saturday
Apr 6
7:00 pm
Weezer and Pixies
Moda Center, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 557
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Weezer and Pixies
Rogers Arena Vancouver Vancouver, BC
Apr 7, 7:00 pm 2019
Sunday
Apr 7
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 32836
SELECT * from toolcitypagelink WHERE cityname = 'Sacramento'
Weezer and Pixies
Golden 1 Center Sacramento Sacramento, CA
Apr 9, 7:00 pm 2019
Tuesday
Apr 9
7:00 pm
Weezer and Pixies
Golden 1 Center, Sacramento, CA
SELECT * from toolvenuepagelink WHERE venueid = 1129
SELECT * from toolcitypagelink WHERE cityname = 'Oakland'
Weezer and Pixies
Oracle Arena Oakland Oakland, CA
Apr 10, 7:00 pm 2019
Wednesday
Apr 10
7:00 pm
Weezer and Pixies
Oracle Arena, Oakland, CA
SELECT * from toolvenuepagelink WHERE venueid = 3571
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'
Weezer and Pixies
Mandalay Bay Events Center Las Vegas Las Vegas, NV
Apr 12, 8:00 pm 2019
Friday
Apr 12
8:00 pm
Weezer and Pixies
Mandalay Bay Events Center, Las Vegas, NV
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football