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

October

Soja
The Ritz Raleigh Raleigh, NC
Oct 17, 8:00 pm 2018
Wednesday
Oct 17
8:00 pm
Soja
The Ritz, Raleigh, NC
SELECT * from toolvenuepagelink WHERE venueid = 6693
SELECT * from toolcitypagelink WHERE cityname = 'Charlotte'
Soja
The Underground - Fillmore Charlotte Charlotte Charlotte, NC
Oct 19, 8:00 pm 2018
Friday
Oct 19
8:00 pm
Soja
The Underground - Fillmore Charlotte, Charlotte, NC
SELECT * from toolvenuepagelink WHERE venueid = 16281
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
Soja
Marathon Music Works Nashville Nashville, TN
Oct 20, 8:00 pm 2018
Saturday
Oct 20
8:00 pm
Soja
Marathon Music Works, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 1862
SELECT * from toolcitypagelink WHERE cityname = 'St Louis'
Soja
Delmar Hall St Louis St Louis, MO
Oct 21, 8:00 pm 2018
Sunday
Oct 21
8:00 pm
Soja
Delmar Hall, St Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 680
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Soja
House of Blues - Chicago Chicago Chicago, IL
Oct 23, 9:00 pm 2018
Tuesday
Oct 23
9:00 pm
Soja
House of Blues - Chicago, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 4092
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
Soja
Varsity Theater - Minneapolis, MN Minneapolis Minneapolis, MN
Oct 24, 8:00 pm 2018
Wednesday
Oct 24
8:00 pm
Soja
Varsity Theater - Minneapolis, MN, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 4913
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Soja
The Crossroads Kansas City Kansas City, MO
Oct 26, 8:00 pm 2018
Friday
Oct 26
8:00 pm
Soja
The Crossroads, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 4221
SELECT * from toolcitypagelink WHERE cityname = 'Broomfield'
Soja
1stBank Center Broomfield Broomfield, CO
Oct 27, 6:00 pm 2018
Saturday
Oct 27
6:00 pm
Soja
1stBank Center, Broomfield, CO
SELECT * from toolvenuepagelink WHERE venueid = 2607
SELECT * from toolcitypagelink WHERE cityname = 'Boise'
Soja
Knitting Factory Concert House - Boise Boise Boise, ID
Oct 30, 8:00 pm 2018
Tuesday
Oct 30
8:00 pm
Soja
Knitting Factory Concert House - Boise, Boise, ID
SELECT * from toolvenuepagelink WHERE venueid = 6919
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'

November

Soja
Venue-BC Vancouver Vancouver, BC
Nov 1, 8:00 pm 2018
Thursday
Nov 1
8:00 pm
Soja
Venue-BC, Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 5085
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Soja
Showbox SoDo Seattle Seattle, WA
Nov 2, 6:00 pm 2018
Friday
Nov 2
6:00 pm
Soja
Showbox SoDo, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 2883
SELECT * from toolcitypagelink WHERE cityname = 'Eugene'
Soja
McDonald Theatre Eugene Eugene, OR
Nov 3, 8:00 pm 2018
Saturday
Nov 3
8:00 pm
Soja
McDonald Theatre, Eugene, OR
SELECT * from toolvenuepagelink WHERE venueid = 2395
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Soja
McMenamins Crystal Ballroom Portland Portland, OR
Nov 4, 8:00 pm 2018
Sunday
Nov 4
8:00 pm
Soja
McMenamins Crystal Ballroom, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 4568
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Soja
House of Blues - Dallas Dallas Dallas, TX
Nov 5, 8:00 pm 2018
Monday
Nov 5
8:00 pm
Soja
House of Blues - Dallas, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 6169
SELECT * from toolcitypagelink WHERE cityname = 'Oakland'
Soja
Fox Theater - Oakland Oakland Oakland, CA
Nov 8, 7:00 pm 2018
Thursday
Nov 8
7:00 pm
Soja
Fox Theater - Oakland, Oakland, CA
SELECT * from toolvenuepagelink WHERE venueid = 5835
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Soja
The Novo by Microsoft Los Angeles Los Angeles, CA
Nov 9, 8:00 pm 2018
Friday
Nov 9
8:00 pm
Soja
The Novo by Microsoft, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 546
SELECT * from toolcitypagelink WHERE cityname = 'Santa Ana'
Soja
The Observatory Santa Ana Santa Ana, CA
Nov 10, 8:00 pm 2018
Saturday
Nov 10
8:00 pm
Soja
The Observatory, Santa Ana, CA
SELECT * from toolvenuepagelink WHERE venueid = 28217
SELECT * from toolcitypagelink WHERE cityname = 'San Diego'
Soja
The Observatory North Park San Diego San Diego, CA
Nov 11, 8:00 pm 2018
Sunday
Nov 11
8:00 pm
Soja
The Observatory North Park, San Diego, CA
SELECT * from toolvenuepagelink WHERE venueid = 33533
SELECT * from toolcitypagelink WHERE cityname = 'Phoenix'
Soja
The Van Buren Phoenix Phoenix, AZ
Nov 13, 8:00 pm 2018
Tuesday
Nov 13
8:00 pm
Soja
The Van Buren, Phoenix, AZ
SELECT * from toolvenuepagelink WHERE venueid = 4568
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Soja
House of Blues - Dallas Dallas Dallas, TX
Nov 15, 7:00 pm 2018
Thursday
Nov 15
7:00 pm
Soja
House of Blues - Dallas, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 3762
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
Soja
Warehouse Live Houston Houston, TX
Nov 16, 7:30 pm 2018
Friday
Nov 16
7:30 pm
Soja
Warehouse Live, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 8118
SELECT * from toolcitypagelink WHERE cityname = 'Austin'
Soja
Stubbs BBQ Austin Austin, TX
Nov 17, 7:00 pm 2018
Saturday
Nov 17
7:00 pm
Soja
Stubbs BBQ, Austin, TX
SELECT * from toolvenuepagelink WHERE venueid = 1936
SELECT * from toolcitypagelink WHERE cityname = 'New Orleans'
Soja
House of Blues - New Orleans New Orleans New Orleans, LA
Nov 18, 7:00 pm 2018
Sunday
Nov 18
7:00 pm
Soja
House of Blues - New Orleans, New Orleans, LA
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