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=8274 ORDER BY b.movieID ASC
Charlie's Angels 2019 | Movie | Mall of Africa
Database query failed: Unknown column 'Array' in 'where clause'
SELECT whatMovieID, times, movieID FROM whatsShowingMovies WHERE whatsShowingID=Array AND movieID=8274

MallMovie

Charlie's Angels 2019

Charlie's Angels 2019
When Soh Bae turns up applying to be Charlie's 4th Angel, she is thrown into the deep end immediately as the other angels are kidnapped by the mysterious Ronny Petankan. With only her nerdy sidekick Nathan Woodhall to help, it is up to Soh to save the angels and save the world before breakfast.
Cast: Kristen Stewart, Naomi Scott, Ella Balinska
Director: Elizabeth Banks
Producer: N/A
Genre: Action
Age Restriction: 13LV
Length: 118min