LISTE POUR : Collie Buddz

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

December

Collie Buddz with Jesse Royal
Neumos Seattle Seattle, WA
Dec 15, 8:00 pm 2017
Friday
Dec 15
8:00 pm
Collie Buddz with Jesse Royal
Neumos, Seattle, WA
SELECT * from toolvenuepagelink WHERE venueid = 4059
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Collie Buddz
Wonder Ballroom Portland Portland, OR
Dec 17, 8:30 pm 2017
Sunday
Dec 17
8:30 pm
Collie Buddz
Wonder Ballroom, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 28994
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'

January

Collie Buddz
Terminal West Atlanta Atlanta, GA
Jan 10, 8:00 pm 2018
Wednesday
Jan 10
8:00 pm
Collie Buddz
Terminal West, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 4022
SELECT * from toolcitypagelink WHERE cityname = 'Raleigh'
Collie Buddz
Lincoln Theatre - NC Raleigh Raleigh, NC
Jan 14, 8:00 pm 2018
Sunday
Jan 14
8:00 pm
Collie Buddz
Lincoln Theatre - NC, Raleigh, NC
SELECT * from toolvenuepagelink WHERE venueid = 1959
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Collie Buddz
9:30 Club Washington Washington, DC
Jan 15, 7:00 pm 2018
Monday
Jan 15
7:00 pm
Collie Buddz
9:30 Club, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 1822
SELECT * from toolcitypagelink WHERE cityname = 'New York'
Collie Buddz with Jo Mersa Marley
Bowery Ballroom New York New York, NY
Jan 17, 8:00 pm 2018
Wednesday
Jan 17
8:00 pm
Collie Buddz with Jo Mersa Marley
Bowery Ballroom, New York, NY
SELECT * from toolvenuepagelink WHERE venueid = 7045
SELECT * from toolcitypagelink WHERE cityname = 'Brooklyn'
Collie Buddz with Jo Mersa Marley
Brooklyn Bowl Brooklyn Brooklyn, NY
Jan 18, 8:00 pm 2018
Thursday
Jan 18
8:00 pm
Collie Buddz with Jo Mersa Marley
Brooklyn Bowl, Brooklyn, NY
SELECT * from toolvenuepagelink WHERE venueid = 5593
SELECT * from toolcitypagelink WHERE cityname = 'Fairfield'
Collie Buddz
Fairfield Theatre Company Fairfield Fairfield, CT
Jan 19, 8:00 pm 2018
Friday
Jan 19
8:00 pm
Collie Buddz
Fairfield Theatre Company, Fairfield, CT
SELECT * from toolvenuepagelink WHERE venueid = 6064
SELECT * from toolcitypagelink WHERE cityname = 'Boston'
Collie Buddz
House of Blues - Boston Boston Boston, MA
Jan 20, 7:00 pm 2018
Saturday
Jan 20
7:00 pm
Collie Buddz
House of Blues - Boston, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 6182
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Collie Buddz with The Holdup
Port City Music Hall Portland Portland, ME
Jan 25, 8:00 pm 2018
Thursday
Jan 25
8:00 pm
Collie Buddz with The Holdup
Port City Music Hall, Portland, ME
SELECT * from toolvenuepagelink WHERE venueid = 2823
SELECT * from toolcitypagelink WHERE cityname = 'Montreal'
Collie Buddz
Metropolis Montreal Montreal, QC
Jan 26, 8:00 pm 2018
Friday
Jan 26
8:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 2885
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Collie Buddz with Jo Mersa Marley
Phoenix Concert Theatre Toronto Toronto, ON
Jan 27, 7:00 pm 2018
Saturday
Jan 27
7:00 pm
Billets Shania Twain Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football