LISTE POUR : Disturbed

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

January

Disturbed
Pinnacle Bank Arena Lincoln Lincoln, NE
Jan 22, 7:30 pm 2019
Tuesday
Jan 22
7:30 pm
Disturbed
Pinnacle Bank Arena, Lincoln, NE
SELECT * from toolvenuepagelink WHERE venueid = 4603
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Disturbed
Sprint Center Kansas City Kansas City, MO
Jan 23, 7:30 pm 2019
Wednesday
Jan 23
7:30 pm
Disturbed
Sprint Center, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 22
SELECT * from toolcitypagelink WHERE cityname = 'San Antonio'
Disturbed
Alamodome San Antonio San Antonio, TX
Jan 25, 7:30 pm 2019
Friday
Jan 25
7:30 pm
Disturbed
Alamodome, San Antonio, TX
SELECT * from toolvenuepagelink WHERE venueid = 28035
SELECT * from toolcitypagelink WHERE cityname = 'San Antonio'
Disturbed
Illusions Theater At The Alamodome San Antonio San Antonio, TX
Jan 25, 7:30 pm 2019
Friday
Jan 25
7:30 pm
Disturbed
Illusions Theater At The Alamodome, San Antonio, TX
SELECT * from toolvenuepagelink WHERE venueid = 1947
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Disturbed
American Airlines Center Dallas Dallas, TX
Jan 26, 7:30 pm 2019
Saturday
Jan 26
7:30 pm
Disturbed
American Airlines Center, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 2786
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
Disturbed
Toyota Center Houston Houston, TX
Jan 28, 7:30 pm 2019
Monday
Jan 28
7:30 pm
Disturbed
Toyota Center, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 1216
SELECT * from toolcitypagelink WHERE cityname = 'Peoria'
Disturbed
Peoria Civic Center Peoria Peoria, IL
Jan 30, 7:30 pm 2019
Wednesday
Jan 30
7:30 pm
Disturbed
Peoria Civic Center, Peoria, IL
SELECT * from toolvenuepagelink WHERE venueid = 1534
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'

February

Disturbed
Target Center Minneapolis Minneapolis, MN
Feb 1, 7:30 pm 2019
Friday
Feb 1
7:30 pm
Disturbed
Target Center, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 1080
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
Disturbed
Bridgestone Arena Nashville Nashville, TN
Feb 16, 7:30 pm 2019
Saturday
Feb 16
7:30 pm
Disturbed
Bridgestone Arena, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 499
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
Disturbed
Wells Fargo Center Philadelphia Philadelphia, PA
Feb 18, 7:30 pm 2019
Monday
Feb 18
7:30 pm
Disturbed
Wells Fargo Center, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 7329
SELECT * from toolcitypagelink WHERE cityname = 'Pittsburgh'
Disturbed
PPG Paints Arena Pittsburgh Pittsburgh, PA
Feb 20, 7:30 pm 2019
Wednesday
Feb 20
7:30 pm
Disturbed
PPG Paints Arena, Pittsburgh, PA
SELECT * from toolvenuepagelink WHERE venueid = 955
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Disturbed
Capital One Arena Washington Washington, DC
Feb 21, 7:30 pm 2019
Thursday
Feb 21
7:30 pm
Disturbed
Capital One Arena, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 2061
SELECT * from toolcitypagelink WHERE cityname = 'Uncasville'
Disturbed
Mohegan Sun Arena Uncasville Uncasville, CT
Feb 23, 7:30 pm 2019
Saturday
Feb 23
7:30 pm
Disturbed
Mohegan Sun Arena, Uncasville, CT
SELECT * from toolvenuepagelink WHERE venueid = 896
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Disturbed
Madison Square Garden New York New York, NY
Feb 25, 7:30 pm 2019
Monday
Feb 25
7:30 pm
Disturbed
Madison Square Garden, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 2172
SELECT * from toolcitypagelink WHERE cityname = 'Worcester'
Disturbed
DCU Center Worcester Worcester, MA
Feb 27, 7:30 pm 2019
Wednesday
Feb 27
7:30 pm
Disturbed
DCU Center, Worcester, MA
SELECT * from toolvenuepagelink WHERE venueid = 33560
SELECT * from toolcitypagelink WHERE cityname = 'Laval'

March

Disturbed
Place Bell Laval Laval, QC
Mar 1, 7:30 pm 2019
Friday
Mar 1
7:30 pm
Disturbed
Place Bell, Laval, QC
SELECT * from toolvenuepagelink WHERE venueid = 1786
SELECT * from toolcitypagelink WHERE cityname = 'Buffalo'
Disturbed
KeyBank Center Buffalo Buffalo, NY
Mar 2, 7:30 pm 2019
Saturday
Mar 2
7:30 pm
Disturbed
KeyBank Center, Buffalo, NY
SELECT * from toolvenuepagelink WHERE venueid = 17
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Disturbed
Scotiabank Arena Toronto Toronto, ON
Mar 4, 7:30 pm 2019
Monday
Mar 4
7:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 33422
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
Disturbed
Little Caesars Arena Detroit Detroit, MI
Mar 5, 7:30 pm 2019
Tuesday
Mar 5
7:30 pm
Disturbed
Little Caesars Arena, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 1663
SELECT * from toolcitypagelink WHERE cityname = 'Grand Rapids'
Disturbed
Van Andel Arena Grand Rapids Grand Rapids, MI
Mar 7, 7:30 pm 2019
Thursday
Mar 7
7:30 pm
Disturbed
Van Andel Arena, Grand Rapids, MI
SELECT * from toolvenuepagelink WHERE venueid = 33
SELECT * from toolcitypagelink WHERE cityname = 'Rosemont'
Disturbed
Allstate Arena Rosemont Rosemont, IL
Mar 8, 7:30 pm 2019
Friday
Mar 8
7:30 pm
Disturbed
Allstate Arena, Rosemont, IL
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football