LISTE POUR : Snow Patrol

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

April

Snow Patrol
South Side Ballroom Dallas Dallas, TX
Apr 18, 8:00 pm 2019
Thursday
Apr 18
8:00 pm
Snow Patrol
South Side Ballroom, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 29082
SELECT * from toolcitypagelink WHERE cityname = 'Austin'
Snow Patrol
Austin City Limits Live at The Moody Theater Austin Austin, TX
Apr 20, 8:00 pm 2019
Saturday
Apr 20
8:00 pm
Snow Patrol
Austin City Limits Live at The Moody Theater, Austin, TX
SELECT * from toolvenuepagelink WHERE venueid = 2156
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
Snow Patrol
Revention Music Center Houston Houston, TX
Apr 21, 8:00 pm 2019
Sunday
Apr 21
8:00 pm
Snow Patrol
Revention Music Center, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 1366
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
Snow Patrol
Ryman Auditorium Nashville Nashville, TN
Apr 23, 7:30 pm 2019
Tuesday
Apr 23
7:30 pm
Snow Patrol
Ryman Auditorium, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 1555
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Snow Patrol
The Tabernacle Atlanta Atlanta, GA
Apr 24, 8:00 pm 2019
Wednesday
Apr 24
8:00 pm
Snow Patrol
The Tabernacle, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 33548
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Snow Patrol
The Anthem Washington Washington, DC
Apr 26, 8:00 pm 2019
Friday
Apr 26
8:00 pm
Snow Patrol
The Anthem, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 1590
SELECT * from toolcitypagelink WHERE cityname = 'Upper Darby'
Snow Patrol
Tower Theater - PA Upper Darby Upper Darby, PA
Apr 27, 8:00 pm 2019
Saturday
Apr 27
8:00 pm
Snow Patrol
Tower Theater - PA, Upper Darby, PA
SELECT * from toolvenuepagelink WHERE venueid = 1160
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Snow Patrol
Orpheum Theatre - Boston Boston Boston, MA
Apr 29, 7:30 pm 2019
Monday
Apr 29
7:30 pm
Snow Patrol
Orpheum Theatre - Boston, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 4954
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Snow Patrol
Terminal 5 New York New York, NY
Apr 30, 8:00 pm 2019
Tuesday
Apr 30
8:00 pm
Snow Patrol
Terminal 5, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 2992
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'

May

Snow Patrol
Danforth Music Hall Toronto Toronto, ON
May 3, 7:00 pm 2019
Friday
May 3
7:00 pm
Snow Patrol
Danforth Music Hall, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 1357
SELECT * from toolcitypagelink WHERE cityname = 'Royal Oak'
Snow Patrol
Royal Oak Music Theatre Royal Oak Royal Oak, MI
May 4, 7:00 pm 2019
Saturday
May 4
7:00 pm
Snow Patrol
Royal Oak Music Theatre, Royal Oak, MI
SELECT * from toolvenuepagelink WHERE venueid = 1324
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Snow Patrol
Riviera Theatre (Chicago) Chicago Chicago, IL
May 7, 8:00 pm 2019
Tuesday
May 7
8:00 pm
Snow Patrol
Riviera Theatre (Chicago), Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 496
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
Snow Patrol
First Avenue Minneapolis Minneapolis, MN
May 8, 8:00 pm 2019
Wednesday
May 8
8:00 pm
Snow Patrol
First Avenue, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 1193
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Snow Patrol
Paramount Theatre - CO Denver Denver, CO
May 10, 8:00 pm 2019
Friday
May 10
8:00 pm
Snow Patrol
Paramount Theatre - CO, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 3946
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
Snow Patrol
The Depot Salt Lake City Salt Lake City, UT
May 11, 8:00 pm 2019
Saturday
May 11
8:00 pm
Snow Patrol
The Depot, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 1272
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Snow Patrol
Queen Elizabeth Theatre - Vancouver Vancouver Vancouver, BC
May 13, 8:00 pm 2019
Monday
May 13
8:00 pm
Snow Patrol
Queen Elizabeth Theatre - Vancouver, Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 2135
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Snow Patrol
Roseland Theater Portland Portland, OR
May 14, 8:00 pm 2019
Tuesday
May 14
8:00 pm
Snow Patrol
Roseland Theater, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 5085
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Snow Patrol
Showbox SoDo Seattle Seattle, WA
May 15, 8:00 pm 2019
Wednesday
May 15
8:00 pm
Snow Patrol
Showbox SoDo, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 633
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'
Snow Patrol
The Joint at Hard Rock Hotel Las Vegas Las Vegas Las Vegas, NV
May 18, 8:00 pm 2019
Saturday
May 18
8:00 pm
Snow Patrol
The Joint at Hard Rock Hotel Las Vegas, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 1708
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Snow Patrol
The Warfield San Francisco San Francisco, CA
May 20, 8:00 pm 2019
Monday
May 20
8:00 pm
Snow Patrol
The Warfield, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 1752
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Snow Patrol
Wiltern Theatre Los Angeles Los Angeles, CA
May 21, 7:00 pm 2019
Tuesday
May 21
7:00 pm
Snow Patrol
Wiltern Theatre, Los Angeles, 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