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=7685 ORDER BY b.movieID ASC
Dumbo [2d] | Movie | Mall of Africa
Database query failed: Unknown column 'Array' in 'where clause'
SELECT whatMovieID, times, movieID FROM whatsShowingMovies WHERE whatsShowingID=Array AND movieID=7685

MallMovie

Dumbo [2d]

Dumbo [2d]
A young elephant, whose oversized ears enable him to fly, helps save a struggling circus, but when the circus plans a new venture, Dumbo and his friends discover dark secrets beneath its shiny veneer.
Cast: Colin Farrell, Michael Keaton, Danny DeVito
Director: Tim Burton
Producer: N/A
Genre: Fantasy
Age Restriction: N/A
Length: 1h 52m