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

MallMovie

Aquaman [3d]

Aquaman [3d]
Arthur Curry learns that he is the heir to the underwater kingdom of Atlantis, and must step forward to lead his people and be a hero to the world.
Show Times: 20:30; 17:30; 11:15; 14:15
Cast: Jason Momoa, Amber Heard, Willem Dafoe
Director: James Wan
Producer: N/A
Genre: Action, Adventure, Fantasy
Age Restriction: 13DLPV
Length: 136min