SELECT tbproductions.*, ttvenues.city,ttvenues.state, CONCAT(ttvenues.city,', ',ttvenues.state) as Region FROM tbproductions,ttvenues , tevoEventPerformers
WHERE tbEventsID = 52842 AND tevoEventPerformers.performerId = 52842 AND tbproductions.tbVenuesID = ttvenues.id AND tbproductions.tbVenuesID = ttvenues.id AND tevoEventPerformers.eventId = tbproductions.ID
ORDER BY tbproductions.Eventdate
March
Smino
http://www.qualityplustickets.com/searchtickets.php?productionID=1644649
House of Blues - Cleveland
Cleveland Cleveland, OH
Mar 23, 8:00 pm 2019
Smino
House of Blues - Cleveland, Cleveland, OH
Smino
http://www.qualityplustickets.com/searchtickets.php?productionID=1648726
House of Blues - Cleveland
Cleveland Cleveland, OH
Mar 24, 6:00 pm 2019
Smino
House of Blues - Cleveland, Cleveland, OH
Smino
http://www.qualityplustickets.com/searchtickets.php?productionID=1644673
Majestic Theatre
Madison Madison, WI
Mar 27, 8:30 pm 2019
Smino
Majestic Theatre, Madison, WI
Smino
http://www.qualityplustickets.com/searchtickets.php?productionID=1645965
Varsity Theater - Minneapolis, MN
Minneapolis Minneapolis, MN
Mar 28, 7:30 pm 2019
Smino
Varsity Theater - Minneapolis, MN, Minneapolis, MN
Smino
http://www.qualityplustickets.com/searchtickets.php?productionID=1644620
Granada - KS
Lawrence Lawrence, KS
Mar 30, 8:00 pm 2019
Smino
Granada - KS, Lawrence, KS
April
Smino
http://www.qualityplustickets.com/searchtickets.php?productionID=1645412
Summit Music Hall
Denver Denver, CO
Apr 1, 7:00 pm 2019
Smino
Summit Music Hall, Denver, CO
Smino
http://www.qualityplustickets.com/searchtickets.php?productionID=1648905
The Complex
Salt Lake City Salt Lake City, UT
Apr 2, 7:00 pm 2019
Smino
The Complex, Salt Lake City, UT
Smino
http://www.qualityplustickets.com/searchtickets.php?productionID=1646977
The Showbox
Seattle Seattle, WA
Apr 4, 8:30 pm 2019
Smino
The Showbox, Seattle, WA
Smino
http://www.qualityplustickets.com/searchtickets.php?productionID=1645319
Vogue Theatre
Vancouver Vancouver, BC
Apr 5, 8:00 pm 2019
Smino
http://www.qualityplustickets.com/searchtickets.php?productionID=1645403
The Fillmore - San Francisco
San Francisco San Francisco, CA
Apr 9, 8:00 pm 2019
Smino
The Fillmore - San Francisco, San Francisco, CA
Smino
http://www.qualityplustickets.com/searchtickets.php?productionID=1645980
The Catalyst - CA
Santa Cruz Santa Cruz, CA
Apr 10, 9:00 pm 2019
Smino
The Catalyst - CA, Santa Cruz, CA
Smino
http://www.qualityplustickets.com/searchtickets.php?productionID=1645333
Trees
Dallas Dallas, TX
Apr 25, 7:30 pm 2019
Smino
http://www.qualityplustickets.com/searchtickets.php?productionID=1648322
Emo's East
Austin Austin, TX
Apr 26, 8:00 pm 2019
Smino
Emo's East, Austin, TX
Smino
http://www.qualityplustickets.com/searchtickets.php?productionID=1648620
Warehouse Live
Houston Houston, TX
Apr 29, 8:30 pm 2019
Smino
Warehouse Live, Houston, TX
Smino
http://www.qualityplustickets.com/searchtickets.php?productionID=1644634
House of Blues - New Orleans
New Orleans New Orleans, LA
Apr 30, 8:00 pm 2019
Smino
House of Blues - New Orleans, New Orleans, LA
May
Smino
http://www.qualityplustickets.com/searchtickets.php?productionID=1644582
Cannery Ballroom
Nashville Nashville, TN
May 2, 8:00 pm 2019
Smino
Cannery Ballroom, Nashville, TN
Smino
http://www.qualityplustickets.com/searchtickets.php?productionID=1644580
Buckhead Theatre
Atlanta Atlanta, GA
May 3, 8:00 pm 2019
Smino
Buckhead Theatre, Atlanta, GA
Smino
http://www.qualityplustickets.com/searchtickets.php?productionID=1644820
The Underground
Mesa Mesa, AZ
May 6, 8:00 pm 2019
Smino
The Underground, Mesa, AZ
Smino
http://www.qualityplustickets.com/searchtickets.php?productionID=1645404
The Fillmore Silver Spring
Silver Spring Silver Spring, MD
May 7, 8:00 pm 2019
Smino
The Fillmore Silver Spring, Silver Spring, MD
Smino
http://www.qualityplustickets.com/searchtickets.php?productionID=1644577
Brooklyn Steel
Brooklyn Brooklyn, NY
May 9, 8:00 pm 2019
Smino
Brooklyn Steel, Brooklyn, NY
Smino
http://www.qualityplustickets.com/searchtickets.php?productionID=1645667
Irving Plaza
New York New York, NY
May 10, 8:00 pm 2019
Smino
Irving Plaza, New York, NY
Smino
http://www.qualityplustickets.com/searchtickets.php?productionID=1645828
Theatre of Living Arts
Philadelphia Philadelphia, PA
May 11, 8:00 pm 2019
Smino
Theatre of Living Arts, Philadelphia, PA
Smino
http://www.qualityplustickets.com/searchtickets.php?productionID=1644506
Paradise Rock Club
Boston Boston, MA
May 13, 8:00 pm 2019
Smino
Paradise Rock Club, Boston, MA
Smino
http://www.qualityplustickets.com/searchtickets.php?productionID=1645671
L'Astral
Montreal Montreal, QC
May 14, 8:00 pm 2019
Smino
http://www.qualityplustickets.com/searchtickets.php?productionID=1647878
Phoenix Concert Theatre
Toronto Toronto, ON
May 16, 8:00 pm 2019
Smino
http://www.qualityplustickets.com/searchtickets.php?productionID=1645009
Shelter
Detroit Detroit, MI
May 17, 8:30 pm 2019
Smino
Shelter, Detroit, MI
|