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=7787 ORDER BY b.movieID ASC
Intruder, The [2d] | Movie | Mall of Africa

MallMovie

Intruder, The [2d]

Intruder, The [2d]
A young married couple buy a beautiful house on several acres of land only to find out that the man they bought it from refuses to let go of the property.
Show Times: 15:00; 09:30; 20:00; 12:15; 17:30
Cast: Dennis Quaid, Meagan Good, Michael Ealy
Director: Deon Taylor
Producer: N/A
Genre: Drama
Age Restriction: N/A
Length: 1h 42m