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=7711 ORDER BY b.movieID ASC
Hellboy - 2019 | Movie | Mall of Africa

MallMovie

Hellboy - 2019

Hellboy - 2019
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: 20:00; 14:30; 09:00
Cast: David Harbour, Milla Jovovich, Ian McShane
Director: Neil Marshall
Producer: N/A
Genre: Action, Adventure, Fantasy
Age Restriction: 18DHLV
Length: 121min