SELECT proj_pers_role.VALUE, pers.OBJECT_ID,
pers.OBJECT_NAME, COUNT(pers.OBJECT_ID) AS LINKED
FROM OBJECTS pers, EAV_OBJECTS proj_pers_role,
EAV_OBJECTS pers_role_role, OBJECTS role, EAV_OBJECTS pers_role_pers,
OBJECTS pers_role
WHERE pers_role.OBJECT_ID = proj_pers_role.VALUE
AND proj_pers_role.ATTRIBUTE_ID = 222
and proj_pers_role.VALUE=pers_role_role.OBJECT_ID
and proj_pers_role.VALUE=pers_role_pers.OBJECT_ID
and pers_role_role.ATTRIBUTE_ID=237
and role.OBJECT_ID=pers_role_role.VALUE
AND LOWER(ROLE.OBJECT_NAME)='principle investigator'
and pers_role_pers.attribute_id=236
and pers_role_pers.value=pers.object_id
GROUP BY pers.OBJECT_NAME, pers.OBJECT_ID, proj_pers_role.VALUE
ORDER BY UPPER(OBJECT_NAME)
|