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 = 3266
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'

December

Snails with Funtcase
House of Blues - Cleveland Cleveland Cleveland, OH
Dec 11, 7:00 pm 2017
Monday
Dec 11
7:00 pm
Snails with Funtcase
House of Blues - Cleveland, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 19289
SELECT * from toolcitypagelink WHERE cityname = 'Indianapolis'
Snails with Funtcase
Deluxe at Old National Centre Indianapolis Indianapolis, IN
Dec 12, 9:00 pm 2017
Tuesday
Dec 12
9:00 pm
Snails with Funtcase
Deluxe at Old National Centre, Indianapolis, IN
SELECT * from toolvenuepagelink WHERE venueid = 1110
SELECT * from toolcitypagelink WHERE cityname = 'Columbus'
Snails with Funtcase
Newport Music Hall Columbus Columbus, OH
Dec 13, 7:00 pm 2017
Wednesday
Dec 13
7:00 pm
Snails with Funtcase
Newport Music Hall, Columbus, OH
SELECT * from toolvenuepagelink WHERE venueid = 32474
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
Snails
The Fillmore Philadelphia Philadelphia Philadelphia, PA
Dec 15, 9:00 pm 2017
Friday
Dec 15
9:00 pm
Snails
The Fillmore Philadelphia, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 4954
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Snails
Terminal 5 New York New York, NY
Dec 16, 9:00 pm 2017
Saturday
Dec 16
9:00 pm
Snails
Terminal 5, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 5177
SELECT * from toolcitypagelink WHERE cityname = 'Richmond'
Snails with Funtcase
The National Richmond Richmond, VA
Dec 17, 7:00 pm 2017
Sunday
Dec 17
7:00 pm
Snails with Funtcase
The National, Richmond, VA
SELECT * from toolvenuepagelink WHERE venueid = 2232
SELECT * from toolcitypagelink WHERE cityname = 'Norfolk'
Snails with Funtcase
The Norva Norfolk Norfolk, VA
Dec 20, 8:00 pm 2017
Wednesday
Dec 20
8:00 pm
Snails with Funtcase
The Norva, Norfolk, VA
SELECT * from toolvenuepagelink WHERE venueid = 32925
SELECT * from toolcitypagelink WHERE cityname = 'Antioch'
Snails
Global Event Center Antioch Antioch, TN
Dec 21, 8:00 pm 2017
Thursday
Dec 21
8:00 pm
Snails
Global Event Center, Antioch, TN
SELECT * from toolvenuepagelink WHERE venueid = 6693
SELECT * from toolcitypagelink WHERE cityname = 'Charlotte'
Snails with Funtcase
The Underground - Fillmore Charlotte Charlotte Charlotte, NC
Dec 22, 8:00 pm 2017
Friday
Dec 22
8:00 pm
Snails with Funtcase
The Underground - Fillmore Charlotte, Charlotte, NC
SELECT * from toolvenuepagelink WHERE venueid = 1555
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Snails
The Tabernacle Atlanta Atlanta, GA
Dec 23, 8:00 pm 2017
Saturday
Dec 23
8:00 pm
Snails
The Tabernacle, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 28291
SELECT * from toolcitypagelink WHERE cityname = 'Worcester'
Snails
The Palladium - MA Worcester Worcester, MA
Dec 27, 8:00 pm 2017
Wednesday
Dec 27
8:00 pm
Snails
The Palladium - MA, Worcester, MA
SELECT * from toolvenuepagelink WHERE venueid = 2823
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Snails with Funtcase
Metropolis Montreal Montreal, QC
Dec 28, 10:00 pm 2017
Thursday
Dec 28
10:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 2992
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Snails with Funtcase
Danforth Music Hall Toronto Toronto, ON
Dec 29, 7:00 pm 2017
Friday
Dec 29
7:00 pm
Snails with Funtcase
Danforth Music Hall, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 56
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Snails
Aragon Ballroom Chicago Chicago, IL
Dec 30, 9:00 pm 2017
Saturday
Dec 30
9:00 pm
Snails
Aragon Ballroom, Chicago, IL
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football
NOUVELLES - SPORT