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.CN LIKE CONCAT((SELECT DISTINCT p2.tgn_CN FROM cad_country_lookup p2 WHERE p2.tgn_TermMasterID='1475798'),'%') ORDER BY p.title ASC LIMIT 18 Philadelphia Museum of Art - Collections : Search Collections