LISTE POUR : Sleigh Bells

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

January

Sleigh Bells
Rough Trade NYC New York New York, NY
Jan 23, 8:00 pm 2018
Tuesday
Jan 23
8:00 pm
Sleigh Bells
Rough Trade NYC, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 2254
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Sleigh Bells
Paradise Rock Club Boston Boston, MA
Jan 24, 7:30 pm 2018
Wednesday
Jan 24
7:30 pm
Sleigh Bells
Paradise Rock Club, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 33485
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Sleigh Bells
Aura Portland Portland, ME
Jan 26, 9:00 pm 2018
Friday
Jan 26
9:00 pm
Sleigh Bells
Aura, Portland, ME
SELECT * from toolvenuepagelink WHERE venueid = 18120
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Sleigh Bells
L'Astral Montreal Montreal, QC
Jan 27, 8:30 pm 2018
Saturday
Jan 27
8:30 pm
SELECT * from toolvenuepagelink WHERE venueid = 33149
SELECT * from toolcitypagelink WHERE cityname = 'Detroit'
Sleigh Bells
El Club Detroit Detroit, MI
Jan 30, 8:00 pm 2018
Tuesday
Jan 30
8:00 pm
Sleigh Bells
El Club, Detroit, MI
SELECT * from toolvenuepagelink WHERE venueid = 2164
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Sleigh Bells
Metro Smart Bar Chicago Chicago, IL
Jan 31, 8:00 pm 2018
Wednesday
Jan 31
8:00 pm
Sleigh Bells
Metro Smart Bar, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 9067
SELECT * from toolcitypagelink WHERE cityname = 'Austin'

February

Sleigh Bells
Mohawk Austin Austin, TX
Feb 3, 8:00 pm 2018
Saturday
Feb 3
8:00 pm
Sleigh Bells
Mohawk, Austin, TX
SELECT * from toolvenuepagelink WHERE venueid = 1735
SELECT * from toolcitypagelink WHERE cityname = 'San Antonio'
Sleigh Bells
White Rabbit San Antonio San Antonio, TX
Feb 5, 8:00 pm 2018
Monday
Feb 5
8:00 pm
Sleigh Bells
White Rabbit, San Antonio, TX
SELECT * from toolvenuepagelink WHERE venueid = 2329
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Sleigh Bells
Granada Theater - TX Dallas Dallas, TX
Feb 6, 8:00 pm 2018
Tuesday
Feb 6
8:00 pm
Sleigh Bells
Granada Theater - TX, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 32931
SELECT * from toolcitypagelink WHERE cityname = 'Houston'
Sleigh Bells
White Oak Music Hall Houston Houston, TX
Feb 7, 8:00 pm 2018
Wednesday
Feb 7
8:00 pm
Sleigh Bells
White Oak Music Hall, Houston, TX
SELECT * from toolvenuepagelink WHERE venueid = 26926
SELECT * from toolcitypagelink WHERE cityname = 'New Orleans'
Sleigh Bells
Republic New Orleans New Orleans New Orleans, LA
Feb 9, 7:30 pm 2018
Friday
Feb 9
7:30 pm
Sleigh Bells
Republic New Orleans, New Orleans, LA
SELECT * from toolvenuepagelink WHERE venueid = 1959
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Sleigh Bells
9:30 Club Washington Washington, DC
Feb 14, 7:30 pm 2018
Wednesday
Feb 14
7:30 pm
Sleigh Bells
9:30 Club, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 1959
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Sleigh Bells
9:30 Club Washington Washington, DC
Feb 18, 7:00 pm 2018
Sunday
Feb 18
7:00 pm
Sleigh Bells
9:30 Club, Washington, DC
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