LISTE POUR : Parcels

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

February

Parcels
Irving Plaza New York New York, NY
Feb 22, 7:00 pm 2019
Friday
Feb 22
7:00 pm
Parcels
Irving Plaza, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 31549
SELECT * from toolcitypagelink WHERE cityname = 'Cambridge'
Parcels
The Sinclair Cambridge Cambridge, MA
Feb 23, 9:00 pm 2019
Saturday
Feb 23
9:00 pm
Parcels
The Sinclair, Cambridge, MA
SELECT * from toolvenuepagelink WHERE venueid = 2882
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Parcels
Lees Palace Toronto Toronto, ON
Feb 26, 8:00 pm 2019
Tuesday
Feb 26
8:00 pm
Parcels
Lees Palace, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 33149
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
Parcels
El Club Detroit Detroit, MI
Feb 28, 9:00 pm 2019
Thursday
Feb 28
9:00 pm
Parcels
El Club, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 4085
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'

March

Parcels
7th Street Entry Minneapolis Minneapolis, MN
Mar 2, 8:00 pm 2019
Saturday
Mar 2
8:00 pm
Parcels
7th Street Entry, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 5108
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Parcels
Doug Fir Lounge Portland Portland, OR
Mar 7, 9:00 pm 2019
Thursday
Mar 7
9:00 pm
Parcels
Doug Fir Lounge, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 1600
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'

April

Parcels
Trees Dallas Dallas, TX
Apr 9, 8:00 pm 2019
Tuesday
Apr 9
8:00 pm
Parcels
Trees, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 3226
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Parcels
Regency Ballroom - Social Hall San Francisco San Francisco, CA
Apr 16, 8:30 pm 2019
Tuesday
Apr 16
8:30 pm
Parcels
Regency Ballroom - Social Hall, San Francisco, 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