1054 - Unknown column 'videocity' in 'where clause'

Select * from film_gener_gallery_child Where active='Y' and film_gener_gallery_master_id=videocity order by film_gener_gallery_child_id DESC

Error