LISTE POUR : Dream Theater

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

March

Dream Theater
Wiltern Theatre Los Angeles Los Angeles, CA
Mar 21, 7:00 pm 2019
Thursday
Mar 21
7:00 pm
Dream Theater
Wiltern Theatre, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 1752
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Dream Theater
Wiltern Theatre Los Angeles Los Angeles, CA
Mar 22, 7:00 pm 2019
Friday
Mar 22
7:00 pm
Dream Theater
Wiltern Theatre, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 2497
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Dream Theater
The Masonic San Francisco San Francisco, CA
Mar 24, 8:00 pm 2019
Sunday
Mar 24
8:00 pm
Dream Theater
The Masonic, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 1193
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Dream Theater
Paramount Theatre - CO Denver Denver, CO
Mar 26, 8:00 pm 2019
Tuesday
Mar 26
8:00 pm
Dream Theater
Paramount Theatre - CO, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 276
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Dream Theater
Chicago Theatre Chicago Chicago, IL
Mar 29, 8:00 pm 2019
Friday
Mar 29
8:00 pm
Dream Theater
Chicago Theatre, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 8067
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Dream Theater
The Chicago Theatre Downstairs Chicago Chicago, IL
Mar 29, 8:00 pm 2019
Friday
Mar 29
8:00 pm
Dream Theater
The Chicago Theatre Downstairs, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 2840
SELECT * from toolcitypagelink WHERE cityname = 'Milwaukee'
Dream Theater
Miller High Life Theatre Milwaukee Milwaukee, WI
Mar 31, 7:00 pm 2019
Sunday
Mar 31
7:00 pm
Dream Theater
Miller High Life Theatre, Milwaukee, WI
SELECT * from toolvenuepagelink WHERE venueid = 1490
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'

April

Dream Theater
The Fillmore Detroit Detroit Detroit, MI
Apr 2, 7:00 pm 2019
Tuesday
Apr 2
7:00 pm
Dream Theater
The Fillmore Detroit, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 690
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Dream Theater
Sony Centre for the Performing Arts Toronto Toronto, ON
Apr 4, 8:00 pm 2019
Thursday
Apr 4
8:00 pm
Dream Theater
Sony Centre for the Performing Arts, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 28652
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Dream Theater
Apr 5, 8:00 pm 2019
Friday
Apr 5
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 1160
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Dream Theater
Orpheum Theatre - Boston Boston Boston, MA
Apr 8, 8:00 pm 2019
Monday
Apr 8
8:00 pm
Dream Theater
Orpheum Theatre - Boston, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 30650
SELECT * from toolcitypagelink WHERE cityname = 'Wallingford'
Dream Theater
Toyota Oakdale Theatre Wallingford Wallingford, CT
Apr 9, 8:00 pm 2019
Tuesday
Apr 9
8:00 pm
Dream Theater
Toyota Oakdale Theatre, Wallingford, CT
SELECT * from toolvenuepagelink WHERE venueid = 353
SELECT * from toolcitypagelink WHERE cityname = 'Red Bank'
Dream Theater
Count Basie Theatre Red Bank Red Bank, NJ
Apr 10, 8:00 pm 2019
Wednesday
Apr 10
8:00 pm
Dream Theater
Count Basie Theatre, Red Bank, NJ
SELECT * from toolvenuepagelink WHERE venueid = 123
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Dream Theater
Beacon Theatre New York New York, NY
Apr 12, 8:00 pm 2019
Friday
Apr 12
8:00 pm
Dream Theater
Beacon Theatre, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 1590
SELECT * from toolcitypagelink WHERE cityname = 'Upper Darby'
Dream Theater
Tower Theater - PA Upper Darby Upper Darby, PA
Apr 13, 8:00 pm 2019
Saturday
Apr 13
8:00 pm
Dream Theater
Tower Theater - PA, Upper Darby, PA
SELECT * from toolvenuepagelink WHERE venueid = 1710
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Dream Theater
Warner Theatre - DC Washington Washington, DC
Apr 15, 8:00 pm 2019
Monday
Apr 15
8:00 pm
Dream Theater
Warner Theatre - DC, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 1585
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
Dream Theater
Tennessee Performing Arts Center Andrew Jackson Hall Nashville Nashville, TN
Apr 17, 7:30 pm 2019
Wednesday
Apr 17
7:30 pm
Dream Theater
Tennessee Performing Arts Center Andrew Jackson Hall, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 1167
SELECT * from toolcitypagelink WHERE cityname = 'Charlotte'
Dream Theater
Ovens Auditorium Charlotte Charlotte, NC
Apr 22, 8:00 pm 2019
Monday
Apr 22
8:00 pm
Dream Theater
Ovens Auditorium, Charlotte, NC
SELECT * from toolvenuepagelink WHERE venueid = 1555
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Dream Theater
The Tabernacle Atlanta Atlanta, GA
Apr 23, 8:00 pm 2019
Tuesday
Apr 23
8:00 pm
Dream Theater
The Tabernacle, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 634
SELECT * from toolcitypagelink WHERE cityname = 'Orlando'
Dream Theater
Hard Rock Live-Orlando Orlando Orlando, FL
Apr 24, 8:00 pm 2019
Wednesday
Apr 24
8:00 pm
Dream Theater
Hard Rock Live-Orlando, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 902
SELECT * from toolcitypagelink WHERE cityname = 'St Petersburg'
Dream Theater
Mahaffey Theater - Duke Energy Center St Petersburg St Petersburg, FL
Apr 26, 8:00 pm 2019
Friday
Apr 26
8:00 pm
Dream Theater
Mahaffey Theater - Duke Energy Center, St Petersburg, FL
SELECT * from toolvenuepagelink WHERE venueid = 1577
SELECT * from toolcitypagelink WHERE cityname = 'Jacksonville'
Dream Theater
Times Union Performing Arts - Moran Theater Jacksonville Jacksonville, FL
Apr 27, 8:00 pm 2019
Saturday
Apr 27
8:00 pm
Dream Theater
Times Union Performing Arts - Moran Theater, Jacksonville, FL
SELECT * from toolvenuepagelink WHERE venueid = 31816
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Dream Theater
Bomb Factory Dallas Dallas, TX
Apr 29, 8:00 pm 2019
Monday
Apr 29
8:00 pm
Dream Theater
Bomb Factory, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 2156
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
Dream Theater
Revention Music Center Houston Houston, TX
Apr 30, 8:00 pm 2019
Tuesday
Apr 30
8:00 pm
Dream Theater
Revention Music Center, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 118
SELECT * from toolcitypagelink WHERE cityname = 'Austin'

May

Dream Theater
Bass Concert Hall Austin Austin, TX
May 1, 7:30 pm 2019
Wednesday
May 1
7:30 pm
Dream Theater
Bass Concert Hall, Austin, 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