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=7572 ORDER BY b.movieID ASC
How To Train Your Dragon: Hidden World (3d Imax) | Movie | Mall of Africa
Database query failed: Unknown column 'Array' in 'where clause'
SELECT whatMovieID, times, movieID FROM whatsShowingMovies WHERE whatsShowingID=Array AND movieID=7572

MallMovie

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

How To Train Your Dragon: Hidden World (3d Imax)
As Hiccup fulfills his dream of creating a peaceful dragon utopia, Toothless' discovmery of an untamed, elusive mate draws the Night Fury away. When danger mounts at home and Hiccup's reign as village chief is tested, both dragon and rider must make impossible decisions to save their kind.
Cast: N/A
Director: N/A
Producer: N/A
Genre: Animated, Family, Adventure
Age Restriction: 7-9pg
Length: 1h 44m