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

MallMovie

Matwetwe

Matwetwe
A coming-of-age adventure following Lefa and Papi, best friends and recent high school graduates, on the biggest hustle of their young lives. Over the course of one action-packed New Year’s Eve in the iconic township of Atteridgeville, the boys try to pull off a huge deal, dodge a kingpin gangster and his violent gang members, get the girl and, ultimately, save their own lives in this hilarious but sometimes very serious escapade.
Cast: Tebatso Mashishi, Sibusiso Khwinana,
Director: Kagiso Lediga
Producer: N/A
Genre: Action, Crime, Drama
Age Restriction: 16DLSV
Length: 81min