LISTE POUR : The Slackers

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

April

The Slackers
The Masquerade Atlanta Atlanta, GA
Apr 5, 7:00 pm 2019
Friday
Apr 5
7:00 pm
The Slackers
The Masquerade, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 4332
SELECT * from toolcitypagelink WHERE cityname = 'Buffalo'
The Slackers
Mohawk Place Buffalo Buffalo, NY
Apr 25, 9:00 pm 2019
Thursday
Apr 25
9:00 pm
The Slackers
Mohawk Place, Buffalo, NY
SELECT * from toolvenuepagelink WHERE venueid = 2882
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
The Slackers
Lees Palace Toronto Toronto, ON
Apr 27, 8:30 pm 2019
Saturday
Apr 27
8:30 pm
The Slackers
Lees Palace, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 153
SELECT * from toolcitypagelink WHERE cityname = 'Ann Arbor Charter Township'

May

The Slackers
Blind Pig Ann Arbor Charter Township Ann Arbor Charter Township, MI
May 2, 9:00 pm 2019
Thursday
May 2
9:00 pm
The Slackers
Blind Pig, Ann Arbor Charter Township, MI
SELECT * from toolvenuepagelink WHERE venueid = 26929
SELECT * from toolcitypagelink WHERE cityname = 'Pittsburgh'
The Slackers
Smiling Moose Pittsburgh Pittsburgh, PA
May 4, 8:00 pm 2019
Saturday
May 4
8:00 pm
The Slackers
Smiling Moose, Pittsburgh, PA
SELECT * from toolvenuepagelink WHERE venueid = 4715
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
The Slackers with Ruder Than You
World Cafe Live Philadelphia Philadelphia, PA
May 5, 8:00 pm 2019
Sunday
May 5
8:00 pm
The Slackers with Ruder Than You
World Cafe Live, Philadelphia, PA
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football