SELECT distinct po.project, po.contactperson, po.startdate, po.enddate, po.inferred, po.deletedbyinference, po.trust, po.inferenceprovenance, 'contactperson@@@contactperson@@@dnet:project_organization_relations@@@dnet:project_organization_relations' as semantics FROM project_organization po LEFT OUTER JOIN persons p on (p.id = po.contactperson) WHERE po.contactperson is not null AND (p.firstname is not null OR p.secondnames is not null)