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 = 30158
SELECT * from toolcitypagelink WHERE cityname = 'Paso Robles'

June

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 = 1956
SELECT * from toolcitypagelink WHERE cityname = 'Saratoga'
Foreigner
Mountain Winery Saratoga Saratoga, CA
Jun 15, 7:30 pm 2019
Saturday
Jun 15
7:30 pm
Foreigner
Mountain Winery, Saratoga, 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 = 477
SELECT * from toolcitypagelink WHERE cityname = 'St Charles'
Foreigner
Family Arena St Charles St Charles, MO
Jun 25, 7:30 pm 2019
Tuesday
Jun 25
7:30 pm
Foreigner
Family Arena, St Charles, MO
SELECT * from toolvenuepagelink WHERE venueid = 28787
SELECT * from toolcitypagelink WHERE cityname = 'Milwaukee'
Foreigner
BMO Harris Pavilion Milwaukee Milwaukee, WI
Jun 26, 8:00 pm 2019
Wednesday
Jun 26
8:00 pm
Foreigner
BMO Harris Pavilion, Milwaukee, WI
SELECT * from toolvenuepagelink WHERE venueid = 25910
SELECT * from toolcitypagelink WHERE cityname = 'Grand Rapids'

August

Foreigner
Frederik Meijer Gardens Grand Rapids Grand Rapids, MI
Aug 11, 7:00 pm 2019
Sunday
Aug 11
7:00 pm
Foreigner
Frederik Meijer Gardens, Grand Rapids, MI
SELECT * from toolvenuepagelink WHERE venueid = 32170
SELECT * from toolcitypagelink WHERE cityname = 'Huber Heights'
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 = 10959
SELECT * from toolcitypagelink WHERE cityname = 'Rama'
Foreigner
Casino Rama Rama Rama, ON
Aug 29, 8:00 pm 2019
Thursday
Aug 29
8:00 pm
Foreigner
Casino Rama, Rama, ON
SELECT * from toolvenuepagelink WHERE venueid = 10959
SELECT * from toolcitypagelink WHERE cityname = 'Rama'
Foreigner
Casino Rama Rama Rama, ON
Aug 30, 9:00 pm 2019
Friday
Aug 30
9:00 pm
Foreigner
Casino Rama, Rama, ON
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 = 33517
SELECT * from toolcitypagelink WHERE cityname = 'Bonner-West Riverside'
Foreigner
KettleHouse Amphitheater Bonner-West Riverside Bonner-West Riverside, MT
Sep 9, 8:00 pm 2019
Monday
Sep 9
8:00 pm
Foreigner
KettleHouse Amphitheater, Bonner-West Riverside, MT
SELECT * from toolvenuepagelink WHERE venueid = 6633
SELECT * from toolcitypagelink WHERE cityname = 'Boise'
Foreigner
Idaho Botanical Garden Boise Boise, ID
Sep 12, 7:00 pm 2019
Thursday
Sep 12
7:00 pm
Foreigner
Idaho Botanical Garden, Boise, ID
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
SELECT * from toolvenuepagelink WHERE venueid = 2061
SELECT * from toolcitypagelink WHERE cityname = 'Uncasville'

October

Foreigner
Mohegan Sun Arena Uncasville Uncasville, CT
Oct 3, 7:30 pm 2019
Thursday
Oct 3
7:30 pm
Foreigner
Mohegan Sun Arena, Uncasville, CT
SELECT * from toolvenuepagelink WHERE venueid = 1610
SELECT * from toolcitypagelink WHERE cityname = 'Atlantic City'
Foreigner
Etess Arena at Hard Rock Hotel and Casino Atlantic City Atlantic City, NJ
Oct 4, 8:00 pm 2019
Friday
Oct 4
8:00 pm
Foreigner
Etess Arena at Hard Rock Hotel and Casino, Atlantic City, NJ
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football