LISTE POUR : Soja

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

March

Soja
Capitol Theatre Port Chester Port Chester, NY
Mar 1, 8:00 pm 2018
Thursday
Mar 1
8:00 pm
Soja
Capitol Theatre, Port Chester, NY
SELECT * from toolvenuepagelink WHERE venueid = 2007
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Soja
State Theater (Portland - ME) Portland Portland, ME
Mar 2, 7:30 pm 2018
Friday
Mar 2
7:30 pm
Soja
State Theater (Portland - ME), Portland, ME
SELECT * from toolvenuepagelink WHERE venueid = 3919
SELECT * from toolcitypagelink WHERE cityname = 'South Burlington'
SOJA
Higher Ground South Burlington South Burlington, VT
Mar 4, 7:30 pm 2018
Sunday
Mar 4
7:30 pm
SOJA
Higher Ground, South Burlington, VT
SELECT * from toolvenuepagelink WHERE venueid = 32234
SELECT * from toolcitypagelink WHERE cityname = 'New Haven'
SOJA
College Street Music Hall New Haven New Haven, CT
Mar 6, 7:30 pm 2018
Tuesday
Mar 6
7:30 pm
SOJA
College Street Music Hall, New Haven, CT
SELECT * from toolvenuepagelink WHERE venueid = 18120
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
SOJA
L'Astral Montreal Montreal, QC
Mar 8, 8:00 pm 2018
Thursday
Mar 8
8:00 pm
SOJA
L'Astral, Montreal, QC
SELECT * from toolvenuepagelink WHERE venueid = 3142
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
SOJA
Mod Club Theatre Toronto Toronto, ON
Mar 9, 7:30 pm 2018
Friday
Mar 9
7:30 pm
SOJA
Mod Club Theatre, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 1371
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
Soja
St. Andrews Hall Detroit Detroit, MI
Mar 10, 7:00 pm 2018
Saturday
Mar 10
7:00 pm
Soja
St. Andrews Hall, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 3266
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
Soja
House of Blues - Cleveland Cleveland Cleveland, OH
Mar 11, 8:00 pm 2018
Sunday
Mar 11
8:00 pm
Soja
House of Blues - Cleveland, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 3462
SELECT * from toolcitypagelink WHERE cityname = 'Charleston'
SOJA
Music Farm Charleston Charleston, SC
Mar 14, 8:00 pm 2018
Wednesday
Mar 14
8:00 pm
SOJA
Music Farm, Charleston, SC
SELECT * from toolvenuepagelink WHERE venueid = 3462
SELECT * from toolcitypagelink WHERE cityname = 'Charleston'
SOJA
Music Farm Charleston Charleston, SC
Mar 15, 8:00 pm 2018
Thursday
Mar 15
8:00 pm
SOJA
Music Farm, Charleston, SC
SELECT * from toolvenuepagelink WHERE venueid = 4089
SELECT * from toolcitypagelink WHERE cityname = 'Asheville'
SOJA
The Orange Peel Asheville Asheville, NC
Mar 16, 8:00 pm 2018
Friday
Mar 16
8:00 pm
SOJA
The Orange Peel, Asheville, NC
SELECT * from toolvenuepagelink WHERE venueid = 25871
SELECT * from toolcitypagelink WHERE cityname = 'Wilmington'

April

SOJA
Greenfield Amphitheater Wilmington Wilmington, NC
Apr 20, 6:30 pm 2018
Friday
Apr 20
6:30 pm
SOJA
Greenfield Amphitheater, Wilmington, NC
SELECT * from toolvenuepagelink WHERE venueid = 30602
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'

May

Soja
Brooklyn Bowl Las Vegas at The LINQ Las Vegas Las Vegas, NV
May 19, 7:00 pm 2018
Saturday
May 19
7:00 pm
Soja
Brooklyn Bowl Las Vegas at The LINQ, Las Vegas, NV
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football