LISTE POUR : YG

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

January

YG (Moved from PNE Forum)
Harbour Event Centre Vancouver Vancouver, BC
Jan 17, 7:00 pm 2019
Thursday
Jan 17
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 4291
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
YG
WaMu Theater Seattle Seattle, WA
Jan 18, 8:00 pm 2019
Friday
Jan 18
8:00 pm
YG
WaMu Theater, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 2135
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
YG
Roseland Theater Portland Portland, OR
Jan 19, 8:00 pm 2019
Saturday
Jan 19
8:00 pm
YG
Roseland Theater, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 2135
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
YG
Roseland Theater Portland Portland, OR
Jan 20, 8:00 pm 2019
Sunday
Jan 20
8:00 pm
YG
Roseland Theater, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 29474
SELECT * from toolcitypagelink WHERE cityname = 'Garden City'
YG
Revolution Concert House and Event Center Garden City Garden City, ID
Jan 22, 8:00 pm 2019
Tuesday
Jan 22
8:00 pm
YG
Revolution Concert House and Event Center, Garden City, ID
SELECT * from toolvenuepagelink WHERE venueid = 33723
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
YG
The Union Event Center Salt Lake City Salt Lake City, UT
Jan 23, 8:00 pm 2019
Wednesday
Jan 23
8:00 pm
YG
The Union Event Center, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 1131
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
YG
Ogden Theatre Denver Denver, CO
Jan 30, 8:00 pm 2019
Wednesday
Jan 30
8:00 pm
YG
Ogden Theatre, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 1131
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
YG
Ogden Theatre Denver Denver, CO
Jan 31, 8:00 pm 2019
Thursday
Jan 31
8:00 pm
YG
Ogden Theatre, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 4954
SELECT * from toolcitypagelink WHERE cityname = 'New York'

February

YG
Terminal 5 New York New York, NY
Feb 13, 8:00 pm 2019
Wednesday
Feb 13
8:00 pm
YG
Terminal 5, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 18146
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
YG
Rebel Toronto Toronto, ON
Feb 19, 8:00 pm 2019
Tuesday
Feb 19
8:00 pm
YG
Rebel, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 28291
SELECT * from toolcitypagelink WHERE cityname = 'Worcester'
YG
The Palladium - MA Worcester Worcester, MA
Feb 22, 8:00 pm 2019
Friday
Feb 22
8:00 pm
YG
The Palladium - MA, Worcester, MA
SELECT * from toolvenuepagelink WHERE venueid = 443
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
YG
North Seventh (Formerly Electric Factory) Philadelphia Philadelphia, PA
Feb 23, 8:30 pm 2019
Saturday
Feb 23
8:30 pm
YG
North Seventh (Formerly Electric Factory), Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 1555
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
YG
The Tabernacle Atlanta Atlanta, GA
Feb 27, 8:00 pm 2019
Wednesday
Feb 27
8:00 pm
YG
The Tabernacle, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 3762
SELECT * from toolcitypagelink WHERE cityname = 'Houston'

March

YG
Warehouse Live Houston Houston, TX
Mar 1, 8:00 pm 2019
Friday
Mar 1
8:00 pm
YG
Warehouse Live, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 31816
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
YG
Bomb Factory Dallas Dallas, TX
Mar 3, 8:00 pm 2019
Sunday
Mar 3
8:00 pm
YG
Bomb Factory, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 2525
SELECT * from toolcitypagelink WHERE cityname = 'Oklahoma City'
YG
Diamond Ballroom Oklahoma City Oklahoma City, OK
Mar 4, 8:00 pm 2019
Monday
Mar 4
8:00 pm
YG
Diamond Ballroom, Oklahoma City, OK
SELECT * from toolvenuepagelink WHERE venueid = 2165
SELECT * from toolcitypagelink WHERE cityname = 'Mesa'
YG
Mesa Amphitheatre Mesa Mesa, AZ
Mar 6, 8:00 pm 2019
Wednesday
Mar 6
8:00 pm
YG
Mesa Amphitheatre, Mesa, AZ
SELECT * from toolvenuepagelink WHERE venueid = 8000
SELECT * from toolcitypagelink WHERE cityname = 'San Diego'
YG
Pechanga Arena San Diego San Diego, CA
Mar 7, 8:00 pm 2019
Thursday
Mar 7
8:00 pm
YG
Pechanga Arena, San Diego, CA
SELECT * from toolvenuepagelink WHERE venueid = 144
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
YG
Bill Graham Civic Auditorium San Francisco San Francisco, CA
Mar 9, 8:00 pm 2019
Saturday
Mar 9
8:00 pm
YG
Bill Graham Civic Auditorium, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 3326
SELECT * from toolcitypagelink WHERE cityname = 'Reno'
YG
Reno Events Center Reno Reno, NV
Mar 10, 8:00 pm 2019
Sunday
Mar 10
8:00 pm
YG
Reno Events Center, Reno, NV
SELECT * from toolvenuepagelink WHERE venueid = 2135
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
YG
Roseland Theater Portland Portland, OR
Mar 12, 8:00 pm 2019
Tuesday
Mar 12
8:00 pm
YG
Roseland Theater, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 144
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
YG
Bill Graham Civic Auditorium San Francisco San Francisco, CA
Mar 16, 8:00 pm 2019
Saturday
Mar 16
8:00 pm
YG
Bill Graham Civic Auditorium, 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