LISTE POUR : X Ambassadors

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

February

X Ambassadors
The Fillmore San Francisco San Francisco, CA
Feb 26, 8:00 pm 2018
Monday
Feb 26
8:00 pm
X Ambassadors
The Fillmore, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 31828
SELECT * from toolcitypagelink WHERE cityname = 'Raleigh'

April

X Ambassadors
The Ritz Theatre - NC Raleigh Raleigh, NC
Apr 13, 8:00 pm 2018
Friday
Apr 13
8:00 pm
X Ambassadors
The Ritz Theatre - NC, Raleigh, NC
SELECT * from toolvenuepagelink WHERE venueid = 1366
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
X Ambassadors
Ryman Auditorium Nashville Nashville, TN
Apr 15, 7:30 pm 2018
Sunday
Apr 15
7:30 pm
X Ambassadors
Ryman Auditorium, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 7725
SELECT * from toolcitypagelink WHERE cityname = 'Pittsburgh'
X Ambassadors
Stage AE Pittsburgh Pittsburgh, PA
Apr 21, 6:30 pm 2018
Saturday
Apr 21
6:30 pm
X Ambassadors
Stage AE, Pittsburgh, PA
SELECT * from toolvenuepagelink WHERE venueid = 1857
SELECT * from toolcitypagelink WHERE cityname = 'Cincinnati'
X Ambassadors
Bogarts Cincinnati Cincinnati, OH
Apr 22, 8:00 pm 2018
Sunday
Apr 22
8:00 pm
X Ambassadors
Bogarts, Cincinnati, OH
SELECT * from toolvenuepagelink WHERE venueid = 2056
SELECT * from toolcitypagelink WHERE cityname = 'Columbus'
X Ambassadors
Express Live (Formerly Lifestyle Communities Pavilion) Columbus Columbus, OH
Apr 24, 6:30 pm 2018
Tuesday
Apr 24
6:30 pm
X Ambassadors
Express Live (Formerly Lifestyle Communities Pavilion), Columbus, OH
SELECT * from toolvenuepagelink WHERE venueid = 33426
SELECT * from toolcitypagelink WHERE cityname = 'Grand Rapids'
X Ambassadors
20 Monroe Live Grand Rapids Grand Rapids, MI
Apr 25, 6:30 pm 2018
Wednesday
Apr 25
6:30 pm
X Ambassadors
20 Monroe Live, Grand Rapids, MI
SELECT * from toolvenuepagelink WHERE venueid = 56
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
X Ambassadors
Aragon Ballroom Chicago Chicago, IL
Apr 27, 7:30 pm 2018
Friday
Apr 27
7:30 pm
X Ambassadors
Aragon Ballroom, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 1490
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
X Ambassadors
The Fillmore Detroit Detroit Detroit, MI
Apr 28, 7:00 pm 2018
Saturday
Apr 28
7:00 pm
X Ambassadors
The Fillmore Detroit, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 33343
SELECT * from toolcitypagelink WHERE cityname = 'Milwaukee'
X Ambassadors
The Rave/Eagles Club Milwaukee Milwaukee, WI
Apr 29, 7:30 pm 2018
Sunday
Apr 29
7:30 pm
X Ambassadors
The Rave/Eagles Club, Milwaukee, WI
SELECT * from toolvenuepagelink WHERE venueid = 3734
SELECT * from toolcitypagelink WHERE cityname = 'St Paul'

May

X Ambassadors
Myth St Paul St Paul, MN
May 1, 7:30 pm 2018
Tuesday
May 1
7:30 pm
X Ambassadors
Myth, St Paul, MN
SELECT * from toolvenuepagelink WHERE venueid = 1290
SELECT * from toolcitypagelink WHERE cityname = 'Morrison'
X Ambassadors
Red Rocks Amphitheatre Morrison Morrison, CO
May 3, 7:30 pm 2018
Thursday
May 3
7:30 pm
X Ambassadors
Red Rocks Amphitheatre, Morrison, CO
SELECT * from toolvenuepagelink WHERE venueid = 3946
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
X Ambassadors
The Depot Salt Lake City Salt Lake City, UT
May 4, 7:30 pm 2018
Friday
May 4
7:30 pm
X Ambassadors
The Depot, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 5085
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
X Ambassadors
Showbox SoDo Seattle Seattle, WA
May 6, 7:30 pm 2018
Sunday
May 6
7:30 pm
X Ambassadors
Showbox SoDo, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 2135
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
X Ambassadors
Roseland Theater Portland Portland, OR
May 7, 7:30 pm 2018
Monday
May 7
7:30 pm
X Ambassadors
Roseland Theater, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 1157
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
X Ambassadors
Orpheum Theatre - Vancouver Vancouver Vancouver, BC
May 8, 7:30 pm 2018
Tuesday
May 8
7:30 pm
X Ambassadors
Orpheum Theatre - Vancouver, Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 2074
SELECT * from toolcitypagelink WHERE cityname = 'Anaheim'
X Ambassadors
House of Blues - Anaheim Anaheim Anaheim, CA
May 11, 6:30 pm 2018
Friday
May 11
6:30 pm
X Ambassadors
House of Blues - Anaheim, Anaheim, CA
SELECT * from toolvenuepagelink WHERE venueid = 1677
SELECT * from toolcitypagelink WHERE cityname = 'Ventura'
X Ambassadors
Majestic Ventura Theater Ventura Ventura, CA
May 12, 7:30 pm 2018
Saturday
May 12
7:30 pm
X Ambassadors
Majestic Ventura Theater, Ventura, CA
SELECT * from toolvenuepagelink WHERE venueid = 682
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'
X Ambassadors
House of Blues - Las Vegas Las Vegas Las Vegas, NV
May 13, 7:30 pm 2018
Sunday
May 13
7:30 pm
X Ambassadors
House of Blues - Las Vegas, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 33533
SELECT * from toolcitypagelink WHERE cityname = 'Phoenix'
X Ambassadors
The Van Buren Phoenix Phoenix, AZ
May 15, 7:30 pm 2018
Tuesday
May 15
7:30 pm
X Ambassadors
The Van Buren, Phoenix, AZ
SELECT * from toolvenuepagelink WHERE venueid = 4568
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
X Ambassadors
House of Blues - Dallas Dallas Dallas, TX
May 17, 7:30 pm 2018
Thursday
May 17
7:30 pm
X Ambassadors
House of Blues - Dallas, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 5679
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
X Ambassadors
House of Blues - Houston Houston Houston, TX
May 18, 7:30 pm 2018
Friday
May 18
7:30 pm
X Ambassadors
House of Blues - Houston, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 8118
SELECT * from toolcitypagelink WHERE cityname = 'Austin'
X Ambassadors
Stubbs BBQ Austin Austin, TX
May 19, 6:00 pm 2018
Saturday
May 19
6:00 pm
X Ambassadors
Stubbs BBQ, Austin, TX
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football