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

MallMovie

Captain Marvel [3d]

Captain Marvel [3d]
Carol Danvers becomes one of the universe's most powerful heroes when Earth is caught in the middle of a galactic war between two alien races.
Show Times: 09:00; 20:00; 11:45; 14:30; 17:15
Cast: N/A
Director: N/A
Producer: N/A
Genre: Action, Adventure, Sci-Fi
Age Restriction: 13LV
Length: 142min