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=7784 ORDER BY b.movieID ASC
Hustle, The [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=7784

MallMovie

Hustle, The [2d]

Hustle, The [2d]
Anne Hathaway and Rebel Wilson star as female scam artists, one low rent and the other high class, who team up to take down the men who have wronged them.
Cast: Anne Hathaway, Rebel Wilson, Alex Sharp
Director: Chris Addison
Producer: N/A
Genre: Comedy
Age Restriction: 13 LSV
Length: 1h 33m