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=7402 ORDER BY b.movieID ASC
Creed II - 2018 | Movie | Mall of Africa

MallMovie

Creed II - 2018

Creed II - 2018
Under the tutelage of Rocky Balboa, light heavyweight contender Adonis Creed faces off against Viktor Drago, son of Ivan Drago.
Show Times: 20:15
Cast: Michael B. Jordan, Sylvester Stallone, Tessa Thompson
Director: Steven Caple Jr.
Producer: N/A
Genre: Drama
Age Restriction: 13 DLSV
Length: 128min