A Database Error Occurred

Error Number: 1054

Unknown column 'at_a_glance' in 'where clause'

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