An Error Was Encountered

Error Number: 1054

Unknown column 'media_gallery' in 'where clause'

SELECT ad.disciplineID, l.lookupText FROM artist_discipline AS ad, lookup AS l WHERE ad.artistID = media_gallery AND ad.disciplineID = l.lookupID ORDER BY l.lookupText