LISTE POUR : The Anvil Experience

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

March

Anvil
1904 Music Hall Jacksonville Jacksonville, FL
Mar 24, 7:00 pm 2019
Sunday
Mar 24
7:00 pm
Anvil
1904 Music Hall, Jacksonville, FL
SELECT * from toolvenuepagelink WHERE venueid = 33076
SELECT * from toolcitypagelink WHERE cityname = 'Wichita'
Anvil
Barleycorn's Wichita Wichita, KS
Mar 27, 7:00 pm 2019
Wednesday
Mar 27
7:00 pm
Anvil
Barleycorn's, Wichita, KS
SELECT * from toolvenuepagelink WHERE venueid = 180
SELECT * from toolcitypagelink WHERE cityname = 'San Diego'

April

Anvil
Brick By Brick San Diego San Diego, CA
Apr 4, 7:30 pm 2019
Thursday
Apr 4
7:30 pm
Anvil
Brick By Brick, San Diego, CA
SELECT * from toolvenuepagelink WHERE venueid = 1734
SELECT * from toolcitypagelink WHERE cityname = 'West Hollywood'
Anvil
Whisky A Go Go West Hollywood West Hollywood, CA
Apr 5, 7:00 pm 2019
Friday
Apr 5
7:00 pm
Anvil
Whisky A Go Go, West Hollywood, CA
SELECT * from toolvenuepagelink WHERE venueid = 32413
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Anvil
The Wayfarer New York New York, NY
Apr 6, 8:00 pm 2019
Saturday
Apr 6
8:00 pm
Anvil
The Wayfarer, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 31512
SELECT * from toolcitypagelink WHERE cityname = 'Tacoma'
Anvil
Jazzbones Tacoma Tacoma, WA
Apr 13, 7:00 pm 2019
Saturday
Apr 13
7:00 pm
Anvil
Jazzbones, Tacoma, WA
SELECT * from toolvenuepagelink WHERE venueid = 32083
SELECT * from toolcitypagelink WHERE cityname = 'Ardmore'
Anvil
The Ardmore Music Hall Ardmore Ardmore, PA
Apr 24, 7:30 pm 2019
Wednesday
Apr 24
7:30 pm
Anvil
The Ardmore Music Hall, Ardmore, PA
SELECT * from toolvenuepagelink WHERE venueid = 28196
SELECT * from toolcitypagelink WHERE cityname = 'Brooklyn'
Anvil
Saint Vitus Brooklyn Brooklyn, NY
Apr 25, 7:00 pm 2019
Thursday
Apr 25
7:00 pm
Anvil
Saint Vitus, Brooklyn, NY
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football