LISTE POUR : Gryffin

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

June

Gryffin
Omnia Nightclub Las Vegas Las Vegas, NV
Jun 25, 8:00 pm 2019
Tuesday
Jun 25
8:00 pm
Gryffin
Omnia Nightclub, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 34190
SELECT * from toolcitypagelink WHERE cityname = 'Costa Mesa'

July

Gryffin
Time Nightclub Costa Mesa Costa Mesa, CA
Jul 3, 8:00 pm 2019
Wednesday
Jul 3
8:00 pm
Gryffin
Time Nightclub, Costa Mesa, CA
SELECT * from toolvenuepagelink WHERE venueid = 31689
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'
Gryffin
Hakkasan Las Vegas Nightclub Las Vegas Las Vegas, NV
Jul 12, 8:00 pm 2019
Friday
Jul 12
8:00 pm
Gryffin
Hakkasan Las Vegas Nightclub, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 31689
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'
Gryffin
Hakkasan Las Vegas Nightclub Las Vegas Las Vegas, NV
Jul 25, 8:00 pm 2019
Thursday
Jul 25
8:00 pm
Gryffin
Hakkasan Las Vegas Nightclub, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 32621
SELECT * from toolcitypagelink WHERE cityname = 'East Willamsburg'

August

Gryffin
Brooklyn Mirage East Willamsburg East Willamsburg, NY
Aug 16, 8:00 pm 2019
Friday
Aug 16
8:00 pm
Gryffin
Brooklyn Mirage, East Willamsburg, 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