SELECT DISTINCT a.whatsShowingID 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 AND b.movieID=6257 ORDER BY b.movieID ASC
Office Christmas Party | Movie | Mall of Africa
Database query failed: Unknown column 'Array' in 'where clause'
SELECT whatMovieID, times, movieID FROM whatsShowingMovies WHERE whatsShowingID=Array AND movieID=6257

MallMovie

Office Christmas Party

Office Christmas Party
When his uptight CEO sister threatens to shut down his branch, the branch manager throws an epic Christmas party in order to land a big client and save the day, but the party gets way out of hand...
Cast: Jason Bateman, Olivia Munn, T.J. Miller
Director: Josh Gordon, Will Speck
Producer: N/A
Genre: Comedy
Age Restriction: 16DLNS
Length: 105min