LISTE POUR : Mandolin Orange

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

April

Mandolin Orange
Variety Playhouse Atlanta Atlanta, GA
Apr 4, 8:00 pm 2019
Thursday
Apr 4
8:00 pm
Mandolin Orange
Variety Playhouse, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 32290
SELECT * from toolcitypagelink WHERE cityname = 'Birmingham'
Mandolin Orange
Saturn Birmingham Birmingham, AL
Apr 5, 9:00 pm 2019
Friday
Apr 5
9:00 pm
Mandolin Orange
Saturn, Birmingham, AL
SELECT * from toolvenuepagelink WHERE venueid = 17789
SELECT * from toolcitypagelink WHERE cityname = 'Jackson'
Mandolin Orange
Duling Hall Jackson Jackson, MS
Apr 6, 9:00 pm 2019
Saturday
Apr 6
9:00 pm
Mandolin Orange
Duling Hall, Jackson, MS
SELECT * from toolvenuepagelink WHERE venueid = 32740
SELECT * from toolcitypagelink WHERE cityname = 'Memphis'
Mandolin Orange
1884 Lounge Memphis Memphis, TN
Apr 7, 8:00 pm 2019
Sunday
Apr 7
8:00 pm
Mandolin Orange
1884 Lounge, Memphis, TN
SELECT * from toolvenuepagelink WHERE venueid = 1862
SELECT * from toolcitypagelink WHERE cityname = 'St Louis'
Mandolin Orange
Delmar Hall St Louis St Louis, MO
Apr 9, 8:00 pm 2019
Tuesday
Apr 9
8:00 pm
Mandolin Orange
Delmar Hall, St Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 5161
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Mandolin Orange
Madrid Theatre Kansas City Kansas City, MO
Apr 10, 9:00 pm 2019
Wednesday
Apr 10
9:00 pm
Mandolin Orange
Madrid Theatre, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 32869
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Mandolin Orange
Tower Theatre Los Angeles Los Angeles, CA
Apr 14, 8:00 pm 2019
Sunday
Apr 14
8:00 pm
Mandolin Orange
Tower Theatre, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 1529
SELECT * from toolcitypagelink WHERE cityname = 'Cincinnati'
Mandolin Orange
Taft Theatre Cincinnati Cincinnati, OH
Apr 16, 8:00 pm 2019
Tuesday
Apr 16
8:00 pm
Mandolin Orange
Taft Theatre, Cincinnati, OH
SELECT * from toolvenuepagelink WHERE venueid = 4276
SELECT * from toolcitypagelink WHERE cityname = 'Louisville'
Mandolin Orange
Headliners Music Hall Louisville Louisville, KY
Apr 17, 8:00 pm 2019
Wednesday
Apr 17
8:00 pm
Mandolin Orange
Headliners Music Hall, Louisville, KY
SELECT * from toolvenuepagelink WHERE venueid = 33610
SELECT * from toolcitypagelink WHERE cityname = 'Chattanooga'
Mandolin Orange
The Walker Theatre Chattanooga Chattanooga, TN
Apr 18, 8:00 pm 2019
Thursday
Apr 18
8:00 pm
Mandolin Orange
The Walker Theatre, Chattanooga, TN
SELECT * from toolvenuepagelink WHERE venueid = 3033
SELECT * from toolcitypagelink WHERE cityname = 'Knoxville'
Mandolin Orange
Bijou Theatre Knoxville Knoxville, TN
Apr 20, 8:00 pm 2019
Saturday
Apr 20
8:00 pm
Mandolin Orange
Bijou Theatre, Knoxville, TN
SELECT * from toolvenuepagelink WHERE venueid = 1366
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'

September

Mandolin Orange
Ryman Auditorium Nashville Nashville, TN
Sep 7, 8:00 pm 2019
Saturday
Sep 7
8:00 pm
Mandolin Orange
Ryman Auditorium, Nashville, TN
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football