SELECT DISTINCT b.movieID FROM whatsShowing a JOIN whatsShowingMovies b ON b.whatsShowingID=a.whatsShowingID WHERE DATE_FORMAT(a.startDate,'%Y-%m-%d') <= DATE_FORMAT(NOW(),'%Y-%m-%d') AND DATE_FORMAT(a.endDate,'%Y-%m-%d') >= DATE_FORMAT(NOW(),'%Y-%m-%d') AND a.mallID=2066 ORDER BY b.movieID ASC
Movies | Mall of Africa

MallMovies

Friday, June 22nd, 2018

Sorry, there currently are no movies scheduled. Please check back again soon!