SELECT tbproductions.*, ttvenues.city,ttvenues.state, CONCAT(ttvenues.city,', ',ttvenues.state) as Region FROM tbproductions,ttvenues , tevoEventPerformers
WHERE tbEventsID = 8289 AND tevoEventPerformers.performerId = 8289 AND tbproductions.tbVenuesID = ttvenues.id AND tbproductions.tbVenuesID = ttvenues.id AND tevoEventPerformers.eventId = tbproductions.ID
ORDER BY tbproductions.Eventdate
April
Norah Jones
http://www.qualityplustickets.com/searchtickets.php?productionID=1651388
Palais Theatre
St Kilda St Kilda,
Apr 12, 8:00 pm 2019
Norah Jones
http://www.qualityplustickets.com/searchtickets.php?productionID=1651389
Sydney State Theatre
Sydney Sydney, Ne
Apr 14, 7:00 pm 2019
June
Norah Jones
http://www.qualityplustickets.com/searchtickets.php?productionID=1651352
Heinz Hall
Pittsburgh Pittsburgh, PA
Jun 18, 8:00 pm 2019
Norah Jones
http://www.qualityplustickets.com/searchtickets.php?productionID=1651353
Clay Center
Charleston Charleston, WV
Jun 19, 8:00 pm 2019
Norah Jones
http://www.qualityplustickets.com/searchtickets.php?productionID=1651354
The Queen
Wilmington Wilmington, DE
Jun 22, 8:00 pm 2019
Norah Jones
http://www.qualityplustickets.com/searchtickets.php?productionID=1651366
Jun 26, 8:00 pm 2019
Norah Jones
http://www.qualityplustickets.com/searchtickets.php?productionID=1651367
Jun 27, 7:30 pm 2019
Norah Jones
http://www.qualityplustickets.com/searchtickets.php?productionID=1651355
Pines Theatre
Florence Florence, MA
Jun 29, 8:00 pm 2019
July
Norah Jones
http://www.qualityplustickets.com/searchtickets.php?productionID=1651356
Cheyenne Civic Center
Cheyenne Cheyenne, WY
Jul 14, 8:00 pm 2019
Norah Jones
http://www.qualityplustickets.com/searchtickets.php?productionID=1651357
Red Rocks Amphitheatre
Morrison Morrison, CO
Jul 16, 7:30 pm 2019
Norah Jones
http://www.qualityplustickets.com/searchtickets.php?productionID=1651358
Belly Up Aspen
Aspen Aspen, CO
Jul 18, 9:00 pm 2019
Norah Jones
http://www.qualityplustickets.com/searchtickets.php?productionID=1651359
Sandy Amphitheater
Sandy Sandy, UT
Jul 20, 8:00 pm 2019
Norah Jones
http://www.qualityplustickets.com/searchtickets.php?productionID=1651360
Walk Festival Hall
Teton Village Teton Village, WY
Jul 21, 8:00 pm 2019
Norah Jones
http://www.qualityplustickets.com/searchtickets.php?productionID=1651361
Brick Breeden Fieldhouse
Bozeman Bozeman, Mt
Jul 23, 8:00 pm 2019
Norah Jones
http://www.qualityplustickets.com/searchtickets.php?productionID=1651362
KettleHouse Amphitheater
Bonner-West Riverside Bonner-West Riverside, MT
Jul 24, 8:00 pm 2019
Norah Jones
KettleHouse Amphitheater, Bonner-West Riverside, MT
Norah Jones
http://www.qualityplustickets.com/searchtickets.php?productionID=1651363
Fox Theater Spokane
Spokane Spokane, WA
Jul 26, 8:00 pm 2019
Norah Jones
http://www.qualityplustickets.com/searchtickets.php?productionID=1651364
Orpheum Theatre - Vancouver
Vancouver Vancouver, BC
Jul 28, 8:00 pm 2019
Norah Jones
http://www.qualityplustickets.com/searchtickets.php?productionID=1651387
Centennial Hall Convention Center
Juneau Juneau, AK
Jul 31, 8:00 pm 2019
Norah Jones
Centennial Hall Convention Center, Juneau, AK
August
Norah Jones
http://www.qualityplustickets.com/searchtickets.php?productionID=1651365
Bear Tooth Theatrepub
Anchorage Anchorage, Al
Aug 2, 8:00 pm 2019
Norah Jones
http://www.qualityplustickets.com/searchtickets.php?productionID=1654966
Bear Tooth Theatrepub
Anchorage Anchorage, Al
Aug 3, 8:00 pm 2019
|