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 = 33347
SELECT * from toolcitypagelink WHERE cityname = 'St. Louis'

December

X Ambassadors
The Pageant St. Louis St. Louis, MO
Dec 13, 8:00 pm 2017
Wednesday
Dec 13
8:00 pm
X Ambassadors
The Pageant, St. Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 1005
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
X Ambassadors
Arvest Bank Theatre at The Midland Kansas City Kansas City, MO
Dec 14, 7:30 pm 2017
Thursday
Dec 14
7:30 pm
X Ambassadors
Arvest Bank Theatre at The Midland, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 18123
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'

February

X Ambassadors
Corona Theatre Montreal Montreal, QC
Feb 13, 8:00 pm 2018
Tuesday
Feb 13
8:00 pm
X Ambassadors
Corona Theatre, Montreal, QC
SELECT * from toolvenuepagelink WHERE venueid = 32474
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
X Ambassadors
The Fillmore Philadelphia Philadelphia Philadelphia, PA
Feb 15, 8:00 pm 2018
Thursday
Feb 15
8:00 pm
X Ambassadors
The Fillmore Philadelphia, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 33405
SELECT * from toolcitypagelink WHERE cityname = 'Brooklyn'
X Ambassadors
Brooklyn Steel Brooklyn Brooklyn, NY
Feb 16, 7:00 pm 2018
Friday
Feb 16
7:00 pm
X Ambassadors
Brooklyn Steel, Brooklyn, NY
SELECT * from toolvenuepagelink WHERE venueid = 6064
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
X Ambassadors
House of Blues - Boston Boston Boston, MA
Feb 18, 7:00 pm 2018
Sunday
Feb 18
7:00 pm
X Ambassadors
House of Blues - Boston, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 1959
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
X Ambassadors
9:30 Club Washington Washington, DC
Feb 19, 7:00 pm 2018
Monday
Feb 19
7:00 pm
X Ambassadors
9:30 Club, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 30318
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
X Ambassadors
Belasco Theatre - LA Los Angeles Los Angeles, CA
Feb 22, 8:00 pm 2018
Thursday
Feb 22
8:00 pm
X Ambassadors
Belasco Theatre - LA, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 1445
SELECT * from toolcitypagelink WHERE cityname = 'San Diego'
X Ambassadors
Soma San Diego San Diego, CA
Feb 23, 7:30 pm 2018
Friday
Feb 23
7:30 pm
X Ambassadors
Soma, San Diego, CA
SELECT * from toolvenuepagelink WHERE venueid = 492
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
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 = 1290
SELECT * from toolcitypagelink WHERE cityname = 'Morrison'

May

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
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