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=7673 ORDER BY b.movieID ASC
Kandasamys: The Wedding [2d] | Movie | Mall of Africa

MallMovie

Kandasamys: The Wedding [2d]

Kandasamys: The Wedding [2d]
Welcome to the world of neighbours on the verge of becoming one big, happy family – The Kandasamys and the Naidoos.
Show Times: 12:30; 18:00
Cast: N/A
Director: N/A
Producer: N/A
Genre: Comedy
Age Restriction: N/A
Length: 1h 37m