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=8194 ORDER BY b.movieID ASC
Maleficent: Mistress Of Evil (3d) | Movie | Mall of Africa
Database query failed: Unknown column 'Array' in 'where clause'
SELECT whatMovieID, times, movieID FROM whatsShowingMovies WHERE whatsShowingID=Array AND movieID=8194

MallMovie

Maleficent: Mistress Of Evil (3d)

Maleficent: Mistress Of Evil (3d)
The complex relationship between the horned fairy and the soon-to-be-Queen continues, as they form new alliances and face new adversaries in their struggle to protect the moors and the magical creatures that reside within.
Cast: Angelina Jolie, Elle Fanning
Director: Joachim Rønning
Producer: N/A
Genre: Adventure, Fantasy
Age Restriction: 7–9PG V
Length: 118min