LISTE POUR : Riot V

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

June

Riot V
The Garrison Toronto Toronto, ON
Jun 22, 7:00 pm 2019
Saturday
Jun 22
7:00 pm
Riot V
The Garrison, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 4459
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'

July

Riot V
El Corazon Seattle Seattle, WA
Jul 5, 8:00 pm 2019
Friday
Jul 5
8:00 pm
Riot V
El Corazon, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 180
SELECT * from toolcitypagelink WHERE cityname = 'San Diego'
Riot V with Nukem
Brick By Brick San Diego San Diego, CA
Jul 13, 8:30 pm 2019
Saturday
Jul 13
8:30 pm
Riot V with Nukem
Brick By Brick, San Diego, CA
SELECT * from toolvenuepagelink WHERE venueid = 33148
SELECT * from toolcitypagelink WHERE cityname = 'San Antonio'
Riot V
The Rock Box San Antonio San Antonio, TX
Jul 17, 8:00 pm 2019
Wednesday
Jul 17
8:00 pm
Riot V
The Rock Box, San Antonio, TX
SELECT * from toolvenuepagelink WHERE venueid = 28122
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Riot V
Crowbar Tampa Tampa, FL
Jul 19, 7:00 pm 2019
Friday
Jul 19
7:00 pm
Riot V
Crowbar, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 33295
SELECT * from toolcitypagelink WHERE cityname = 'Pompano Beach'
Riot V
O'Malley's Sports Bar Pompano Beach Pompano Beach, FL
Jul 20, 7:00 pm 2019
Saturday
Jul 20
7:00 pm
Riot V
O'Malley's Sports Bar, Pompano Beach, FL
SELECT * from toolvenuepagelink WHERE venueid = 32124
SELECT * from toolcitypagelink WHERE cityname = 'Durham'
Riot V
Motorco Music Hall Durham Durham, NC
Jul 25, 6:30 pm 2019
Thursday
Jul 25
6:30 pm
Riot V
Motorco Music Hall, Durham, NC
SELECT * from toolvenuepagelink WHERE venueid = 33013
SELECT * from toolcitypagelink WHERE cityname = 'Clifton'
Riot V
Dingbatz Clifton Clifton, NJ
Jul 26, 6:00 pm 2019
Friday
Jul 26
6:00 pm
Riot V
Dingbatz, Clifton, NJ
SELECT * from toolvenuepagelink WHERE venueid = 257
SELECT * from toolcitypagelink WHERE cityname = 'Poughkeepsie'
Riot V
The Chance Poughkeepsie Poughkeepsie, NY
Jul 27, 7:00 pm 2019
Saturday
Jul 27
7:00 pm
Riot V
The Chance, Poughkeepsie, NY
SELECT * from toolvenuepagelink WHERE venueid = 32287
SELECT * from toolcitypagelink WHERE cityname = 'Manchester'
Riot V
Jewel Nightclub Manchester Manchester, NH
Jul 28, 7:00 pm 2019
Sunday
Jul 28
7:00 pm
Riot V
Jewel Nightclub, Manchester, NH
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football