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=7695 ORDER BY b.movieID ASC
Avengers: Endgame [3d] | Movie | Mall of Africa

MallMovie

Avengers: Endgame [3d]

Avengers: Endgame [3d]
After the devastating events of Avengers: Infinity War (2018), the universe is in ruins. With the help of remaining allies, the Avengers assemble once more in order to undo Thanos' actions and restore order to the universe.
Show Times: 16:45; 09:15; 20:45; 12:45; 09:00; 13:00; 20:30; 17:00
Cast: Brie Larson, Robert Downey Jr., Karen Gillan
Director: Anthony Russo, Joe Russo
Producer: N/A
Genre: Action, Adventure, Sci-Fi
Age Restriction: N/A
Length: 3h 1m