LISTE POUR : Cherub

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

January

Cherub
Concord Music Hall Chicago Chicago, IL
Jan 18, 8:00 pm 2019
Friday
Jan 18
8:00 pm
Cherub
Concord Music Hall, Chicago, IL
SELECT * from toolvenuepagelink WHERE venueid = 1862
SELECT * from toolcitypagelink WHERE cityname = 'St Louis'
Cherub
Delmar Hall St Louis St Louis, MO
Jan 19, 9:00 pm 2019
Saturday
Jan 19
9:00 pm
Cherub
Delmar Hall, St Louis, MO
SELECT * from toolvenuepagelink WHERE venueid = 2759
SELECT * from toolcitypagelink WHERE cityname = 'Cincinnati'
Cherub
20th Century Theater Cincinnati Cincinnati, OH
Jan 20, 9:00 pm 2019
Sunday
Jan 20
9:00 pm
Cherub
20th Century Theater, Cincinnati, OH
SELECT * from toolvenuepagelink WHERE venueid = 27619
SELECT * from toolcitypagelink WHERE cityname = 'Columbia'
Cherub
Tin Roof Columbia Columbia Columbia, SC
Jan 22, 9:00 pm 2019
Tuesday
Jan 22
9:00 pm
Cherub
Tin Roof Columbia, Columbia, SC
SELECT * from toolvenuepagelink WHERE venueid = 31640
SELECT * from toolcitypagelink WHERE cityname = 'Columbia'
Cherub
The Senate Columbia Columbia, SC
Jan 22, 9:00 pm 2019
Tuesday
Jan 22
9:00 pm
Cherub
The Senate, Columbia, SC
SELECT * from toolvenuepagelink WHERE venueid = 8881
SELECT * from toolcitypagelink WHERE cityname = 'Macon'
Cherub
Cox Capitol Theatre Macon Macon, GA
Jan 23, 8:30 pm 2019
Wednesday
Jan 23
8:30 pm
Cherub
Cox Capitol Theatre, Macon, GA
SELECT * from toolvenuepagelink WHERE venueid = 1936
SELECT * from toolcitypagelink WHERE cityname = 'New Orleans'
Cherub
House of Blues - New Orleans New Orleans New Orleans, LA
Jan 25, 8:00 pm 2019
Friday
Jan 25
8:00 pm
Cherub
House of Blues - New Orleans, New Orleans, LA
SELECT * from toolvenuepagelink WHERE venueid = 1099
SELECT * from toolcitypagelink WHERE cityname = 'Memphis'
Cherub (cancelled)
New Daisy Theatre Memphis Memphis, TN
Jan 26, 9:00 pm 2019
Saturday
Jan 26
9:00 pm
Cherub (cancelled)
New Daisy Theatre, Memphis, TN
SELECT * from toolvenuepagelink WHERE venueid = 30220
SELECT * from toolcitypagelink WHERE cityname = 'Birmingham'
Cherub
Iron City - Birmingham Birmingham Birmingham, AL
Jan 27, 8:00 pm 2019
Sunday
Jan 27
8:00 pm
Cherub
Iron City - Birmingham, Birmingham, AL
SELECT * from toolvenuepagelink WHERE venueid = 33547
SELECT * from toolcitypagelink WHERE cityname = 'Kansas City'

February

