LISTE POUR : Poppy

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

January

Poppy (Rescheduled from 11/24/2018)
9:30 Club Washington Washington, DC
Jan 31, 8:00 pm 2019
Thursday
Jan 31
8:00 pm
Poppy (Rescheduled from 11/24/2018)
9:30 Club, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 6064
SELECT * from toolcitypagelink WHERE cityname = 'Boston'

February

Poppy (Rescheduled from 11/19/2018)
House of Blues - Boston Boston Boston, MA
Feb 4, 8:00 pm 2019
Monday
Feb 4
8:00 pm
Poppy (Rescheduled from 11/19/2018)
House of Blues - Boston, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 2992
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Poppy (Rescheduled from 11/17/2018)
Danforth Music Hall Toronto Toronto, ON
Feb 6, 7:00 pm 2019
Wednesday
Feb 6
7:00 pm
SELECT * from toolvenuepagelink WHERE venueid = 680
SELECT * from toolcitypagelink WHERE cityname = 'Chicago'
Poppy
House of Blues - Chicago Chicago Chicago, IL
Feb 8, 6:30 pm 2019
Friday
Feb 8
6:30 pm
Poppy
House of Blues - Chicago, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 216
SELECT * from toolcitypagelink WHERE cityname = 'Nashville'
Poppy (Rescheduled from 11/13/2018)
Cannery Ballroom Nashville Nashville, TN
Feb 11, 7:35 pm 2019
Monday
Feb 11
7:35 pm
Poppy (Rescheduled from 11/13/2018)
Cannery Ballroom, Nashville, TN
SELECT * from toolvenuepagelink WHERE venueid = 7465
SELECT * from toolcitypagelink WHERE cityname = 'Atlanta'
Poppy (Rescheduled from 11/10/2018)
Buckhead Theatre Atlanta Atlanta, GA
Feb 12, 8:00 pm 2019
Tuesday
Feb 12
8:00 pm
Poppy (Rescheduled from 11/10/2018)
Buckhead Theatre, Atlanta, GA
SELECT * from toolvenuepagelink WHERE venueid = 8167
SELECT * from toolcitypagelink WHERE cityname = 'Tampa'
Poppy (Rescheduled from 11/09/2018)
The Orpheum - Tampa Tampa Tampa, FL
Feb 13, 8:00 pm 2019
Wednesday
Feb 13
8:00 pm
Poppy (Rescheduled from 11/09/2018)
The Orpheum - Tampa, Tampa, FL
SELECT * from toolvenuepagelink WHERE venueid = 4568
SELECT * from toolcitypagelink WHERE cityname = 'Dallas'
Poppy (Rescheduled from 11/06/2018)
House of Blues - Dallas Dallas Dallas, TX
Feb 15, 8:00 pm 2019
Friday
Feb 15
8:00 pm
Poppy (Rescheduled from 11/06/2018)
House of Blues - Dallas, Dallas, TX
SELECT * from toolvenuepagelink WHERE venueid = 2171
SELECT * from toolcitypagelink WHERE cityname = 'Austin'
Poppy (Rescheduled from 11/07/2018)
Emo's East Austin Austin, TX
Feb 16, 7:00 pm 2019
Saturday
Feb 16
7:00 pm
Poppy (Rescheduled from 11/07/2018)
Emo's East, Austin, TX
SELECT * from toolvenuepagelink WHERE venueid = 2040
SELECT * from toolcitypagelink WHERE cityname = 'Englewood'
Poppy (Rescheduled from 11/03/2018)
Gothic Theatre Englewood Englewood, CO
Feb 19, 7:35 pm 2019
Tuesday
Feb 19
7:35 pm
Poppy (Rescheduled from 11/03/2018)
Gothic Theatre, Englewood, CO
SELECT * from toolvenuepagelink WHERE venueid = 4059
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Poppy (Rescheduled from 10/25/2018)
Wonder Ballroom Portland Portland, OR
Feb 22, 7:30 pm 2019
Friday
Feb 22
7:30 pm
Poppy (Rescheduled from 10/25/2018)
Wonder Ballroom, Portland, OR
SELECT * from toolvenuepagelink WHERE venueid = 3226
SELECT * from toolcitypagelink WHERE cityname = 'San Francisco'
Poppy
Regency Ballroom - Social Hall San Francisco San Francisco, CA
Feb 24, 8:00 pm 2019
Sunday
Feb 24
8:00 pm
Poppy
Regency Ballroom - Social Hall, San Francisco, CA
SELECT * from toolvenuepagelink WHERE venueid = 3493
SELECT * from toolcitypagelink WHERE cityname = 'San Diego'
Poppy (Rescheduled from 11/01/2018)
House of Blues - San Diego San Diego San Diego, CA
Feb 27, 7:00 pm 2019
Wednesday
Feb 27
7:00 pm
Poppy (Rescheduled from 11/01/2018)
House of Blues - San Diego, San Diego, CA
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football