LISTE POUR : One Ok Rock

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

February

ONE OK ROCK
The Depot Salt Lake City Salt Lake City, UT
Feb 19, 7:30 pm 2019
Tuesday
Feb 19
7:30 pm
ONE OK ROCK
The Depot, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 2040
SELECT * from toolcitypagelink WHERE cityname = 'Englewood'
One Ok Rock
Gothic Theatre Englewood Englewood, CO
Feb 20, 8:00 pm 2019
Wednesday
Feb 20
8:00 pm
One Ok Rock
Gothic Theatre, Englewood, CO
SELECT * from toolvenuepagelink WHERE venueid = 4092
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
One Ok Rock
Varsity Theater - Minneapolis, MN Minneapolis Minneapolis, MN
Feb 22, 6:00 pm 2019
Friday
Feb 22
6:00 pm
One Ok Rock
Varsity Theater - Minneapolis, MN, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 2283
SELECT * from toolcitypagelink WHERE cityname = 'Milwaukee'
One Ok Rock
Rave-Eagles Ballroom Milwaukee Milwaukee, WI
Feb 23, 8:00 pm 2019
Saturday
Feb 23
8:00 pm
One Ok Rock
Rave-Eagles Ballroom, Milwaukee, WI
SELECT * from toolvenuepagelink WHERE venueid = 680
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
One Ok Rock
House of Blues - Chicago Chicago Chicago, IL
Feb 24, 5:30 pm 2019
Sunday
Feb 24
5:30 pm
One Ok Rock
House of Blues - Chicago, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 3266
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
One Ok Rock
House of Blues - Cleveland Cleveland Cleveland, OH
Feb 24, 6:15 pm 2019
Sunday
Feb 24
6:15 pm
One Ok Rock
House of Blues - Cleveland, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 1371
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
One Ok Rock
St. Andrews Hall Detroit Detroit, MI
Feb 26, 6:30 pm 2019
Tuesday
Feb 26
6:30 pm
One Ok Rock
St. Andrews Hall, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 18146
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
One Ok Rock
Rebel Toronto Toronto, ON
Feb 28, 6:30 pm 2019
Thursday
Feb 28
6:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 8407
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'

March

ONE OK ROCK
Le National Montreal Montreal, PQ
Mar 1, 7:30 pm 2019
Friday
Mar 1
7:30 pm
ONE OK ROCK
Le National, Montreal, PQ
SELECT * from toolvenuepagelink WHERE venueid = 856
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
One Ok Rock
Theatre of Living Arts Philadelphia Philadelphia, PA
Mar 2, 8:00 pm 2019
Saturday
Mar 2
8:00 pm
One Ok Rock
Theatre of Living Arts, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 2254
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
One Ok Rock
Paradise Rock Club Boston Boston, MA
Mar 3, 6:30 pm 2019
Sunday
Mar 3
6:30 pm
One Ok Rock
Paradise Rock Club, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 4954
SELECT * from toolcitypagelink WHERE cityname = 'New York'
One Ok Rock
Terminal 5 New York New York, NY
Mar 5, 7:00 pm 2019
Tuesday
Mar 5
7:00 pm
One Ok Rock
Terminal 5, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 3508
SELECT * from toolcitypagelink WHERE cityname = 'Baltimore'
One Ok Rock
Rams Head Live Baltimore Baltimore, MD
Mar 6, 7:30 pm 2019
Wednesday
Mar 6
7:30 pm
One Ok Rock
Rams Head Live, Baltimore, MD
SELECT * from toolvenuepagelink WHERE venueid = 634
SELECT * from toolcitypagelink WHERE cityname = 'Orlando'
One Ok Rock
Hard Rock Live-Orlando Orlando Orlando, FL
Mar 9, 8:00 pm 2019
Saturday
Mar 9
8:00 pm
One Ok Rock
Hard Rock Live-Orlando, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 5679
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
One Ok Rock
House of Blues - Houston Houston Houston, TX
Mar 11, 6:30 pm 2019
Monday
Mar 11
6:30 pm
One Ok Rock
House of Blues - Houston, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 4568
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
One Ok Rock
House of Blues - Dallas Dallas Dallas, TX
Mar 12, 7:30 pm 2019
Tuesday
Mar 12
7:30 pm
One Ok Rock
House of Blues - Dallas, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 30567
SELECT * from toolcitypagelink WHERE cityname = 'San Antonio'
One Ok Rock
Aztec Theater San Antonio San Antonio, TX
Mar 13, 6:30 pm 2019
Wednesday
Mar 13
6:30 pm
One Ok Rock
Aztec Theater, San Antonio, TX
SELECT * from toolvenuepagelink WHERE venueid = 33533
SELECT * from toolcitypagelink WHERE cityname = 'Phoenix'
One Ok Rock
The Van Buren Phoenix Phoenix, AZ
Mar 15, 8:00 pm 2019
Friday
Mar 15
8:00 pm
One Ok Rock
The Van Buren, Phoenix, AZ
SELECT * from toolvenuepagelink WHERE venueid = 682
SELECT * from toolcitypagelink WHERE cityname = 'Las Vegas'
One Ok Rock
House of Blues - Las Vegas Las Vegas Las Vegas, NV
Mar 16, 6:30 pm 2019
Saturday
Mar 16
6:30 pm
One Ok Rock
House of Blues - Las Vegas, Las Vegas, NV
SELECT * from toolvenuepagelink WHERE venueid = 28217
SELECT * from toolcitypagelink WHERE cityname = 'San Diego'
One Ok Rock
The Observatory North Park San Diego San Diego, CA
Mar 17, 8:00 pm 2019
Sunday
Mar 17
8:00 pm
One Ok Rock
The Observatory North Park, San Diego, CA
SELECT * from toolvenuepagelink WHERE venueid = 670
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
One Ok Rock
Hollywood Palladium Los Angeles Los Angeles, CA
Mar 19, 7:00 pm 2019
Tuesday
Mar 19
7:00 pm
One Ok Rock
Hollywood Palladium, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 1708
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
ONE OK ROCK with Waterparks
The Warfield San Francisco San Francisco, CA
Mar 20, 7:30 pm 2019
Wednesday
Mar 20
7:30 pm
ONE OK ROCK with Waterparks
The Warfield, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 1692
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
One Ok Rock
Vogue Theatre Vancouver Vancouver, BC
Mar 22, 8:00 pm 2019
Friday
Mar 22
8:00 pm
One Ok Rock
Vogue Theatre, Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 5085
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
One Ok Rock
Showbox SoDo Seattle Seattle, WA
Mar 24, 7:30 pm 2019
Sunday
Mar 24
7:30 pm
One Ok Rock
Showbox SoDo, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 27583
SELECT * from toolcitypagelink WHERE cityname = 'Honolulu'
ONE OK ROCK
The Republik Honolulu Honolulu, HI
Mar 29, 8:00 pm 2019
Friday
Mar 29
8:00 pm
ONE OK ROCK
The Republik, Honolulu, HI
SELECT * from toolvenuepagelink WHERE venueid = 27583
SELECT * from toolcitypagelink WHERE cityname = 'Honolulu'
One Ok Rock
The Republik Honolulu Honolulu, HI
Mar 30, 8:00 pm 2019
Saturday
Mar 30
8:00 pm
One Ok Rock
The Republik, Honolulu, HI
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football