LISTE POUR : Mestis

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

March

Mestis with Plini
Slim's San Francisco San Francisco, CA
Mar 27, 8:00 pm 2019
Wednesday
Mar 27
8:00 pm
Mestis with Plini
Slim's, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 3541
SELECT * from toolcitypagelink WHERE cityname = 'Salt Lake City'

April

Mestis with Plini
In The Venue Salt Lake City Salt Lake City, UT
Apr 2, 7:00 pm 2019
Tuesday
Apr 2
7:00 pm
Mestis with Plini
In The Venue, Salt Lake City, UT
SELECT * from toolvenuepagelink WHERE venueid = 159
SELECT * from toolcitypagelink WHERE cityname = 'Denver'
Mestis with Plini
Bluebird Theater Denver Denver, CO
Apr 3, 8:00 pm 2019
Wednesday
Apr 3
8:00 pm
Mestis with Plini
Bluebird Theater, Denver, CO
SELECT * from toolvenuepagelink WHERE venueid = 3964
SELECT * from toolcitypagelink WHERE cityname = 'Lawrence'
Mestis with Plini
Bottleneck Lawrence Lawrence, KS
Apr 5, 8:00 pm 2019
Friday
Apr 5
8:00 pm
Mestis with Plini
Bottleneck, Lawrence, KS
SELECT * from toolvenuepagelink WHERE venueid = 28883
SELECT * from toolcitypagelink WHERE cityname = 'Saint Paul'
Mestis with Plini
Amsterdam Bar and Hall Saint Paul Saint Paul, MN
Apr 6, 8:00 pm 2019
Saturday
Apr 6
8:00 pm
Mestis with Plini
Amsterdam Bar and Hall, Saint Paul, MN
SELECT * from toolvenuepagelink WHERE venueid = 3142
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Mestis with Plini
Mod Club Theatre Toronto Toronto, ON
Apr 10, 7:00 pm 2019
Wednesday
Apr 10
7:00 pm
Mestis with Plini
Mod Club Theatre, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 1822
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Mestis with Plini
Bowery Ballroom New York New York, NY
Apr 12, 8:00 pm 2019
Friday
Apr 12
8:00 pm
Mestis with Plini
Bowery Ballroom, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 7916
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
Mestis with Plini
Union Transfer Philadelphia Philadelphia, PA
Apr 13, 8:30 pm 2019
Saturday
Apr 13
8:30 pm
Mestis with Plini
Union Transfer, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 31549
SELECT * from toolcitypagelink WHERE cityname = 'Cambridge'
Mestis with Plini
The Sinclair Cambridge Cambridge, MA
Apr 14, 8:00 pm 2019
Sunday
Apr 14
8:00 pm
Mestis with Plini
The Sinclair, Cambridge, MA
SELECT * from toolvenuepagelink WHERE venueid = 25883
SELECT * from toolcitypagelink WHERE cityname = 'Richmond'
Mestis with Plini
Canal Club Richmond Richmond, VA
Apr 16, 7:00 pm 2019
Tuesday
Apr 16
7:00 pm
Mestis with Plini
Canal Club, Richmond, VA
SELECT * from toolvenuepagelink WHERE venueid = 1600
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Mestis with Plini
Trees Dallas Dallas, TX
Apr 23, 8:00 pm 2019
Tuesday
Apr 23
8:00 pm
Mestis with Plini
Trees, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 5033
SELECT * from toolcitypagelink WHERE cityname = 'Mesa'
Mestis with Plini
Club Red Mesa Mesa, AZ
Apr 26, 8:00 pm 2019
Friday
Apr 26
8:00 pm
Mestis with Plini
Club Red, Mesa, AZ
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football