LISTE POUR : Weird Al Yankovic

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

May

Weird Al Yankovic
Revolution Hall - Portland Portland Portland, OR
May 25, 8:00 pm 2018
Friday
May 25
8:00 pm
Weird Al Yankovic
Revolution Hall - Portland, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 32235
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Weird Al Yankovic
Revolution Hall - Portland Portland Portland, OR
May 26, 7:00 pm 2018
Saturday
May 26
7:00 pm
Weird Al Yankovic
Revolution Hall - Portland, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 5787
SELECT * from toolcitypagelink WHERE cityname = 'Spokane'
Weird Al Yankovic
Fox Theater Spokane Spokane Spokane, WA
May 27, 8:00 pm 2018
Sunday
May 27
8:00 pm
Weird Al Yankovic
Fox Theater Spokane, Spokane, WA
SELECT * from toolvenuepagelink WHERE venueid = 1046
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Weird Al Yankovic
Moore Theatre Seattle Seattle, WA
May 29, 8:00 pm 2018
Tuesday
May 29
8:00 pm
Weird Al Yankovic
Moore Theatre, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 32386
SELECT * from toolcitypagelink WHERE cityname = 'Calgary'
Weird Al Yankovic
Grey Eagle Resort Calgary Calgary, AB
May 31, 8:00 pm 2018
Thursday
May 31
8:00 pm
Weird Al Yankovic
Grey Eagle Resort, Calgary, AB
SELECT * from toolvenuepagelink WHERE venueid = 28576
SELECT * from toolcitypagelink WHERE cityname = 'Regina'

June

Weird Al Yankovic
Casino Regina Regina Regina, SK
Jun 1, 8:00 pm 2018
Friday
Jun 1
8:00 pm
Weird Al Yankovic
Casino Regina, Regina, SK
SELECT * from toolvenuepagelink WHERE venueid = 4861
SELECT * from toolcitypagelink WHERE cityname = 'Enoch'
Weird Al Yankovic
River Cree Casino Enoch Enoch, AB
Jun 2, 9:00 pm 2018
Saturday
Jun 2
9:00 pm
Weird Al Yankovic
River Cree Casino, Enoch, AB
SELECT * from toolvenuepagelink WHERE venueid = 6430
SELECT * from toolcitypagelink WHERE cityname = 'Medicine Hat'
Weird Al Yankovic
Esplanade Arts and Heritage Centre Medicine Hat Medicine Hat, AB
Jun 3, 8:00 pm 2018
Sunday
Jun 3
8:00 pm
Weird Al Yankovic
Esplanade Arts and Heritage Centre, Medicine Hat, AB
SELECT * from toolvenuepagelink WHERE venueid = 3021
SELECT * from toolcitypagelink WHERE cityname = 'Winnipeg'
Weird Al Yankovic
Burton Cummings Theatre Winnipeg Winnipeg, MB
Jun 5, 8:00 pm 2018
Tuesday
Jun 5
8:00 pm
Weird Al Yankovic
Burton Cummings Theatre, Winnipeg, MB
SELECT * from toolvenuepagelink WHERE venueid = 480
SELECT * from toolcitypagelink WHERE cityname = 'Fargo'
Weird Al Yankovic
Fargo Theatre Fargo Fargo, ND
Jun 6, 8:00 pm 2018
Wednesday
Jun 6
8:00 pm
Weird Al Yankovic
Fargo Theatre, Fargo, ND
SELECT * from toolvenuepagelink WHERE venueid = 3215
SELECT * from toolcitypagelink WHERE cityname = 'Columbia'
Weird Al Yankovic
Jesse Auditorium Columbia Columbia, MO
Jun 8, 8:00 pm 2018
Friday
Jun 8
8:00 pm
Weird Al Yankovic
Jesse Auditorium, Columbia, MO
SELECT * from toolvenuepagelink WHERE venueid = 6456
SELECT * from toolcitypagelink WHERE cityname = 'Clear Lake'
Weird Al Yankovic
Surf Ballroom Clear Lake Clear Lake, IA
Jun 9, 7:00 pm 2018
Saturday
Jun 9
7:00 pm
Weird Al Yankovic
Surf Ballroom, Clear Lake, IA
SELECT * from toolvenuepagelink WHERE venueid = 3793
SELECT * from toolcitypagelink WHERE cityname = 'Green Bay'
Weird Al Yankovic
Meyer Theatre Green Bay Green Bay, WI
Jun 10, 7:30 pm 2018
Sunday
Jun 10
7:30 pm
Weird Al Yankovic
Meyer Theatre, Green Bay, WI
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football