LISTE POUR : Dawes

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

January

Dawes
The Commonwealth Room Salt Lake City Salt Lake City, UT
Jan 22, 8:00 pm 2019
Tuesday
Jan 22
8:00 pm
Dawes
The Commonwealth Room, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 33347
SELECT * from toolcitypagelink WHERE cityname = 'St. Louis'
Dawes
The Pageant St. Louis St. Louis, MO
Jan 25, 8:00 pm 2019
Friday
Jan 25
8:00 pm
Dawes
The Pageant, St. Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 1324
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Dawes
Riviera Theatre (Chicago) Chicago Chicago, IL
Jan 29, 8:00 pm 2019
Tuesday
Jan 29
8:00 pm
Dawes
Riviera Theatre (Chicago), Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 2992
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Dawes
Danforth Music Hall Toronto Toronto, ON
Jan 30, 7:00 pm 2019
Wednesday
Jan 30
7:00 pm
Dawes
Danforth Music Hall, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 32474
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'

February

Dawes
The Fillmore Philadelphia Philadelphia Philadelphia, PA
Feb 1, 8:00 pm 2019
Friday
Feb 1
8:00 pm
Dawes
The Fillmore Philadelphia, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 1701
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Dawes
Wang Theatre at Citi Performing Arts Center Boston Boston, MA
Feb 2, 8:00 pm 2019
Saturday
Feb 2
8:00 pm
Dawes
Wang Theatre at Citi Performing Arts Center, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 123
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Dawes
Beacon Theatre New York New York, NY
Feb 5, 8:00 pm 2019
Tuesday
Feb 5
8:00 pm
Dawes
Beacon Theatre, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 223
SELECT * from toolcitypagelink WHERE cityname = 'Port Chester'
Dawes
Capitol Theatre Port Chester Port Chester, NY
Feb 6, 8:00 pm 2019
Wednesday
Feb 6
8:00 pm
Dawes
Capitol Theatre, Port Chester, NY
SELECT * from toolvenuepagelink WHERE venueid = 7165
SELECT * from toolcitypagelink WHERE cityname = 'Charlottesville'
Dawes
Jefferson Theater Charlottesville Charlottesville, VA
Feb 8, 7:00 pm 2019
Friday
Feb 8
7:00 pm
Dawes
Jefferson Theater, Charlottesville, VA
SELECT * from toolvenuepagelink WHERE venueid = 1366
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
Dawes - 2 Day Pass
Ryman Auditorium Nashville Nashville, TN
Feb 9, 12:00 pm 2019
Saturday
Feb 9
12:00 pm
Dawes - 2 Day Pass
Ryman Auditorium, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 1366
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
Dawes
Ryman Auditorium Nashville Nashville, TN
Feb 9, 7:00 pm 2019
Saturday
Feb 9
7:00 pm
Dawes
Ryman Auditorium, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 1366
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
Dawes
Ryman Auditorium Nashville Nashville, TN
Feb 10, 7:00 pm 2019
Sunday
Feb 10
7:00 pm
Dawes
Ryman Auditorium, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 1842
SELECT * from toolcitypagelink WHERE cityname = 'Athens'
Dawes
Georgia Theatre Athens Athens, GA
Feb 12, 8:00 pm 2019
Tuesday
Feb 12
8:00 pm
Dawes
Georgia Theatre, Athens, GA
SELECT * from toolvenuepagelink WHERE venueid = 6721
SELECT * from toolcitypagelink WHERE cityname = 'Clearwater'
Dawes
Capitol Theatre - FL Clearwater Clearwater, FL
Feb 17, 8:00 pm 2019
Sunday
Feb 17
8:00 pm
Dawes
Capitol Theatre - FL, Clearwater, FL
SELECT * from toolvenuepagelink WHERE venueid = 5369
SELECT * from toolcitypagelink WHERE cityname = 'St Augustine'
Dawes
St Augustine Amphitheatre St Augustine St Augustine, FL
Feb 19, 8:00 pm 2019
Tuesday
Feb 19
8:00 pm
Dawes
St Augustine Amphitheatre, St Augustine, FL
SELECT * from toolvenuepagelink WHERE venueid = 3715
SELECT * from toolcitypagelink WHERE cityname = 'Charleston'
Dawes
Charleston Music Hall Charleston Charleston, SC
Feb 20, 8:00 pm 2019
Wednesday
Feb 20
8:00 pm
Dawes
Charleston Music Hall, Charleston, SC
SELECT * from toolvenuepagelink WHERE venueid = 2828
SELECT * from toolcitypagelink WHERE cityname = 'Greenville'

May

Dawes
Peace Center Greenville Greenville, SC
May 18, 8:00 pm 2019
Saturday
May 18
8:00 pm
Dawes
Peace Center, Greenville, SC
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football