LISTE POUR : Coin

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

February

COIN
The Beacham Orlando Orlando, FL
Feb 5, 7:00 pm 2019
Tuesday
Feb 5
7:00 pm
COIN
The Beacham, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 7465
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Coin
Buckhead Theatre Atlanta Atlanta, GA
Feb 6, 8:00 pm 2019
Wednesday
Feb 6
8:00 pm
Coin
Buckhead Theatre, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 1959
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Coin
9:30 Club Washington Washington, DC
Feb 8, 6:00 pm 2019
Friday
Feb 8
6:00 pm
Coin
9:30 Club, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 725
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Coin
Irving Plaza New York New York, NY
Feb 9, 8:00 pm 2019
Saturday
Feb 9
8:00 pm
Coin
Irving Plaza, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 2254
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Coin
Paradise Rock Club Boston Boston, MA
Feb 10, 7:00 pm 2019
Sunday
Feb 10
7:00 pm
Coin
Paradise Rock Club, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 1860
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Coin
The Opera House (Toronto) Toronto Toronto, ON
Feb 12, 8:00 pm 2019
Tuesday
Feb 12
8:00 pm
Coin
The Opera House (Toronto), Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 1110
SELECT * from toolcitypagelink WHERE cityname = 'Columbus'
Coin
Newport Music Hall Columbus Columbus, OH
Feb 15, 7:00 pm 2019
Friday
Feb 15
7:00 pm
Coin
Newport Music Hall, Columbus, OH
SELECT * from toolvenuepagelink WHERE venueid = 4568
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Coin
House of Blues - Dallas Dallas Dallas, TX
Feb 17, 7:00 pm 2019
Sunday
Feb 17
7:00 pm
Coin
House of Blues - Dallas, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 3946
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
Coin
The Depot Salt Lake City Salt Lake City, UT
Feb 20, 7:00 pm 2019
Wednesday
Feb 20
7:00 pm
Coin
The Depot, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 1419
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
COIN
The Showbox Seattle Seattle, WA
Feb 23, 9:00 pm 2019
Saturday
Feb 23
9:00 pm
COIN
The Showbox, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 6919
SELECT * from toolcitypagelink WHERE cityname = 'Vancouver'
Coin
Venue-BC Vancouver Vancouver, BC
Feb 24, 8:00 pm 2019
Sunday
Feb 24
8:00 pm
Coin
Venue-BC, Vancouver, BC
SELECT * from toolvenuepagelink WHERE venueid = 492
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
COIN
The Fillmore - San Francisco San Francisco San Francisco, CA
Feb 27, 8:00 pm 2019
Wednesday
Feb 27
8:00 pm
COIN
The Fillmore - San Francisco, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 1752
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'

March

COIN
Wiltern Theatre Los Angeles Los Angeles, CA
Mar 1, 7:00 pm 2019
Friday
Mar 1
7:00 pm
COIN
Wiltern 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