LISTE POUR : Foreigner

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

March

Foreigner
Tilles Center Hillwood Recital Hall Greenvale Greenvale, NY
Mar 21, 7:30 pm 2019
Thursday
Mar 21
7:30 pm
Foreigner
Tilles Center Hillwood Recital Hall, Greenvale, NY
SELECT * from toolvenuepagelink WHERE venueid = 7457
SELECT * from toolcitypagelink WHERE cityname = 'Cherokee'
Foreigner
Harrahs Cherokee Resort Event Center Cherokee Cherokee, NC
Mar 23, 7:30 pm 2019
Saturday
Mar 23
7:30 pm
Foreigner
Harrahs Cherokee Resort Event Center, Cherokee, NC
SELECT * from toolvenuepagelink WHERE venueid = 907
SELECT * from toolcitypagelink WHERE cityname = 'San Antonio'

April

Foreigner
Majestic Theatre San Antonio San Antonio San Antonio, TX
Apr 11, 8:00 pm 2019
Thursday
Apr 11
8:00 pm
Foreigner
Majestic Theatre San Antonio, San Antonio, TX
SELECT * from toolvenuepagelink WHERE venueid = 6728
SELECT * from toolcitypagelink WHERE cityname = 'Bossier City'
Foreigner
Riverdome At Horseshoe Casino Bossier City Bossier City, LA
Apr 12, 8:00 pm 2019
Friday
Apr 12
8:00 pm
Foreigner
Riverdome At Horseshoe Casino, Bossier City, LA
SELECT * from toolvenuepagelink WHERE venueid = 7965
SELECT * from toolcitypagelink WHERE cityname = 'Robinsonville'
Foreigner
Horseshoe Casino Robinsonville Robinsonville, MS
Apr 13, 8:00 pm 2019
Saturday
Apr 13
8:00 pm
Foreigner
Horseshoe Casino, Robinsonville, MS
SELECT * from toolvenuepagelink WHERE venueid = 2978
SELECT * from toolcitypagelink WHERE cityname = 'Amarillo'
Foreigner
Amarillo Civic Center Auditorium Amarillo Amarillo, TX
Apr 15, 7:30 pm 2019
Monday
Apr 15
7:30 pm
Foreigner
Amarillo Civic Center Auditorium, Amarillo, TX
SELECT * from toolvenuepagelink WHERE venueid = 4214
SELECT * from toolcitypagelink WHERE cityname = 'Norman'
Foreigner
Riverwind Casino Showplace Theatre Norman Norman, OK
Apr 19, 8:00 pm 2019
Friday
Apr 19
8:00 pm
Foreigner
Riverwind Casino Showplace Theatre, Norman, OK
SELECT * from toolvenuepagelink WHERE venueid = 5916
SELECT * from toolcitypagelink WHERE cityname = 'Durant'
Foreigner
Choctaw Grand Theater Durant Durant, OK
Apr 20, 8:00 pm 2019
Saturday
Apr 20
8:00 pm
Foreigner
Choctaw Grand Theater, Durant, OK
SELECT * from toolvenuepagelink WHERE venueid = 32042
SELECT * from toolcitypagelink WHERE cityname = 'Durant'
Foreigner
Choctaw Casino Resort Durant Durant, OK
Apr 20, 8:00 pm 2019
Saturday
Apr 20
8:00 pm
Foreigner
Choctaw Casino Resort, Durant, OK
SELECT * from toolvenuepagelink WHERE venueid = 3318
SELECT * from toolcitypagelink WHERE cityname = 'Beaumont'
Foreigner
Julie Rogers Theatre Beaumont Beaumont, TX
Apr 22, 7:00 pm 2019
Monday
Apr 22
7:00 pm
Foreigner
Julie Rogers Theatre, Beaumont, TX
SELECT * from toolvenuepagelink WHERE venueid = 1409
SELECT * from toolcitypagelink WHERE cityname = 'Corpus Christi'
Foreigner
Selena Auditorium Corpus Christi Corpus Christi, TX
Apr 23, 7:30 pm 2019
Tuesday
Apr 23
7:30 pm
Foreigner
Selena Auditorium, Corpus Christi, TX
SELECT * from toolvenuepagelink WHERE venueid = 28098
SELECT * from toolcitypagelink WHERE cityname = 'McAllen'
Foreigner
McAllen Convention Center McAllen McAllen, TX
Apr 24, 8:00 pm 2019
Wednesday
Apr 24
8:00 pm
Foreigner
McAllen Convention Center, McAllen, TX
SELECT * from toolvenuepagelink WHERE venueid = 3695
SELECT * from toolcitypagelink WHERE cityname = 'Biloxi'
Foreigner
Hard Rock Live Biloxi Biloxi Biloxi, MS
Apr 26, 8:00 pm 2019
Friday
Apr 26
8:00 pm
Foreigner
Hard Rock Live Biloxi, Biloxi, MS
SELECT * from toolvenuepagelink WHERE venueid = 3872
SELECT * from toolcitypagelink WHERE cityname = 'Englewood'

May

