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=8069 ORDER BY b.movieID ASC
Dora And The Lost City Of Gold | Movie | Mall of Africa
Database query failed: Unknown column 'Array' in 'where clause'
SELECT whatMovieID, times, movieID FROM whatsShowingMovies WHERE whatsShowingID=Array AND movieID=8069

MallMovie

Dora And The Lost City Of Gold

Dora And The Lost City Of Gold
Having spent most of her life exploring the jungle with her parents, nothing could prepare Dora for her most terrifying adventure ever—high school.
Cast: Isabela Moner, Eugenio Derbez, Eva Longoria
Director: James Bobin
Producer: N/A
Genre: Adventure, Family, Fantasy
Age Restriction: PG
Length: 102min