Cherub
The Truman Kansas City Kansas City, MO
Feb 1, 9:00 pm 2019
Friday
Feb 1
9:00 pm
Cherub
The Truman, Kansas City, MO
SELECT * from toolvenuepagelink WHERE venueid = 3000
SELECT * from toolcitypagelink WHERE cityname = 'Tulsa'
Cherub
Cains Ballroom Tulsa Tulsa, OK
Feb 2, 9:00 pm 2019
Saturday
Feb 2
9:00 pm
Cherub
Cains Ballroom, Tulsa, OK
SELECT * from toolvenuepagelink WHERE venueid = 28856
SELECT * from toolcitypagelink WHERE cityname = 'Des Moines'
Cherub
Wooly's Des Moines Des Moines, IA
Feb 5, 8:00 pm 2019
Tuesday
Feb 5
8:00 pm
Cherub
Wooly's, Des Moines, IA
SELECT * from toolvenuepagelink WHERE venueid = 5039
SELECT * from toolcitypagelink WHERE cityname = 'Milwaukee'
Cherub
Turner Hall Ballroom Milwaukee Milwaukee, WI
Feb 7, 8:00 pm 2019
Thursday
Feb 7
8:00 pm
Cherub
Turner Hall Ballroom, Milwaukee, WI
SELECT * from toolvenuepagelink WHERE venueid = 496
SELECT * from toolcitypagelink WHERE cityname = 'Minneapolis'
Cherub
First Avenue Minneapolis Minneapolis, MN
Feb 8, 9:00 pm 2019
Friday
Feb 8
9:00 pm
Cherub
First Avenue, Minneapolis, MN
SELECT * from toolvenuepagelink WHERE venueid = 28080
SELECT * from toolcitypagelink WHERE cityname = 'Iowa City'
Cherub
Blue Moose Tap House Iowa City Iowa City, IA
Feb 9, 9:00 pm 2019
Saturday
Feb 9
9:00 pm
Cherub
Blue Moose Tap House, Iowa City, IA
SELECT * from toolvenuepagelink WHERE venueid = 5080
SELECT * from toolcitypagelink WHERE cityname = 'Omaha'
Cherub
The Waiting Room Omaha Omaha, NE
Feb 12, 8:00 pm 2019
Tuesday
Feb 12
8:00 pm
Cherub
The Waiting Room, Omaha, NE
SELECT * from toolvenuepagelink WHERE venueid = 19289
SELECT * from toolcitypagelink WHERE cityname = 'Indianapolis'
Cherub
Deluxe at Old National Centre Indianapolis Indianapolis, IN
Feb 13, 9:00 pm 2019
Wednesday
Feb 13
9:00 pm
Cherub
Deluxe at Old National Centre, Indianapolis, IN
SELECT * from toolvenuepagelink WHERE venueid = 3266
SELECT * from toolcitypagelink WHERE cityname = 'Cleveland'
Cherub
House of Blues - Cleveland Cleveland Cleveland, OH
Feb 15, 8:00 pm 2019
Friday
Feb 15
8:00 pm
Cherub
House of Blues - Cleveland, Cleveland, OH
SELECT * from toolvenuepagelink WHERE venueid = 32779
SELECT * from toolcitypagelink WHERE cityname = 'Buffalo'
Cherub
Iron Works Buffalo Buffalo, NY
Feb 17, 9:00 pm 2019
Sunday
Feb 17
9:00 pm
Cherub
Iron Works, Buffalo, NY
SELECT * from toolvenuepagelink WHERE venueid = 33004
SELECT * from toolcitypagelink WHERE cityname = 'Toronto'
Cherub
Velvet Underground - Toronto Toronto Toronto, ON
Feb 19, 7:30 pm 2019
Tuesday
Feb 19
7:30 pm
Cherub
Velvet Underground - Toronto, Toronto, ON
SELECT * from toolvenuepagelink WHERE venueid = 4858
SELECT * from toolcitypagelink WHERE cityname = 'Edmonton'
Cherub
The Velvet Underground Edmonton Edmonton, AB
Feb 19, 7:30 pm 2019
Tuesday
Feb 19
7:30 pm
Cherub
The Velvet Underground, Edmonton, AB
SELECT * from toolvenuepagelink WHERE venueid = 1500
SELECT * from toolcitypagelink WHERE cityname = 'Asbury Park'
Cherub
Stone Pony Asbury Park Asbury Park, NJ
Feb 21, 8:00 pm 2019
Thursday
Feb 21
8:00 pm
Cherub
Stone Pony, Asbury Park, NJ
SELECT * from toolvenuepagelink WHERE venueid = 1959
SELECT * from toolcitypagelink WHERE cityname = 'Washington'
Cherub
9:30 Club Washington Washington, DC
Feb 22, 10:00 pm 2019
Friday
Feb 22
10:00 pm
Cherub
9:30 Club, Washington, DC
SELECT * from toolvenuepagelink WHERE venueid = 856
SELECT * from toolcitypagelink WHERE cityname = 'Philadelphia'
Cherub
Theatre of Living Arts Philadelphia Philadelphia, PA
Feb 23, 8:00 pm 2019
Saturday
Feb 23
8:00 pm
Cherub
Theatre of Living Arts, Philadelphia, PA
SELECT * from toolvenuepagelink WHERE venueid = 3919
SELECT * from toolcitypagelink WHERE cityname = 'South Burlington'
Cherub
Higher Ground South Burlington South Burlington, VT
Feb 26, 8:00 pm 2019
Tuesday
Feb 26
8:00 pm
Cherub
Higher Ground, South Burlington, VT
SELECT * from toolvenuepagelink WHERE venueid = 6182
SELECT * from toolcitypagelink WHERE cityname = 'Portland'
Cherub
Port City Music Hall Portland Portland, ME
Feb 28, 9:00 pm 2019
Thursday
Feb 28
9:00 pm
Cherub
Port City Music Hall, Portland, ME
SELECT * from toolvenuepagelink WHERE venueid = 2254
SELECT * from toolcitypagelink WHERE cityname = 'Boston'

March

Cherub
Paradise Rock Club Boston Boston, MA
Mar 1, 8:00 pm 2019
Friday
Mar 1
8:00 pm
Cherub
Paradise Rock Club, Boston, MA
SELECT * from toolvenuepagelink WHERE venueid = 33405
SELECT * from toolcitypagelink WHERE cityname = 'Brooklyn'
Cherub
Brooklyn Steel Brooklyn Brooklyn, NY
Mar 2, 9:00 pm 2019
Saturday
Mar 2
9:00 pm
Cherub
Brooklyn Steel, Brooklyn, NY
Billets Ozzy Osbourne Montreal
INSCRIPTION BULLETIN
Inscrivez-vous à notre bulletin mensuel et soyez les premiers informés!
Nom:
Courriel:
GO
Ligue Canadienne de Football