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=7598 ORDER BY b.movieID ASC
Alita: Battle Angel | Movie | Mall of Africa

MallMovie

Alita: Battle Angel

Alita: Battle Angel
BATTLE ANGEL, an epic adventure of hope and empowerment. When Alita (Rosa Salazar) awakens with no memory of who she is in a future world she does not recognize...
Show Times: 12:00
Cast: N/A
Director: N/A
Producer: N/A
Genre: Action, Adventure, Sci-Fi
Age Restriction: 16 D L V
Length: 2h 2m