LISTE POUR : VHS Collection

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

February

VHS Collection
The High Watt Nashville Nashville, TN
Feb 12, 9:00 pm 2019
Tuesday
Feb 12
9:00 pm
VHS Collection
The High Watt, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 33367
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
VHS Collection
Aisle 5 Atlanta Atlanta, GA
Feb 15, 9:00 pm 2019
Friday
Feb 15
9:00 pm
VHS Collection
Aisle 5, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 28227
SELECT * from toolcitypagelink WHERE cityname = 'Gainesville'
VHS Collection
Double Down Live Gainesville Gainesville, FL
Feb 16, 9:30 pm 2019
Saturday
Feb 16
9:30 pm
VHS Collection
Double Down Live, Gainesville, FL
SELECT * from toolvenuepagelink WHERE venueid = 8118
SELECT * from toolcitypagelink WHERE cityname = 'Austin'
VHS Collection
Stubbs BBQ Austin Austin, TX
Feb 21, 9:00 pm 2019
Thursday
Feb 21
9:00 pm
VHS Collection
Stubbs BBQ, Austin, TX
SELECT * from toolvenuepagelink WHERE venueid = 5679
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
VHS Collection
House of Blues - Houston Houston Houston, TX
Feb 22, 7:00 pm 2019
Friday
Feb 22
7:00 pm
VHS Collection
House of Blues - Houston, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 32057
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
VHS Collection
Dada Dallas Dallas Dallas, TX
Feb 23, 9:00 pm 2019
Saturday
Feb 23
9:00 pm
VHS Collection
Dada Dallas, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 32589
SELECT * from toolcitypagelink WHERE cityname = 'Phoenix'
VHS Collection
Valley Bar - AZ Phoenix Phoenix, AZ
Feb 26, 8:00 pm 2019
Tuesday
Feb 26
8:00 pm
VHS Collection
Valley Bar - AZ, Phoenix, AZ
SELECT * from toolvenuepagelink WHERE venueid = 546
SELECT * from toolcitypagelink WHERE cityname = 'Santa Ana'
VHS Collection
The Observatory Santa Ana Santa Ana, CA
Feb 28, 9:00 pm 2019
Thursday
Feb 28
9:00 pm
VHS Collection
The Observatory, Santa Ana, CA
SELECT * from toolvenuepagelink WHERE venueid = 4750
SELECT * from toolcitypagelink WHERE cityname = 'Los Angeles'

March

VHS Collection
Echoplex Los Angeles Los Angeles, CA
Mar 1, 8:30 pm 2019
Friday
Mar 1
8:30 pm
VHS Collection
Echoplex, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 3365
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
VHS Collection
The Independent San Francisco San Francisco, CA
Mar 2, 9:00 pm 2019
Saturday
Mar 2
9:00 pm
VHS Collection
The Independent, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 28088
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
VHS Collection
Holocene Portland Portland, OR
Mar 4, 9:00 pm 2019
Monday
Mar 4
9:00 pm
VHS Collection
Holocene, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 32127
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
VHS Collection
The Barboza Seattle Seattle, WA
Mar 6, 7:00 pm 2019
Wednesday
Mar 6
7:00 pm
VHS Collection
The Barboza, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 5188
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
VHS Collection
Urban Lounge Salt Lake City Salt Lake City, UT
Mar 8, 8:00 pm 2019
Friday
Mar 8
8:00 pm
VHS Collection
Urban Lounge, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 4085
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
VHS Collection
7th Street Entry Minneapolis Minneapolis, MN
Mar 13, 8:00 pm 2019
Wednesday
Mar 13
8:00 pm
VHS Collection
7th Street Entry, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 2164
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
VHS Collection
Metro Smart Bar Chicago Chicago, IL
Mar 14, 7:00 pm 2019
Thursday
Mar 14
7:00 pm
VHS Collection
Metro Smart Bar, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 610
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
VHS Collection
Grog Shop Cleveland Cleveland, OH
Mar 15, 9:00 pm 2019
Friday
Mar 15
9:00 pm
VHS Collection
Grog Shop, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 32734
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
VHS Collection
Adelaide Hall Toronto Toronto, ON
Mar 16, 7:30 pm 2019
Saturday
Mar 16
7:30 pm
VHS Collection
Adelaide Hall, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 725
SELECT * from toolcitypagelink WHERE cityname = 'New York'
VHS Collection
Irving Plaza New York New York, NY
Mar 23, 8:00 pm 2019
Saturday
Mar 23
8:00 pm
VHS Collection
Irving Plaza, New York, NY
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football