LISTE POUR : Rival Sons

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

April

Rival Sons
Trees Dallas Dallas, TX
Apr 4, 8:00 pm 2019
Thursday
Apr 4
8:00 pm
Rival Sons
Trees, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 216
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
Rival Sons
Cannery Ballroom Nashville Nashville, TN
Apr 6, 8:00 pm 2019
Saturday
Apr 6
8:00 pm
Rival Sons
Cannery Ballroom, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 3591
SELECT * from toolcitypagelink WHERE cityname = 'Carrboro'
Rival Sons
Cats Cradle Carrboro Carrboro, NC
Apr 8, 8:00 pm 2019
Monday
Apr 8
8:00 pm
Rival Sons
Cats Cradle, Carrboro, NC
SELECT * from toolvenuepagelink WHERE venueid = 1972
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Rival Sons
Kennys Alley Atlanta Atlanta, GA
Apr 9, 7:00 pm 2019
Tuesday
Apr 9
7:00 pm
Rival Sons
Kennys Alley, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 4089
SELECT * from toolcitypagelink WHERE cityname = 'Asheville'
Rival Sons
The Orange Peel Asheville Asheville, NC
Apr 10, 8:00 pm 2019
Wednesday
Apr 10
8:00 pm
Rival Sons
The Orange Peel, Asheville, NC
SELECT * from toolvenuepagelink WHERE venueid = 2716
SELECT * from toolcitypagelink WHERE cityname = 'Orlando'
Rival Sons
Central Florida Fairgrounds Orlando Orlando, FL
Apr 13, 7:00 pm 2019
Saturday
Apr 13
7:00 pm
Rival Sons
Central Florida Fairgrounds, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 7916
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
Rival Sons
Union Transfer Philadelphia Philadelphia, PA
Apr 17, 8:00 pm 2019
Wednesday
Apr 17
8:00 pm
Rival Sons
Union Transfer, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 3427
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Rival Sons
Royale Boston Boston Boston, MA
Apr 18, 8:00 pm 2019
Thursday
Apr 18
8:00 pm
Rival Sons
Royale Boston, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 2992
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Rival Sons
Danforth Music Hall Toronto Toronto, ON
Apr 19, 7:00 pm 2019
Friday
Apr 19
7:00 pm
Rival Sons
Danforth Music Hall, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 33405
SELECT * from toolcitypagelink WHERE cityname = 'Brooklyn'
Rival Sons with The Sheepdogs
Brooklyn Steel Brooklyn Brooklyn, NY
Apr 21, 8:00 pm 2019
Sunday
Apr 21
8:00 pm
Rival Sons with The Sheepdogs
Brooklyn Steel, Brooklyn, NY
SELECT * from toolvenuepagelink WHERE venueid = 1959
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Rival Sons
9:30 Club Washington Washington, DC
Apr 22, 7:00 pm 2019
Monday
Apr 22
7:00 pm
Rival Sons
9:30 Club, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 1490
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
Rival Sons
The Fillmore Detroit Detroit Detroit, MI
Apr 23, 7:00 pm 2019
Tuesday
Apr 23
7:00 pm
Rival Sons
The Fillmore Detroit, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 496
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
Rival Sons
First Avenue Minneapolis Minneapolis, MN
Apr 25, 7:00 pm 2019
Thursday
Apr 25
7:00 pm
Rival Sons
First Avenue, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 680
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Rival Sons
House of Blues - Chicago Chicago Chicago, IL
Apr 26, 7:00 pm 2019
Friday
Apr 26
7:00 pm
Rival Sons
House of Blues - Chicago, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 14732
SELECT * from toolcitypagelink WHERE cityname = 'Lincoln'
Rival Sons
Bourbon Theatre Lincoln Lincoln, NE
Apr 27, 7:00 pm 2019
Saturday
Apr 27
7:00 pm
Rival Sons
Bourbon Theatre, Lincoln, NE
SELECT * from toolvenuepagelink WHERE venueid = 2040
SELECT * from toolcitypagelink WHERE cityname = 'Englewood'
Rival Sons
Gothic Theatre Englewood Englewood, CO
Apr 29, 8:00 pm 2019
Monday
Apr 29
8:00 pm
Rival Sons
Gothic Theatre, Englewood, CO
SELECT * from toolvenuepagelink WHERE venueid = 33877
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
Rival Sons
The Commonwealth Room Salt Lake City Salt Lake City, UT
Apr 30, 7:00 pm 2019
Tuesday
Apr 30
7:00 pm
Rival Sons
The Commonwealth Room, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 7836
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'

May

Rival Sons
The Neptune Theatre Seattle Seattle, WA
May 2, 8:00 pm 2019
Thursday
May 2
8:00 pm
Rival Sons
The Neptune Theatre, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 4059
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Rival Sons
Wonder Ballroom Portland Portland, OR
May 3, 8:00 pm 2019
Friday
May 3
8:00 pm
Rival Sons
Wonder Ballroom, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 1692
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Rival Sons
Vogue Theatre Vancouver Vancouver, BC
May 4, 7:00 pm 2019
Saturday
May 4
7:00 pm
Rival Sons
Vogue Theatre, Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 9556
SELECT * from toolcitypagelink WHERE cityname = 'Sacramento'
Rival Sons
Ace of Spades Sacramento Sacramento, CA
May 6, 7:00 pm 2019
Monday
May 6
7:00 pm
Rival Sons
Ace of Spades, Sacramento, CA
SELECT * from toolvenuepagelink WHERE venueid = 492
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Rival Sons
The Fillmore - San Francisco San Francisco San Francisco, CA
May 7, 7:00 pm 2019
Tuesday
May 7
7:00 pm
Rival Sons
The Fillmore - San Francisco, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 651
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'
Rival Sons
Henry Fonda Theatre Los Angeles Los Angeles, CA
May 9, 8:00 pm 2019
Thursday
May 9
8:00 pm
Rival Sons
Henry Fonda Theatre, Los Angeles, CA
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football