LISTE POUR : Against The Current

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

March

Against The Current
The Masquerade Atlanta Atlanta, GA
Mar 22, 7:00 pm 2019
Friday
Mar 22
7:00 pm
Against The Current
The Masquerade, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 3837
SELECT * from toolcitypagelink WHERE cityname = 'Orlando'
Against The Current
The Social Orlando Orlando, FL
Mar 23, 6:00 pm 2019
Saturday
Mar 23
6:00 pm
Against The Current
The Social, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 8118
SELECT * from toolcitypagelink WHERE cityname = 'Austin'
Against The Current
Stubbs BBQ Austin Austin, TX
Mar 25, 8:00 pm 2019
Monday
Mar 25
8:00 pm
Against The Current
Stubbs BBQ, Austin, TX
SELECT * from toolvenuepagelink WHERE venueid = 32057
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Against The Current
Dada Dallas Dallas Dallas, TX
Mar 26, 9:00 pm 2019
Tuesday
Mar 26
9:00 pm
Against The Current
Dada Dallas, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 32382
SELECT * from toolcitypagelink WHERE cityname = 'Phoeniz'
Against The Current
The Rebel Lounge Phoeniz Phoeniz, AZ
Mar 28, 7:30 pm 2019
Thursday
Mar 28
7:30 pm
Against The Current
The Rebel Lounge, Phoeniz, AZ
SELECT * from toolvenuepagelink WHERE venueid = 28160
SELECT * from toolcitypagelink WHERE cityname = 'San Diego'
Against The Current
The Irenic San Diego San Diego, CA
Mar 29, 6:30 pm 2019
Friday
Mar 29
6:30 pm
Against The Current
The Irenic, San Diego, CA
SELECT * from toolvenuepagelink WHERE venueid = 1606
SELECT * from toolcitypagelink WHERE cityname = 'West Hollywood'
Against The Current
Troubadour West Hollywood West Hollywood, CA
Mar 30, 7:00 pm 2019
Saturday
Mar 30
7:00 pm
Against The Current
Troubadour, West Hollywood, CA
SELECT * from toolvenuepagelink WHERE venueid = 1803
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Against The Current
Slim's San Francisco San Francisco, CA
Mar 31, 7:30 pm 2019
Sunday
Mar 31
7:30 pm
Against The Current
Slim's, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 28088
SELECT * from toolcitypagelink WHERE cityname = 'Portland'

April

Against The Current
Holocene Portland Portland, OR
Apr 2, 7:00 pm 2019
Tuesday
Apr 2
7:00 pm
Against The Current
Holocene, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 4275
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Against The Current
Chop Suey Seattle Seattle, WA
Apr 4, 7:00 pm 2019
Thursday
Apr 4
7:00 pm
Against The Current
Chop Suey, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 3541
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
Against The Current
In The Venue Salt Lake City Salt Lake City, UT
Apr 6, 7:00 pm 2019
Saturday
Apr 6
7:00 pm
Against The Current
In The Venue, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 159
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Against The Current
Bluebird Theater Denver Denver, CO
Apr 7, 8:00 pm 2019
Sunday
Apr 7
8:00 pm
Against The Current
Bluebird Theater, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 28883
SELECT * from toolcitypagelink WHERE cityname = 'Saint Paul'
Against the Current
Amsterdam Bar and Hall Saint Paul Saint Paul, MN
Apr 9, 6:30 pm 2019
Tuesday
Apr 9
6:30 pm
Against the Current
Amsterdam Bar and Hall, Saint Paul, MN
SELECT * from toolvenuepagelink WHERE venueid = 33753
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Against The Current
1st Ward at Chop Shop Chicago Chicago, IL
Apr 10, 6:45 pm 2019
Wednesday
Apr 10
6:45 pm
Against The Current
1st Ward at Chop Shop, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 5102
SELECT * from toolcitypagelink WHERE cityname = 'Pontiac'
Against The Current
The Crofoot Ballroom Pontiac Pontiac, MI
Apr 12, 6:30 pm 2019
Friday
Apr 12
6:30 pm
Against The Current
The Crofoot Ballroom, Pontiac, MI
SELECT * from toolvenuepagelink WHERE venueid = 4858
SELECT * from toolcitypagelink WHERE cityname = 'Edmonton'
Against The Current
The Velvet Underground Edmonton Edmonton, AB
Apr 13, 6:00 pm 2019
Saturday
Apr 13
6:00 pm
Against The Current
The Velvet Underground, Edmonton, AB
SELECT * from toolvenuepagelink WHERE venueid = 18120
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Against The Current
L'Astral Montreal Montreal, QC
Apr 14, 8:00 pm 2019
Sunday
Apr 14
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 4533
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Against The Current
Gramercy Theatre New York New York, NY
Apr 17, 8:00 pm 2019
Wednesday
Apr 17
8:00 pm
Against The Current
Gramercy Theatre, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 7686
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Against The Current
Brighton Music Hall Boston Boston, MA
Apr 18, 7:00 pm 2019
Thursday
Apr 18
7:00 pm
Against The Current
Brighton Music Hall, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 4715
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
Against The Current
World Cafe Live Philadelphia Philadelphia, PA
Apr 19, 8:00 pm 2019
Friday
Apr 19
8:00 pm
Against The Current
World Cafe Live, Philadelphia, PA
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football