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=7726 ORDER BY b.movieID ASC
Hellboy (imax) | Movie | Mall of Africa

MallMovie

Hellboy (imax)

Hellboy (imax)
Based on the graphic novels by Mike Mignola, Hellboy, caught between the worlds of the supernatural and human, battles an ancient sorceress bent on revenge.
Show Times: 12:15; 17:45
Cast: David Harbour, Milla Jovovich, Ian McShane
Director: Neil Marshall
Producer: N/A
Genre: Action, Adventure, Fantasy
Age Restriction: N/A
Length: 2h