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=7554 ORDER BY b.movieID ASC
How To Train Your Dragon: Hidden World (3d) | Movie | Mall of Africa

MallMovie

How To Train Your Dragon: Hidden World (3d)

How To Train Your Dragon: Hidden World (3d)
When Hiccup discovers Toothless isn't the only Night Fury, he must seek "The Hidden World", a secret Dragon Utopia before a hired tyrant named Grimmel finds it first.
Show Times: 11:30; 09:00; 14:00
Cast: Cate Blanchett, Gerard Butler, Kit Harington
Director: Dean DeBlois
Producer: N/A
Genre: Animated Comedy, Family, Adventure
Age Restriction: N/A
Length: 1h44m