Foreigner
Bergen Performing Arts Center Englewood Englewood, NJ
May 3, 8:00 pm 2019
Friday
May 3
8:00 pm
Foreigner
Bergen Performing Arts Center, Englewood, NJ
SELECT * from toolvenuepagelink WHERE venueid = 33653
SELECT * from toolcitypagelink WHERE cityname = 'Bensalem'
Foreigner
Parx Casino and Racing Bensalem Bensalem, PA
May 4, 8:00 pm 2019
Saturday
May 4
8:00 pm
Foreigner
Parx Casino and Racing, Bensalem, PA
SELECT * from toolvenuepagelink WHERE venueid = 3722
SELECT * from toolcitypagelink WHERE cityname = 'Verona'
Foreigner
Turning Stone Casino Verona Verona, NY
May 5, 7:00 pm 2019
Sunday
May 5
7:00 pm
Foreigner
Turning Stone Casino, Verona, NY
SELECT * from toolvenuepagelink WHERE venueid = 353
SELECT * from toolcitypagelink WHERE cityname = 'Red Bank'
Foreigner
Count Basie Theatre Red Bank Red Bank, NJ
May 7, 8:00 pm 2019
Tuesday
May 7
8:00 pm
Foreigner
Count Basie Theatre, Red Bank, NJ
SELECT * from toolvenuepagelink WHERE venueid = 320
SELECT * from toolcitypagelink WHERE cityname = 'Morristown'
Foreigner
The Community Theatre at Mayo Center of the Performing Arts Morristown Morristown, NJ
May 8, 8:00 pm 2019
Wednesday
May 8
8:00 pm
Foreigner
The Community Theatre at Mayo Center of the Performing Arts, Morristown, NJ
SELECT * from toolvenuepagelink WHERE venueid = 5379
SELECT * from toolcitypagelink WHERE cityname = 'Worcester'
Foreigner
Hanover Theatre Worcester Worcester, MA
May 9, 8:00 pm 2019
Thursday
May 9
8:00 pm
Foreigner
Hanover Theatre, Worcester, MA
SELECT * from toolvenuepagelink WHERE venueid = 4484
SELECT * from toolcitypagelink WHERE cityname = 'Lancaster'
Foreigner
American Music Theatre Lancaster Lancaster, PA
May 10, 8:00 pm 2019
Friday
May 10
8:00 pm
Foreigner
American Music Theatre, Lancaster, PA
SELECT * from toolvenuepagelink WHERE venueid = 28795
SELECT * from toolcitypagelink WHERE cityname = 'New Buffalo'
Foreigner
Silver Creek Event Center at Four Winds New Buffalo New Buffalo New Buffalo, MI
May 25, 9:00 pm 2019
Saturday
May 25
9:00 pm
Foreigner
Silver Creek Event Center at Four Winds New Buffalo, New Buffalo, MI
SELECT * from toolvenuepagelink WHERE venueid = 5571
SELECT * from toolcitypagelink WHERE cityname = 'Welch'
Foreigner
Treasure Island - Red Wing MN Welch Welch, MN
May 26, 8:00 pm 2019
Sunday
May 26
8:00 pm
Foreigner
Treasure Island - Red Wing MN, Welch, MN
SELECT * from toolvenuepagelink WHERE venueid = 30832
SELECT * from toolcitypagelink WHERE cityname = 'Scottsdale'

June

Foreigner
Pool at Talking Stick Resort Scottsdale Scottsdale, AZ
Jun 7, 8:00 pm 2019
Friday
Jun 7
8:00 pm
Foreigner
Pool at Talking Stick Resort, Scottsdale, AZ
SELECT * from toolvenuepagelink WHERE venueid = 1482
SELECT * from toolcitypagelink WHERE cityname = 'Goodsprings'
Foreigner
Star of the Desert Arena Goodsprings Goodsprings, NV
Jun 8, 8:00 pm 2019
Saturday
Jun 8
8:00 pm
Foreigner
Star of the Desert Arena, Goodsprings, NV
SELECT * from toolvenuepagelink WHERE venueid = 30158
SELECT * from toolcitypagelink WHERE cityname = 'Paso Robles'
Foreigner
Vina Robles Amphitheatre Paso Robles Paso Robles, CA
Jun 9, 7:00 pm 2019
Sunday
Jun 9
7:00 pm
Foreigner
Vina Robles Amphitheatre, Paso Robles, CA
SELECT * from toolvenuepagelink WHERE venueid = 7389
SELECT * from toolcitypagelink WHERE cityname = 'Lincoln'
Foreigner
Thunder Valley Casino Lincoln Lincoln, CA
Jun 14, 7:00 pm 2019
Friday
Jun 14
7:00 pm
Foreigner
Thunder Valley Casino, Lincoln, CA
SELECT * from toolvenuepagelink WHERE venueid = 32881
SELECT * from toolcitypagelink WHERE cityname = 'Lawrenceburg'
Foreigner
Lawrenceburg Event Center Lawrenceburg Lawrenceburg, IN
Jun 22, 8:00 pm 2019
Saturday
Jun 22
8:00 pm
Foreigner
Lawrenceburg Event Center, Lawrenceburg, IN
SELECT * from toolvenuepagelink WHERE venueid = 32170
SELECT * from toolcitypagelink WHERE cityname = 'Huber Heights'

