LISTE POUR : Dean Lewis

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

February

Dean Lewis with SYML
El Rey Theatre Los Angeles Los Angeles, CA
Feb 12, 8:00 pm 2019
Tuesday
Feb 12
8:00 pm
Dean Lewis with SYML
El Rey Theatre, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 442
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Dean Lewis
El Rey Theatre Los Angeles Los Angeles, CA
Feb 13, 8:00 pm 2019
Wednesday
Feb 13
8:00 pm
Dean Lewis
El Rey Theatre, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 3365
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
SYML
The Independent San Francisco San Francisco, CA
Feb 15, 9:00 pm 2019
Friday
Feb 15
9:00 pm
SYML
The Independent, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 31647
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Dean Lewis
Imperial (Vancouver) Vancouver Vancouver, BC
Feb 19, 8:00 pm 2019
Tuesday
Feb 19
8:00 pm
Dean Lewis
Imperial (Vancouver), Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 4059
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Dean Lewis
Wonder Ballroom Portland Portland, OR
Feb 20, 8:00 pm 2019
Wednesday
Feb 20
8:00 pm
Dean Lewis
Wonder Ballroom, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 33558
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
Dean Lewis with SYML
Metro Music Hall Salt Lake City Salt Lake City, UT
Feb 22, 8:00 pm 2019
Friday
Feb 22
8:00 pm
Dean Lewis with SYML
Metro Music Hall, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 525
SELECT * from toolcitypagelink WHERE cityname = 'Boulder'
Dean Lewis
Fox Theatre Boulder Boulder, CO
Feb 23, 9:00 pm 2019
Saturday
Feb 23
9:00 pm
Dean Lewis
Fox Theatre, Boulder, CO
SELECT * from toolvenuepagelink WHERE venueid = 1199
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Dean Lewis with SYML
Park West Chicago Chicago, IL
Feb 26, 7:30 pm 2019
Tuesday
Feb 26
7:30 pm
Dean Lewis with SYML
Park West, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 4858
SELECT * from toolcitypagelink WHERE cityname = 'Edmonton'

March

Dean Lewis
The Velvet Underground Edmonton Edmonton, AB
Mar 1, 8:00 pm 2019
Friday
Mar 1
8:00 pm
Dean Lewis
The Velvet Underground, Edmonton, AB
SELECT * from toolvenuepagelink WHERE venueid = 18123
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Dean Lewis
Corona Theatre Montreal Montreal, QC
Mar 2, 8:00 pm 2019
Saturday
Mar 2
8:00 pm
Dean Lewis
Corona Theatre, Montreal, QC
SELECT * from toolvenuepagelink WHERE venueid = 3427
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Dean Lewis
Royale Boston Boston Boston, MA
Mar 3, 8:00 pm 2019
Sunday
Mar 3
8:00 pm
Dean Lewis
Royale Boston, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 32474
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
Dean Lewis
The Fillmore Philadelphia Philadelphia Philadelphia, PA
Mar 5, 8:00 pm 2019
Tuesday
Mar 5
8:00 pm
Dean Lewis
The Fillmore Philadelphia, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 33826
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Dean Lewis with SYML
Union Stage Washington Washington, DC
Mar 9, 8:00 pm 2019
Saturday
Mar 9
8:00 pm
Dean Lewis with SYML
Union Stage, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 28994
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Dean Lewis with SYML
Terminal West Atlanta Atlanta, GA
Mar 10, 8:00 pm 2019
Sunday
Mar 10
8:00 pm
Dean Lewis with SYML
Terminal West, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 3312
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
Dean Lewis with SYML
Mercy Lounge Nashville Nashville, TN
Mar 11, 8:00 pm 2019
Monday
Mar 11
8:00 pm
Dean Lewis with SYML
Mercy Lounge, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 1600
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Dean Lewis with SYML
Trees Dallas Dallas, TX
Mar 13, 8:00 pm 2019
Wednesday
Mar 13
8:00 pm
Dean Lewis with SYML
Trees, Dallas, TX
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football