LISTE POUR : The Aces

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

February

The Aces
Crocodile Cafe Seattle Seattle, WA
Feb 8, 7:00 pm 2019
Friday
Feb 8
7:00 pm
The Aces
Crocodile Cafe, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 27533
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
The Aces
Fortune Sound Club Vancouver Vancouver, Br
Feb 9, 8:00 pm 2019
Saturday
Feb 9
8:00 pm
The Aces
Fortune Sound Club, Vancouver, Br
SELECT * from toolvenuepagelink WHERE venueid = 28088
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
The Aces
Holocene Portland Portland, OR
Feb 10, 7:00 pm 2019
Sunday
Feb 10
7:00 pm
The Aces
Holocene, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 5305
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
The Aces
Rickshaw Stop San Francisco San Francisco, CA
Feb 12, 8:00 pm 2019
Tuesday
Feb 12
8:00 pm
The Aces
Rickshaw Stop, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 1606
SELECT * from toolcitypagelink WHERE cityname = 'West Hollywood'
The Aces
Troubadour West Hollywood West Hollywood, CA
Feb 13, 7:00 pm 2019
Wednesday
Feb 13
7:00 pm
The Aces
Troubadour, West Hollywood, CA
SELECT * from toolvenuepagelink WHERE venueid = 2074
SELECT * from toolcitypagelink WHERE cityname = 'Anaheim'
The Aces
House of Blues - Anaheim Anaheim Anaheim, CA
Feb 15, 7:00 pm 2019
Friday
Feb 15
7:00 pm
The Aces
House of Blues - Anaheim, Anaheim, CA
SELECT * from toolvenuepagelink WHERE venueid = 3493
SELECT * from toolcitypagelink WHERE cityname = 'San Diego'
The Aces
House of Blues - San Diego San Diego San Diego, CA
Feb 16, 7:00 pm 2019
Saturday
Feb 16
7:00 pm
The Aces
House of Blues - San Diego, San Diego, CA
SELECT * from toolvenuepagelink WHERE venueid = 32589
SELECT * from toolcitypagelink WHERE cityname = 'Phoenix'
The Aces
Valley Bar - AZ Phoenix Phoenix, AZ
Feb 17, 8:00 pm 2019
Sunday
Feb 17
8:00 pm
The Aces
Valley Bar - AZ, Phoenix, AZ
SELECT * from toolvenuepagelink WHERE venueid = 4568
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
The Aces
House of Blues - Dallas Dallas Dallas, TX
Feb 19, 8:00 pm 2019
Tuesday
Feb 19
8:00 pm
The Aces
House of Blues - Dallas, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 8118
SELECT * from toolcitypagelink WHERE cityname = 'Austin'
The Aces
Stubbs BBQ Austin Austin, TX
Feb 20, 8:00 pm 2019
Wednesday
Feb 20
8:00 pm
The Aces
Stubbs BBQ, Austin, TX
SELECT * from toolvenuepagelink WHERE venueid = 2483
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
The Aces
Exit/In Nashville Nashville, TN
Feb 22, 9:00 pm 2019
Friday
Feb 22
9:00 pm
The Aces
Exit/In, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 33367
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
The Aces
Aisle 5 Atlanta Atlanta, GA
Feb 23, 9:00 pm 2019
Saturday
Feb 23
9:00 pm
The Aces
Aisle 5, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 3591
SELECT * from toolcitypagelink WHERE cityname = 'Carrboro'
The Aces
Cats Cradle Carrboro Carrboro, NC
Feb 24, 8:00 pm 2019
Sunday
Feb 24
8:00 pm
The Aces
Cats Cradle, Carrboro, NC
SELECT * from toolvenuepagelink WHERE venueid = 33826
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
The Aces
Union Stage Washington Washington, DC
Feb 26, 8:00 pm 2019
Tuesday
Feb 26
8:00 pm
The Aces
Union Stage, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 1822
SELECT * from toolcitypagelink WHERE cityname = 'New York'
The Aces
Bowery Ballroom New York New York, NY
Feb 27, 8:00 pm 2019
Wednesday
Feb 27
8:00 pm
The Aces
Bowery Ballroom, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 1822
SELECT * from toolcitypagelink WHERE cityname = 'New York'
The Aces
Bowery Ballroom New York New York, NY
Feb 28, 8:00 pm 2019
Thursday
Feb 28
8:00 pm
The Aces
Bowery Ballroom, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 32703
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'

March

The Aces
The Foundry - TX Dallas Dallas, TX
Mar 1, 8:00 pm 2019
Friday
Mar 1
8:00 pm
The Aces
The Foundry - TX, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 33879
SELECT * from toolcitypagelink WHERE cityname = 'Cambridge'
The Aces
Sonia Live Music Venue Cambridge Cambridge, MA
Mar 3, 7:00 pm 2019
Sunday
Mar 3
7:00 pm
The Aces
Sonia Live Music Venue, Cambridge, MA
SELECT * from toolvenuepagelink WHERE venueid = 4858
SELECT * from toolcitypagelink WHERE cityname = 'Edmonton'
The Aces
The Velvet Underground Edmonton Edmonton, AB
Mar 5, 7:00 pm 2019
Tuesday
Mar 5
7:00 pm
The Aces
The Velvet Underground, Edmonton, AB
SELECT * from toolvenuepagelink WHERE venueid = 1860
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
The Aces
The Opera House (Toronto) Toronto Toronto, ON
Mar 5, 7:00 pm 2019
Tuesday
Mar 5
7:00 pm
The Aces
The Opera House (Toronto), Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 33149
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
The Aces with Glades
El Club Detroit Detroit, MI
Mar 6, 8:00 pm 2019
Wednesday
Mar 6
8:00 pm
The Aces with Glades
El Club, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 17548
SELECT * from toolcitypagelink WHERE cityname = 'Columbus'
The Aces
A and R Music Bar Columbus Columbus, OH
Mar 8, 7:00 pm 2019
Friday
Mar 8
7:00 pm
The Aces
A and R Music Bar, Columbus, OH
SELECT * from toolvenuepagelink WHERE venueid = 4085
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
The Aces
7th Street Entry Minneapolis Minneapolis, MN
Mar 10, 8:00 pm 2019
Sunday
Mar 10
8:00 pm
The Aces
7th Street Entry, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 6040
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
The Aces
Riot Room Kansas City Kansas City, MO
Mar 13, 8:00 pm 2019
Wednesday
Mar 13
8:00 pm
The Aces
Riot Room, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 9539
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
The Aces
The Complex Salt Lake City Salt Lake City, UT
Mar 16, 7:00 pm 2019
Saturday
Mar 16
7:00 pm
The Aces
The Complex, Salt Lake City, UT
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football