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=7655 ORDER BY b.movieID ASC
Cold Pursuit | Movie | Mall of Africa

MallMovie

Cold Pursuit

Cold Pursuit
A snowplow driver seeks revenge against the drug dealers he thinks killed his son. Based on the 2014 Norwegian film 'In Order of Disappearance'
Show Times: 20:15; 17:45
Cast: N/A
Director: N/A
Producer: N/A
Genre: Action
Age Restriction: 16
Length: 1h 58m