SELECT DISTINCT p.ObjectID, p.title, p.DisplayName, p.Classification, p.Culture, p.MainFile, p.DepartmentID, d.Department, l.Gallery FROM cad_peopleobjects `p` LEFT JOIN cad_media `m` ON p.ObjectID = m.ObjectID LEFT JOIN cad_locations `l` ON p.ObjectID = l.ObjectID LEFT JOIN `cad_departments` d ON p.DepartmentID = d.DepartmentID WHERE p.DepartmentID = 8 GROUP BY p.ObjectID ORDER BY p.AlphaSort ASC, p.title ASC LIMIT 18 Philadelphia Museum of Art - Collections : Search Collections