LISTE POUR : The Amity Affliction

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

January

The Amity Affliction
Rams Head Live Baltimore Baltimore, MD
Jan 18, 7:15 pm 2019
Friday
Jan 18
7:15 pm
The Amity Affliction
Rams Head Live, Baltimore, MD
SELECT * from toolvenuepagelink WHERE venueid = 443
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
The Amity Affliction
North Seventh (Formerly Electric Factory) Philadelphia Philadelphia, PA
Jan 20, 7:00 pm 2019
Sunday
Jan 20
7:00 pm
The Amity Affliction
North Seventh (Formerly Electric Factory), Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 3649
SELECT * from toolcitypagelink WHERE cityname = 'New York'
The Amity Affliction with Bad Omens
Playstation Theater New York New York, NY
Jan 22, 7:00 pm 2019
Tuesday
Jan 22
7:00 pm
The Amity Affliction with Bad Omens
Playstation Theater, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 905
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
The Amity Affliction
Majestic Theatre Detroit Detroit Detroit, MI
Jan 26, 6:30 pm 2019
Saturday
Jan 26
6:30 pm
The Amity Affliction
Majestic Theatre Detroit, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 3266
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
The Amity Affliction
House of Blues - Cleveland Cleveland Cleveland, OH
Jan 27, 6:00 pm 2019
Sunday
Jan 27
6:00 pm
The Amity Affliction
House of Blues - Cleveland, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 1862
SELECT * from toolcitypagelink WHERE cityname = 'St Louis'
The Amity Affliction
Delmar Hall St Louis St Louis, MO
Jan 29, 7:00 pm 2019
Tuesday
Jan 29
7:00 pm
The Amity Affliction
Delmar Hall, St Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 7810
SELECT * from toolcitypagelink WHERE cityname = 'Denver'

February

The Amity Affliction with Senses Fail
Summit Music Hall Denver Denver, CO
Feb 1, 6:30 pm 2019
Friday
Feb 1
6:30 pm
The Amity Affliction with Senses Fail
Summit Music Hall, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 9539
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
The Amity Affliction with Senses Fail
The Complex Salt Lake City Salt Lake City, UT
Feb 2, 6:30 pm 2019
Saturday
Feb 2
6:30 pm
The Amity Affliction with Senses Fail
The Complex, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 9556
SELECT * from toolcitypagelink WHERE cityname = 'Sacramento'
The Amity Affliction with Senses Fail
Ace of Spades Sacramento Sacramento, CA
Feb 7, 7:00 pm 2019
Thursday
Feb 7
7:00 pm
The Amity Affliction with Senses Fail
Ace of Spades, Sacramento, CA
SELECT * from toolvenuepagelink WHERE venueid = 2159
SELECT * from toolcitypagelink WHERE cityname = 'Santa Cruz'
The Amity Affliction with Senses Fail
The Catalyst - CA Santa Cruz Santa Cruz, CA
Feb 8, 7:15 pm 2019
Friday
Feb 8
7:15 pm
The Amity Affliction with Senses Fail
The Catalyst - CA, Santa Cruz, CA
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football