LISTE POUR : Marianas Trench

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

March

Marianas Trench
Bell MTS Place Winnipeg Winnipeg, MB
Mar 22, 7:00 pm 2019
Friday
Mar 22
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 4431
SELECT * from toolcitypagelink WHERE cityname = 'Regina'
Marianas Trench
Conexus Arts Centre Regina Regina, SK
Mar 23, 8:00 pm 2019
Saturday
Mar 23
8:00 pm
Marianas Trench
Conexus Arts Centre, Regina, SK
SELECT * from toolvenuepagelink WHERE venueid = 2661
SELECT * from toolcitypagelink WHERE cityname = 'Calgary'
Marianas Trench
Southern Alberta Jubilee Auditorium Calgary Calgary, AB
Mar 25, 8:00 pm 2019
Monday
Mar 25
8:00 pm
Marianas Trench
Southern Alberta Jubilee Auditorium, Calgary, AB
SELECT * from toolvenuepagelink WHERE venueid = 433
SELECT * from toolcitypagelink WHERE cityname = 'Edmonton'
Marianas Trench
Northern Alberta Jubilee Auditorium Edmonton Edmonton, AB
Mar 26, 8:00 pm 2019
Tuesday
Mar 26
8:00 pm
Marianas Trench
Northern Alberta Jubilee Auditorium, Edmonton, AB
SELECT * from toolvenuepagelink WHERE venueid = 1157
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Marianas Trench
Orpheum Theatre - Vancouver Vancouver Vancouver, BC
Mar 29, 8:00 pm 2019
Friday
Mar 29
8:00 pm
Marianas Trench
Orpheum Theatre - Vancouver, Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 856
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'

May

