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=6263 ORDER BY b.movieID ASC
Assassin's Creed [2d] | Movie | Mall of Africa
Database query failed: Unknown column 'Array' in 'where clause'
SELECT whatMovieID, times, movieID FROM whatsShowingMovies WHERE whatsShowingID=Array AND movieID=6263

MallMovie

Assassin's Creed [2d]

Assassin's Creed [2d]
When Callum Lynch explores the memories of his ancestor Aguilar and gains the skills of a Master Assassin, he discovers he is a descendant of the secret Assassins society.
Cast: Michael Fassbender, Marion Cotillard, Jeremy Irons
Director: Justin Kurzel
Producer: N/A
Genre: Action, Adventure, Fantasy
Age Restriction: 10-12PGV
Length: 1h 48m