LISTE POUR : Blue Rodeo

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

February

Blue Rodeo
Casino New Brunswick Moncton Moncton, NB
Feb 7, 8:00 pm 2019
Thursday
Feb 7
8:00 pm
Blue Rodeo
Casino New Brunswick, Moncton, NB
SELECT * from toolvenuepagelink WHERE venueid = 5684
SELECT * from toolcitypagelink WHERE cityname = 'Summerside'
Blue Rodeo
Credit Union Place Summerside Summerside, PE
Feb 8, 8:00 pm 2019
Friday
Feb 8
8:00 pm
Blue Rodeo
Credit Union Place, Summerside, PE
SELECT * from toolvenuepagelink WHERE venueid = 3061
SELECT * from toolcitypagelink WHERE cityname = 'Halifax'
Blue Rodeo
Halifax Metro Centre Halifax Halifax, NS
Feb 9, 8:00 pm 2019
Saturday
Feb 9
8:00 pm
Blue Rodeo
Halifax Metro Centre, Halifax, NS
SELECT * from toolvenuepagelink WHERE venueid = 3736
SELECT * from toolcitypagelink WHERE cityname = 'St John's'
Blue Rodeo
Mile One Centre St John's St John's, NL
Feb 16, 8:00 pm 2019
Saturday
Feb 16
8:00 pm
Blue Rodeo
Mile One Centre, St John's, NL
SELECT * from toolvenuepagelink WHERE venueid = 1084
SELECT * from toolcitypagelink WHERE cityname = 'Ottawa'
Blue Rodeo
National Arts Centre Ottawa Ottawa, ON
Feb 24, 8:00 pm 2019
Sunday
Feb 24
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 1035
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'

August

Blue Rodeo with Sam Roberts Band and The Devin Cuddy Band
Budweiser Stage Toronto Toronto, ON
Aug 24, 7:00 pm 2019
Saturday
Aug 24
7:00 pm
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football