August

Foreigner
The Rose Music Center at The Heights Huber Heights Huber Heights, OH
Aug 12, 8:00 pm 2019
Monday
Aug 12
8:00 pm
Foreigner
The Rose Music Center at The Heights, Huber Heights, OH
SELECT * from toolvenuepagelink WHERE venueid = 30652
SELECT * from toolcitypagelink WHERE cityname = 'Evansville'
Foreigner
Old National Events Plaza Evansville Evansville, IN
Aug 13, 7:30 pm 2019
Tuesday
Aug 13
7:30 pm
Foreigner
Old National Events Plaza, Evansville, IN
SELECT * from toolvenuepagelink WHERE venueid = 2005
SELECT * from toolcitypagelink WHERE cityname = 'Des Moines'
Foreigner
Iowa State Fairgrounds Des Moines Des Moines, IA
Aug 15, 8:00 pm 2019
Thursday
Aug 15
8:00 pm
Foreigner
Iowa State Fairgrounds, Des Moines, IA
SELECT * from toolvenuepagelink WHERE venueid = 32664
SELECT * from toolcitypagelink WHERE cityname = 'Wellington'
Foreigner
Lorain County Fair Wellington Wellington, OH
Aug 20, 7:30 pm 2019
Tuesday
Aug 20
7:30 pm
Foreigner
Lorain County Fair, Wellington, OH
SELECT * from toolvenuepagelink WHERE venueid = 220
SELECT * from toolcitypagelink WHERE cityname = 'Hyannis'
Foreigner
Cape Cod Melody Tent Hyannis Hyannis, MA
Aug 23, 8:00 pm 2019
Friday
Aug 23
8:00 pm
Foreigner
Cape Cod Melody Tent, Hyannis, MA
SELECT * from toolvenuepagelink WHERE venueid = 1453
SELECT * from toolcitypagelink WHERE cityname = 'Marshfield'
Foreigner
South Shore Music Circus Marshfield Marshfield, MA
Aug 24, 8:00 pm 2019
Saturday
Aug 24
8:00 pm
Foreigner
South Shore Music Circus, Marshfield, MA
SELECT * from toolvenuepagelink WHERE venueid = 2656
SELECT * from toolcitypagelink WHERE cityname = 'Hampton'
Foreigner
Hampton Beach Casino Ballroom Hampton Hampton, NH
Aug 25, 8:00 pm 2019
Sunday
Aug 25
8:00 pm
Foreigner
Hampton Beach Casino Ballroom, Hampton, NH
SELECT * from toolvenuepagelink WHERE venueid = 4017
SELECT * from toolcitypagelink WHERE cityname = 'Lewiston'
Foreigner
Artpark Mainstage Lewiston Lewiston, NY
Aug 27, 6:30 pm 2019
Tuesday
Aug 27
6:30 pm
Foreigner
Artpark Mainstage, Lewiston, NY
SELECT * from toolvenuepagelink WHERE venueid = 5170
SELECT * from toolcitypagelink WHERE cityname = 'Kitchener'

September

Foreigner
Centre in the Square Kitchener Kitchener, ON
Sep 3, 8:00 pm 2019
Tuesday
Sep 3
8:00 pm
Foreigner
Centre in the Square, Kitchener, ON
SELECT * from toolvenuepagelink WHERE venueid = 34085
SELECT * from toolcitypagelink WHERE cityname = 'Spencer'
Foreigner
Clay County Fairgrounds Spencer Spencer, IA
Sep 7, 7:30 pm 2019
Saturday
Sep 7
7:30 pm
Foreigner
Clay County Fairgrounds, Spencer, IA
SELECT * from toolvenuepagelink WHERE venueid = 2031
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
Foreigner
Utah State Fairgrounds Salt Lake City Salt Lake City, UT
Sep 13, 7:30 pm 2019
Friday
Sep 13
7:30 pm
Foreigner
Utah State Fairgrounds, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 1269
SELECT * from toolcitypagelink WHERE cityname = 'Puyallup'
Foreigner
Puyallup Fairgrounds Puyallup Puyallup, WA
Sep 18, 7:30 pm 2019
Wednesday
Sep 18
7:30 pm
Foreigner
Puyallup Fairgrounds, Puyallup, WA
SELECT * from toolvenuepagelink WHERE venueid = 5726
SELECT * from toolcitypagelink WHERE cityname = 'Bloomsburg'
Foreigner
Bloomsburg Fair Bloomsburg Bloomsburg, PA
Sep 27, 7:30 pm 2019
Friday
Sep 27
7:30 pm
Foreigner
Bloomsburg Fair, Bloomsburg, PA
SELECT * from toolvenuepagelink WHERE venueid = 4152
SELECT * from toolcitypagelink WHERE cityname = 'West Springfield'
Foreigner
Big E Xfinity Arena - Eastern States Exposition West Springfield West Springfield, MA
Sep 29, 7:30 pm 2019
Sunday
Sep 29
7:30 pm
Foreigner
Big E Xfinity Arena - Eastern States Exposition, West Springfield, MA
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football