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 = 3123
SELECT * from toolcitypagelink WHERE cityname = 'Memphis'

March

Weezer with Pixies
FedEx Forum Memphis Memphis, TN
Mar 22, 7:00 pm 2019
Friday
Mar 22
7:00 pm
Weezer with Pixies
FedEx Forum, Memphis, TN
SELECT * from toolvenuepagelink WHERE venueid = 785
SELECT * from toolcitypagelink WHERE cityname = 'St Louis'
Weezer with Pixies
Enterprise Center St Louis St Louis, MO
Mar 24, 7:00 pm 2019
Sunday
Mar 24
7:00 pm
Weezer with Pixies
Enterprise Center, St Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 4603
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Weezer with Pixies
Sprint Center Kansas City Kansas City, MO
Mar 26, 7:00 pm 2019
Tuesday
Mar 26
7:00 pm
Weezer with Pixies
Sprint Center, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 5118
SELECT * from toolcitypagelink WHERE cityname = 'Tulsa'
Weezer with Pixies
BOK Center Tulsa Tulsa, OK
Mar 27, 7:00 pm 2019
Wednesday
Mar 27
7:00 pm
Weezer with 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 with Pixies
Xcel Energy Center St Paul St Paul, MN
Mar 30, 7:00 pm 2019
Saturday
Mar 30
7:00 pm
Weezer with Pixies
Xcel Energy Center, St Paul, MN
SELECT * from toolvenuepagelink WHERE venueid = 380
SELECT * from toolcitypagelink WHERE cityname = 'Madison'
Weezer with Pixies
Coliseum at Alliant Energy Center Madison Madison, WI
Mar 31, 7:00 pm 2019
Sunday
Mar 31
7:00 pm
Weezer with 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 with Pixies
Moda Center Portland Portland, OR
Apr 6, 7:00 pm 2019
Saturday
Apr 6
7:00 pm
Weezer with Pixies
Moda Center, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 557
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Weezer with 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 with Pixies
Golden 1 Center Sacramento Sacramento, CA
Apr 9, 7:00 pm 2019
Tuesday
Apr 9
7:00 pm
Weezer with Pixies
Golden 1 Center, Sacramento, CA
SELECT * from toolvenuepagelink WHERE venueid = 1129
SELECT * from toolcitypagelink WHERE cityname = 'Oakland'
Weezer with Pixies
Oracle Arena Oakland Oakland, CA
Apr 10, 7:00 pm 2019
Wednesday
Apr 10
7:00 pm
Weezer with Pixies
Oracle Arena, Oakland, CA
SELECT * from toolvenuepagelink WHERE venueid = 3571
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'
Weezer with Pixies
Mandalay Bay Events Center Las Vegas Las Vegas, NV
Apr 12, 8:00 pm 2019
Friday
Apr 12
8:00 pm
Weezer with 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