LISTE POUR : Snails

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

November

Snails
House of Blues - Orlando Orlando Orlando, FL
Nov 16, 8:30 pm 2018
Friday
Nov 16
8:30 pm
Snails
House of Blues - Orlando, Orlando, FL
SELECT * from toolvenuepagelink WHERE venueid = 821
SELECT * from toolcitypagelink WHERE cityname = 'Lancaster'
Snails with Cookie Monsta
The Hangar Lancaster Lancaster, CA
Nov 17, 9:00 pm 2018
Saturday
Nov 17
9:00 pm
Snails with Cookie Monsta
The Hangar, Lancaster, CA
SELECT * from toolvenuepagelink WHERE venueid = 5960
SELECT * from toolcitypagelink WHERE cityname = 'Syracuse'
Cookie Monsta
Westcott Theatre Syracuse Syracuse, NY
Nov 20, 8:00 pm 2018
Tuesday
Nov 20
8:00 pm
Cookie Monsta
Westcott Theatre, Syracuse, NY
SELECT * from toolvenuepagelink WHERE venueid = 7725
SELECT * from toolcitypagelink WHERE cityname = 'Pittsburgh'
Snails
Stage AE Pittsburgh Pittsburgh, PA
Nov 21, 7:00 pm 2018
Wednesday
Nov 21
7:00 pm
Snails
Stage AE, Pittsburgh, PA
SELECT * from toolvenuepagelink WHERE venueid = 33659
SELECT * from toolcitypagelink WHERE cityname = 'Ville-Marie, Montréal'
Snails
MTELUS Ville-Marie, Montréal Ville-Marie, Montréal, QC
Nov 23, 10:00 pm 2018
Friday
Nov 23
10:00 pm
Snails
MTELUS, Ville-Marie, Montréal, QC
SELECT * from toolvenuepagelink WHERE venueid = 2823
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Snails with Cookie Monsta
Metropolis Montreal Montreal, QC
Nov 23, 10:00 pm 2018
Friday
Nov 23
10:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 2992
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Snails
Danforth Music Hall Toronto Toronto, ON
Nov 24, 7:00 pm 2018
Saturday
Nov 24
7:00 pm
Snails
Danforth Music Hall, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 2007
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Snails with Cookie Monsta
State Theater (Portland - ME) Portland Portland, ME
Nov 26, 8:00 pm 2018
Monday
Nov 26
8:00 pm
Snails with Cookie Monsta
State Theater (Portland - ME), Portland, ME
SELECT * from toolvenuepagelink WHERE venueid = 4492
SELECT * from toolcitypagelink WHERE cityname = 'Buffalo'
Snails with Liquid Stranger
Town Ballroom Buffalo Buffalo, NY
Nov 28, 8:00 pm 2018
Wednesday
Nov 28
8:00 pm
Snails with Liquid Stranger
Town Ballroom, Buffalo, NY
SELECT * from toolvenuepagelink WHERE venueid = 6064
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Snails
House of Blues - Boston Boston Boston, MA
Nov 29, 8:00 pm 2018
Thursday
Nov 29
8:00 pm
Snails
House of Blues - Boston, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 10642
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Snails
Echostage at Glow Washington Washington, DC
Nov 30, 8:00 pm 2018
Friday
Nov 30
8:00 pm
Snails
Echostage at Glow, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 4954
SELECT * from toolcitypagelink WHERE cityname = 'New York'

December

Snails with Liquid Stranger
Terminal 5 New York New York, NY
Dec 1, 8:00 pm 2018
Saturday
Dec 1
8:00 pm
Snails with Liquid Stranger
Terminal 5, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 29912
SELECT * from toolcitypagelink WHERE cityname = 'Columbus'
Snails
The Bluestone Columbus Columbus, OH
Dec 2, 8:00 pm 2018
Sunday
Dec 2
8:00 pm
Snails
The Bluestone, Columbus, OH
SELECT * from toolvenuepagelink WHERE venueid = 30531
SELECT * from toolcitypagelink WHERE cityname = 'Louisville'
Snails
Mercury Ballroom Louisville Louisville, KY
Dec 3, 8:00 pm 2018
Monday
Dec 3
8:00 pm
Snails
Mercury Ballroom, Louisville, KY
SELECT * from toolvenuepagelink WHERE venueid = 1857
SELECT * from toolcitypagelink WHERE cityname = 'Cincinnati'
Snails
Bogarts Cincinnati Cincinnati, OH
Dec 4, 7:00 pm 2018
Tuesday
Dec 4
7:00 pm
Snails
Bogarts, Cincinnati, OH
SELECT * from toolvenuepagelink WHERE venueid = 720
SELECT * from toolcitypagelink WHERE cityname = 'Grand Rapids'
Snails
Intersection Grand Rapids Grand Rapids, MI
Dec 5, 8:00 pm 2018
Wednesday
Dec 5
8:00 pm
Snails
Intersection, Grand Rapids, MI
SELECT * from toolvenuepagelink WHERE venueid = 1357
SELECT * from toolcitypagelink WHERE cityname = 'Royal Oak'
Snails
Royal Oak Music Theatre Royal Oak Royal Oak, MI
Dec 6, 8:00 pm 2018
Thursday
Dec 6
8:00 pm
Snails
Royal Oak Music Theatre, Royal Oak, MI
SELECT * from toolvenuepagelink WHERE venueid = 56
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Snails
Aragon Ballroom Chicago Chicago, IL
Dec 7, 9:00 pm 2018
Friday
Dec 7
9:00 pm
Snails
Aragon Ballroom, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 3734
SELECT * from toolcitypagelink WHERE cityname = 'St Paul'
Snails
Myth St Paul St Paul, MN
Dec 8, 8:00 pm 2018
Saturday
Dec 8
8:00 pm
Snails
Myth, St Paul, MN
SELECT * from toolvenuepagelink WHERE venueid = 3266
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
Snails
House of Blues - Cleveland Cleveland Cleveland, OH
Dec 11, 8:00 pm 2018
Tuesday
Dec 11
8:00 pm
Snails
House of Blues - Cleveland, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 19289
SELECT * from toolcitypagelink WHERE cityname = 'Indianapolis'
Snails
Deluxe at Old National Centre Indianapolis Indianapolis, IN
Dec 12, 9:30 pm 2018
Wednesday
Dec 12
9:30 pm
Snails
Deluxe at Old National Centre, Indianapolis, IN
SELECT * from toolvenuepagelink WHERE venueid = 1005
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'
Snails
Arvest Bank Theatre at The Midland Kansas City Kansas City, MO
Dec 13, 8:00 pm 2018
Thursday
Dec 13
8:00 pm
Snails
Arvest Bank Theatre at The Midland, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 31705
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Snails
South Side Ballroom Dallas Dallas, TX
Dec 14, 8:00 pm 2018
Friday
Dec 14
8:00 pm
Snails
South Side Ballroom, Dallas, TX
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football