LISTE POUR : Set It Off

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

February

Set it Off
Vinyl at Hard Rock Hotel & Casino Las Vegas Las Vegas Las Vegas, NV
Feb 15, 6:30 pm 2019
Friday
Feb 15
6:30 pm
Set it Off
Vinyl at Hard Rock Hotel & Casino Las Vegas, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 576
SELECT * from toolcitypagelink WHERE cityname = 'Pomona'
Set it Off
Glass House Pomona Pomona, CA
Feb 16, 6:30 pm 2019
Saturday
Feb 16
6:30 pm
Set it Off
Glass House, Pomona, CA
SELECT * from toolvenuepagelink WHERE venueid = 2159
SELECT * from toolcitypagelink WHERE cityname = 'Santa Cruz'
Set it Off
The Catalyst - CA Santa Cruz Santa Cruz, CA
Feb 17, 7:00 pm 2019
Sunday
Feb 17
7:00 pm
Set it Off
The Catalyst - CA, Santa Cruz, CA
SELECT * from toolvenuepagelink WHERE venueid = 4459
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Set it Off
El Corazon Seattle Seattle, WA
Feb 20, 7:00 pm 2019
Wednesday
Feb 20
7:00 pm
Set it Off
El Corazon, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 3541
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
Set it Off
In The Venue Salt Lake City Salt Lake City, UT
Feb 23, 7:00 pm 2019
Saturday
Feb 23
7:00 pm
Set it Off
In The Venue, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 7810
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Set it Off
Summit Music Hall Denver Denver, CO
Feb 24, 6:00 pm 2019
Sunday
Feb 24
6:00 pm
Set it Off
Summit Music Hall, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 2164
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Set it Off
Metro Smart Bar Chicago Chicago, IL
Feb 26, 5:30 pm 2019
Tuesday
Feb 26
5:30 pm
Set it Off
Metro Smart Bar, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 5102
SELECT * from toolcitypagelink WHERE cityname = 'Pontiac'
Set it Off
The Crofoot Ballroom Pontiac Pontiac, MI
Feb 27, 6:00 pm 2019
Wednesday
Feb 27
6:00 pm
Set it Off
The Crofoot Ballroom, Pontiac, MI
SELECT * from toolvenuepagelink WHERE venueid = 4533
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Set it Off
Gramercy Theatre New York New York, NY
Feb 28, 8:00 pm 2019
Thursday
Feb 28
8:00 pm
Set it Off
Gramercy Theatre, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 3052
SELECT * from toolcitypagelink WHERE cityname = 'Millvale'

March

Set it Off
Mr Smalls Theater Millvale Millvale, PA
Mar 2, 6:30 pm 2019
Saturday
Mar 2
6:30 pm
Set it Off
Mr Smalls Theater, Millvale, PA
SELECT * from toolvenuepagelink WHERE venueid = 7916
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
Set it Off
Union Transfer Philadelphia Philadelphia, PA
Mar 3, 6:30 pm 2019
Sunday
Mar 3
6:30 pm
Set it Off
Union Transfer, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 610
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
Set it Off
Grog Shop Cleveland Cleveland, OH
Mar 5, 6:30 pm 2019
Tuesday
Mar 5
6:30 pm
Set it Off
Grog Shop, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 3142
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Set it Off
Mod Club Theatre Toronto Toronto, ON
Mar 6, 6:30 pm 2019
Wednesday
Mar 6
6:30 pm
Set it Off
Mod Club Theatre, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 2254
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Set it Off
Paradise Rock Club Boston Boston, MA
Mar 8, 8:00 pm 2019
Friday
Mar 8
8:00 pm
Set it Off
Paradise Rock Club, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 16006
SELECT * from toolcitypagelink WHERE cityname = 'Baltimore'
Set it Off
Baltimore Soundstage Baltimore Baltimore, MD
Mar 9, 6:30 pm 2019
Saturday
Mar 9
6:30 pm
Set it Off
Baltimore Soundstage, Baltimore, MD
SELECT * from toolvenuepagelink WHERE venueid = 28357
SELECT * from toolcitypagelink WHERE cityname = 'Greensboro'
Set it Off
The Blind Tiger Greensboro Greensboro, NC
Mar 10, 6:00 pm 2019
Sunday
Mar 10
6:00 pm
Set it Off
The Blind Tiger, Greensboro, NC
SELECT * from toolvenuepagelink WHERE venueid = 33726
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Set it Off
The Masquerade Atlanta Atlanta, GA
Mar 13, 6:00 pm 2019
Wednesday
Mar 13
6:00 pm
Set it Off
The Masquerade, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 7094
SELECT * from toolcitypagelink WHERE cityname = 'San Diego'
Set it Off
The Abbey San Diego San Diego, CA
Mar 15, 7:00 pm 2019
Friday
Mar 15
7:00 pm
Set it Off
The Abbey, San Diego, CA
SELECT * from toolvenuepagelink WHERE venueid = 395
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Set it Off
Deep Ellum Live Dallas Dallas, TX
Mar 18, 6:00 pm 2019
Monday
Mar 18
6:00 pm
Set it Off
Deep Ellum Live, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 32931
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
Set it Off
White Oak Music Hall Houston Houston, TX
Mar 19, 6:00 pm 2019
Tuesday
Mar 19
6:00 pm
Set it Off
White Oak Music Hall, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 32033
SELECT * from toolcitypagelink WHERE cityname = 'San Antonio'
Set It Off
Alamo City Music Hall San Antonio San Antonio, TX
Mar 20, 6:00 pm 2019
Wednesday
Mar 20
6:00 pm
Set It Off
Alamo City Music Hall, San Antonio, TX
SELECT * from toolvenuepagelink WHERE venueid = 5099
SELECT * from toolcitypagelink WHERE cityname = 'Mesa'
Set it Off
Nile Theater Mesa Mesa, AZ
Mar 22, 6:00 pm 2019
Friday
Mar 22
6:00 pm
Set it Off
Nile Theater, Mesa, AZ
SELECT * from toolvenuepagelink WHERE venueid = 1926
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Set it Off
Great American Music Hall San Francisco San Francisco, CA
Mar 24, 8:00 pm 2019
Sunday
Mar 24
8:00 pm
Set it Off
Great American Music Hall, San Francisco, 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