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

MallMovie

Bumblebee [3d]

Bumblebee [3d]
On the run in the year of 1987, Bumblebee finds refuge in a junkyard in a small Californian beach town. Charlie, on the cusp of turning 18 and trying to find her place in the world, discovers Bumblebee, battle-scarred and broken.
Show Times: 19:45; 09:00; 17:00; 14:00; 11:30
Cast: Hailee Steinfeld, Dylan O'Brien, Megyn Price
Director: Travis Knight
Producer: N/A
Genre: Action, Adventure, Sci-Fi
Age Restriction: 10-12PGLV
Length: 114min