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=7526 ORDER BY b.movieID ASC
Glass [2d] | Movie | Mall of Africa

MallMovie

Glass [2d]

Glass [2d]
Security guard David Dunn uses his supernatural abilities to track Kevin Wendell Crumb, a disturbed man who has twenty-four personalities.
Show Times: 14:30; 09:00; 16:45; 11:45; 19:30
Cast: Anya Taylor-Joy, James McAvoy, Sarah Paulson
Director: M. Night Shyamalan
Producer: N/A
Genre: Drama
Age Restriction: N/A
Length: 2h9min