LISTE POUR : Royal Trux

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

February

Royal Trux
Union Transfer Philadelphia Philadelphia, PA
Feb 13, 8:30 pm 2019
Wednesday
Feb 13
8:30 pm
Royal Trux
Union Transfer, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 4954
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Royal Trux
Terminal 5 New York New York, NY
Feb 15, 8:00 pm 2019
Friday
Feb 15
8:00 pm
Royal Trux
Terminal 5, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 31549
SELECT * from toolcitypagelink WHERE cityname = 'Cambridge'
Royal Trux
The Sinclair Cambridge Cambridge, MA
Feb 16, 8:00 pm 2019
Saturday
Feb 16
8:00 pm
Royal Trux
The Sinclair, Cambridge, MA
SELECT * from toolvenuepagelink WHERE venueid = 2882
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Royal Trux
Lees Palace Toronto Toronto, ON
Feb 19, 7:00 pm 2019
Tuesday
Feb 19
7:00 pm
Royal Trux
Lees Palace, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 33149
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
Royal Trux
El Club Detroit Detroit, MI
Feb 20, 8:00 pm 2019
Wednesday
Feb 20
8:00 pm
Royal Trux
El Club, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 1419
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Royal Trux
The Showbox Seattle Seattle, WA
Feb 27, 8:00 pm 2019
Wednesday
Feb 27
8:00 pm
Royal Trux
The Showbox, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 32375
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'

March

Royal Trux
Teragram Ballroom Los Angeles Los Angeles, CA
Mar 8, 9:00 pm 2019
Friday
Mar 8
9:00 pm
Royal Trux
Teragram Ballroom, Los Angeles, 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