LISTE POUR : Com Truise

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

March

Com Truise with Jack Grace
1720 LA Los Angeles Los Angeles, CA
Mar 22, 9:00 pm 2019
Friday
Mar 22
9:00 pm
Com Truise with Jack Grace
1720 LA, Los Angeles, CA
SELECT * from toolvenuepagelink WHERE venueid = 1926
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Com Truise
Great American Music Hall San Francisco San Francisco, CA
Mar 23, 9:00 pm 2019
Saturday
Mar 23
9:00 pm
Com Truise
Great American Music Hall, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 3555
SELECT * from toolcitypagelink WHERE cityname = 'Raleigh'
Com Truise
The Ritz Raleigh Raleigh, NC
Mar 24, 7:00 pm 2019
Sunday
Mar 24
7:00 pm
Com Truise
The Ritz, Raleigh, NC
SELECT * from toolvenuepagelink WHERE venueid = 6292
SELECT * from toolcitypagelink WHERE cityname = 'Sacramento'
Com Truise
Harlows Night Club Sacramento Sacramento, CA
Mar 25, 8:00 pm 2019
Monday
Mar 25
8:00 pm
Com Truise
Harlows Night Club, Sacramento, CA
SELECT * from toolvenuepagelink WHERE venueid = 5108
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Com Truise with Jack Grace
Doug Fir Lounge Portland Portland, OR
Mar 27, 9:00 pm 2019
Wednesday
Mar 27
9:00 pm
Com Truise with Jack Grace
Doug Fir Lounge, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 4336
SELECT * from toolcitypagelink WHERE cityname = 'Seattle'
Com Truise
Neumos Seattle Seattle, WA
Mar 29, 8:00 pm 2019
Friday
Mar 29
8:00 pm
Com Truise
Neumos, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 493
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'

April

Com Truise
Fine Line Music Cafe Minneapolis Minneapolis, MN
Apr 2, 8:00 pm 2019
Tuesday
Apr 2
8:00 pm
Com Truise
Fine Line Music Cafe, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 3142
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Com Truise
Mod Club Theatre Toronto Toronto, ON
Apr 4, 9:00 pm 2019
Thursday
Apr 4
9:00 pm
Com Truise
Mod Club Theatre, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 32982
SELECT * from toolcitypagelink WHERE cityname = 'Montréal'
Com Truise
Theatre Fairmount Montréal Montréal, QC
Apr 5, 9:00 pm 2019
Friday
Apr 5
9:00 pm
Com Truise
Theatre Fairmount, Montréal, QC
SELECT * from toolvenuepagelink WHERE venueid = 7686
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Com Truise
Brighton Music Hall Boston Boston, MA
Apr 6, 8:00 pm 2019
Saturday
Apr 6
8:00 pm
Com Truise
Brighton Music Hall, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 32703
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Com Truise
The Foundry - TX Dallas Dallas, TX
Apr 10, 8:00 pm 2019
Wednesday
Apr 10
8:00 pm
Com Truise
The Foundry - TX, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 33842
SELECT * from toolcitypagelink WHERE cityname = 'Brooklyn'
Com Truise
Elsewhere Brooklyn Brooklyn, NY
Apr 11, 8:00 pm 2019
Thursday
Apr 11
8:00 pm
Com Truise
Elsewhere, Brooklyn, NY
SELECT * from toolvenuepagelink WHERE venueid = 33826
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Com Truise
Union Stage Washington Washington, DC
Apr 12, 8:00 pm 2019
Friday
Apr 12
8:00 pm
Com Truise
Union Stage, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 4915
SELECT * from toolcitypagelink WHERE cityname = 'Baltimore'
Com Truise
Ottobar Baltimore Baltimore, MD
Apr 13, 9:00 pm 2019
Saturday
Apr 13
9:00 pm
Com Truise
Ottobar, Baltimore, MD
SELECT * from toolvenuepagelink WHERE venueid = 3762
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
Com Truise
Warehouse Live Houston Houston, TX
Apr 18, 9:00 pm 2019
Thursday
Apr 18
9:00 pm
Com Truise
Warehouse Live, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 33807
SELECT * from toolcitypagelink WHERE cityname = 'Austin'
Com Truise
Barracuda Austin Austin, TX
Apr 19, 9:00 pm 2019
Friday
Apr 19
9:00 pm
Com Truise
Barracuda, Austin, TX
SELECT * from toolvenuepagelink WHERE venueid = 1600
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Com Truise with Jack Grace
Trees Dallas Dallas, TX
Apr 21, 8:00 pm 2019
Sunday
Apr 21
8:00 pm
Com Truise with Jack Grace
Trees, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 2040
SELECT * from toolcitypagelink WHERE cityname = 'Englewood'
Com Truise with Jack Grace
Gothic Theatre Englewood Englewood, CO
Apr 23, 8:00 pm 2019
Tuesday
Apr 23
8:00 pm
Com Truise with Jack Grace
Gothic Theatre, Englewood, CO
SELECT * from toolvenuepagelink WHERE venueid = 33558
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'
Com Truise with Jack Grace
Metro Music Hall Salt Lake City Salt Lake City, UT
Apr 24, 8:00 pm 2019
Wednesday
Apr 24
8:00 pm
Com Truise with Jack Grace
Metro Music Hall, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 28863
SELECT * from toolcitypagelink WHERE cityname = 'Phoenix'
Com Truise
Crescent Ballroom - AZ Phoenix Phoenix, AZ
Apr 26, 8:00 pm 2019
Friday
Apr 26
8:00 pm
Com Truise
Crescent Ballroom - AZ, Phoenix, AZ
SELECT * from toolvenuepagelink WHERE venueid = 7114
SELECT * from toolcitypagelink WHERE cityname = 'San Diego'
Com Truise
Music Box - San Diego San Diego San Diego, CA
Apr 27, 9:00 pm 2019
Saturday
Apr 27
9:00 pm
Com Truise
Music Box - San Diego, San Diego, 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