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=7678 ORDER BY b.movieID ASC
Shazam! [3d] | Movie | Mall of Africa

MallMovie

Shazam! [3d]

Shazam! [3d]
We all have a superhero inside us, it just takes a bit of magic to bring it out. In Billy Batson's case, by shouting out one word - SHAZAM! - this streetwise fourteen-year-old foster kid can turn into the adult superhero Shazam.
Show Times: 11:45; 17:15
Cast: Zachary Levi, Michelle Borth, Djimon Hounsou
Director: David F. Sandberg
Producer: N/A
Genre: Action, Adventure, Comedy
Age Restriction: 10-12 PGLHIATLV
Length: 2h 12m