LISTE POUR : The Devil Makes Three

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

January

The Devil Makes Three
The Orange Peel Asheville Asheville, NC
Jan 17, 9:00 pm 2019
Thursday
Jan 17
9:00 pm
The Devil Makes Three
The Orange Peel, Asheville, NC
SELECT * from toolvenuepagelink WHERE venueid = 1670
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
The Devil Makes Three
Variety Playhouse Atlanta Atlanta, GA
Jan 18, 9:00 pm 2019
Friday
Jan 18
9:00 pm
The Devil Makes Three
Variety Playhouse, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 33171
SELECT * from toolcitypagelink WHERE cityname = 'Knoxville'
The Devil Makes Three
The Mill & Mine Knoxville Knoxville, TN
Jan 19, 9:00 pm 2019
Saturday
Jan 19
9:00 pm
The Devil Makes Three
The Mill & Mine, Knoxville, TN
SELECT * from toolvenuepagelink WHERE venueid = 7880
SELECT * from toolcitypagelink WHERE cityname = 'Pensacola'
The Devil Makes Three
Vinyl Music Hall Pensacola Pensacola, FL
Jan 23, 7:00 pm 2019
Wednesday
Jan 23
7:00 pm
The Devil Makes Three
Vinyl Music Hall, Pensacola, FL
SELECT * from toolvenuepagelink WHERE venueid = 32931
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
The Devil Makes Three
White Oak Music Hall Houston Houston, TX
Jan 25, 8:00 pm 2019
Friday
Jan 25
8:00 pm
The Devil Makes Three
White Oak Music Hall, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 2171
SELECT * from toolcitypagelink WHERE cityname = 'Austin'
The Devil Makes Three
Emo's East Austin Austin, TX
Jan 26, 7:00 pm 2019
Saturday
Jan 26
7:00 pm
The Devil Makes Three
Emo's East, Austin, TX
SELECT * from toolvenuepagelink WHERE venueid = 1600
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
The Devil Makes Three
Trees Dallas Dallas, TX
Jan 27, 8:00 pm 2019
Sunday
Jan 27
8:00 pm
The Devil Makes Three
Trees, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 33347
SELECT * from toolcitypagelink WHERE cityname = 'St. Louis'
The Devil Makes Three
The Pageant St. Louis St. Louis, MO
Jan 30, 8:00 pm 2019
Wednesday
Jan 30
8:00 pm
The Devil Makes Three
The Pageant, St. Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 4106
SELECT * from toolcitypagelink WHERE cityname = 'Madison'
The Devil Makes Three
Majestic Theatre Madison Madison, WI
Jan 31, 8:30 pm 2019
Thursday
Jan 31
8:30 pm
The Devil Makes Three
Majestic Theatre, Madison, WI
SELECT * from toolvenuepagelink WHERE venueid = 496
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'

February

The Devil Makes Three
First Avenue Minneapolis Minneapolis, MN
Feb 1, 9:00 pm 2019
Friday
Feb 1
9:00 pm
The Devil Makes Three
First Avenue, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 30272
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
The Devil Makes Three
Concord Music Hall Chicago Chicago, IL
Feb 2, 8:00 pm 2019
Saturday
Feb 2
8:00 pm
The Devil Makes Three
Concord Music Hall, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 1371
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
The Devil Makes Three
St. Andrews Hall Detroit Detroit, MI
Feb 5, 7:00 pm 2019
Tuesday
Feb 5
7:00 pm
The Devil Makes Three
St. Andrews Hall, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 3266
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
The Devil Makes Three
House of Blues - Cleveland Cleveland Cleveland, OH
Feb 6, 8:00 pm 2019
Wednesday
Feb 6
8:00 pm
The Devil Makes Three
House of Blues - Cleveland, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 3142
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
The Devil Makes Three
Mod Club Theatre Toronto Toronto, ON
Feb 7, 7:30 pm 2019
Thursday
Feb 7
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 18123
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
The Devil Makes Three
Corona Theatre Montreal Montreal, QC
Feb 8, 8:00 pm 2019
Friday
Feb 8
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 32217
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
The Devil Makes Three
State Theatre - Maine Portland Portland, ME
Feb 9, 9:00 pm 2019
Saturday
Feb 9
9:00 pm
The Devil Makes Three
State Theatre - Maine, Portland, ME
SELECT * from toolvenuepagelink WHERE venueid = 3919
SELECT * from toolcitypagelink WHERE cityname = 'South Burlington'
The Devil Makes Three
Higher Ground South Burlington South Burlington, VT
Feb 12, 8:00 pm 2019
Tuesday
Feb 12
8:00 pm
The Devil Makes Three
Higher Ground, South Burlington, VT
SELECT * from toolvenuepagelink WHERE venueid = 7916
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
The Devil Makes Three
Union Transfer Philadelphia Philadelphia, PA
Feb 14, 8:30 pm 2019
Thursday
Feb 14
8:30 pm
The Devil Makes Three
Union Transfer, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 4853
SELECT * from toolcitypagelink WHERE cityname = 'Brooklyn'
The Devil Makes Three
Music Hall of Williamsburg Brooklyn Brooklyn, NY
Feb 15, 9:00 pm 2019
Friday
Feb 15
9:00 pm
The Devil Makes Three
Music Hall of Williamsburg, Brooklyn, NY
SELECT * from toolvenuepagelink WHERE venueid = 6064
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
The Devil Makes Three
House of Blues - Boston Boston Boston, MA
Feb 16, 7:00 pm 2019
Saturday
Feb 16
7:00 pm
The Devil Makes Three
House of Blues - Boston, Boston, MA
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football