Marianas Trench
Theatre of Living Arts Philadelphia Philadelphia, PA
May 1, 8:00 pm 2019
Wednesday
May 1
8:00 pm
Marianas Trench
Theatre of Living Arts, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 725
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Marianas Trench
Irving Plaza New York New York, NY
May 3, 7:00 pm 2019
Friday
May 3
7:00 pm
Marianas Trench
Irving Plaza, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 6064
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Marianas Trench
House of Blues - Boston Boston Boston, MA
May 4, 8:00 pm 2019
Saturday
May 4
8:00 pm
Marianas Trench
House of Blues - Boston, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 7900
SELECT * from toolcitypagelink WHERE cityname = 'Silver Spring'
Marianas Trench
The Fillmore Silver Spring Silver Spring Silver Spring, MD
May 5, 8:00 pm 2019
Sunday
May 5
8:00 pm
Marianas Trench
The Fillmore Silver Spring, Silver Spring, MD
SELECT * from toolvenuepagelink WHERE venueid = 27741
SELECT * from toolcitypagelink WHERE cityname = 'Mesa'
Marianas Trench
The Underground Mesa Mesa, AZ
May 7, 8:00 pm 2019
Tuesday
May 7
8:00 pm
Marianas Trench
The Underground, Mesa, AZ
SELECT * from toolvenuepagelink WHERE venueid = 7465
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Marianas Trench
Buckhead Theatre Atlanta Atlanta, GA
May 8, 8:00 pm 2019
Wednesday
May 8
8:00 pm
Marianas Trench
Buckhead Theatre, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 33672
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
Marianas Trench
The Cowan Nashville Nashville, TN
May 8, 8:00 pm 2019
Wednesday
May 8
8:00 pm
Marianas Trench
The Cowan, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 3462
SELECT * from toolcitypagelink WHERE cityname = 'Charleston'
Marianas Trench
Music Farm Charleston Charleston, SC
May 10, 8:00 pm 2019
Friday
May 10
8:00 pm
Marianas Trench
Music Farm, Charleston, SC
SELECT * from toolvenuepagelink WHERE venueid = 681
SELECT * from toolcitypagelink WHERE cityname = 'Orlando'
Marianas Trench
House of Blues - Orlando Orlando Orlando, FL
May 11, 8:00 pm 2019
Saturday
May 11
8:00 pm
Marianas Trench
House of Blues - Orlando, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 3052
SELECT * from toolcitypagelink WHERE cityname = 'Millvale'
Marianas Trench
Mr Smalls Theater Millvale Millvale, PA
May 14, 8:00 pm 2019
Tuesday
May 14
8:00 pm
Marianas Trench
Mr Smalls Theater, Millvale, PA
SELECT * from toolvenuepagelink WHERE venueid = 1110
SELECT * from toolcitypagelink WHERE cityname = 'Columbus'
Marianas Trench
Newport Music Hall Columbus Columbus, OH
May 15, 7:00 pm 2019
Wednesday
May 15
7:00 pm
Marianas Trench
Newport Music Hall, Columbus, OH
SELECT * from toolvenuepagelink WHERE venueid = 3266
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
Marianas Trench
House of Blues - Cleveland Cleveland Cleveland, OH
May 19, 8:00 pm 2019
Sunday
May 19
8:00 pm
Marianas Trench
House of Blues - Cleveland, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 720
SELECT * from toolcitypagelink WHERE cityname = 'Grand Rapids'
Marianas Trench
Intersection Grand Rapids Grand Rapids, MI
May 21, 7:00 pm 2019
Tuesday
May 21
7:00 pm
Marianas Trench
Intersection, Grand Rapids, MI
SELECT * from toolvenuepagelink WHERE venueid = 1927
SELECT * from toolcitypagelink WHERE cityname = 'Indianapolis'
Marianas Trench
Egyptian Room at Old National Centre Indianapolis Indianapolis, IN
May 22, 8:00 pm 2019
Wednesday
May 22
8:00 pm
Marianas Trench
Egyptian Room at Old National Centre, Indianapolis, IN
SELECT * from toolvenuepagelink WHERE venueid = 3266
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
Marianas Trench
House of Blues - Cleveland Cleveland Cleveland, OH
May 24, 7:00 pm 2019
Friday
May 24
7:00 pm
Marianas Trench
House of Blues - Cleveland, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 680
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Marianas Trench
House of Blues - Chicago Chicago Chicago, IL
May 24, 8:00 pm 2019
Friday
May 24
8:00 pm
Marianas Trench
House of Blues - Chicago, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 4092
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
Marianas Trench
Varsity Theater - Minneapolis, MN Minneapolis Minneapolis, MN
May 25, 7:00 pm 2019
Saturday
May 25
7:00 pm
Marianas Trench
Varsity Theater - Minneapolis, MN, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 4862
SELECT * from toolcitypagelink WHERE cityname = 'Omaha'
Marianas Trench
Slowdown Omaha Omaha, NE
May 26, 8:00 pm 2019
Sunday
May 26
8:00 pm
Marianas Trench
Slowdown, Omaha, NE
SELECT * from toolvenuepagelink WHERE venueid = 7810
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Marianas Trench
Summit Music Hall Denver Denver, CO
May 28, 7:00 pm 2019
Tuesday
May 28
7:00 pm
Marianas Trench
Summit Music Hall, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 3946
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
Marianas Trench
The Depot Salt Lake City Salt Lake City, UT
May 29, 8:00 pm 2019
Wednesday
May 29
8:00 pm
Marianas Trench
The Depot, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 4059
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Marianas Trench
Wonder Ballroom Portland Portland, OR
May 31, 8:00 pm 2019
Friday
May 31
8:00 pm
Marianas Trench
Wonder Ballroom, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 4459
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'

June

Marianas Trench
El Corazon Seattle Seattle, WA
Jun 1, 8:00 pm 2019
Saturday
Jun 1
8:00 pm
Marianas Trench
El Corazon, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 492
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Marianas Trench
The Fillmore - San Francisco San Francisco San Francisco, CA
Jun 3, 8:00 pm 2019
Monday
Jun 3
8:00 pm
Marianas Trench
The Fillmore - San Francisco, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 2074
SELECT * from toolcitypagelink WHERE cityname = 'Anaheim'
Marianas Trench
House of Blues - Anaheim Anaheim Anaheim, CA
Jun 5, 7:00 pm 2019
Wednesday
Jun 5
7:00 pm
Marianas Trench
House of Blues - Anaheim, Anaheim, CA
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football