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 = 33548
SELECT * from toolcitypagelink WHERE cityname = 'Washington'

December

SOJA
The Anthem Washington Washington, DC
Dec 29, 8:00 pm 2017
Friday
Dec 29
8:00 pm
SOJA
The Anthem, Washington, DC
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 = 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
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football
NOUVELLES - SPORT