SELECT CAN_FORM.VALUE_ AS CF_COMP_NO, NEU_ASSOC.OBJECT_ID AS OBJECT_ID, PROP.OBJECT_ID AS PR_ID, PROP.OBJECT_NAME AS NAME, PRESENT.VALUE_ PRESENT FROM OBJECTS NEU_ASSOC, EAV_OBJECTS NEU_PROP, OBJECTS PROP, EAV_OBJECTS CAN_FORM, EAV_OBJECTS NEURON, EAV_INT PRESENT WHERE NEU_ASSOC.OBJECT_ID = NEU_PROP.OBJECT_ID AND NEU_PROP.VALUE_ = PROP.OBJECT_ID AND NEU_ASSOC.OBJECT_ID = CAN_FORM.OBJECT_ID AND NEU_ASSOC.OBJECT_ID = NEURON.OBJECT_ID AND NEU_ASSOC.OBJECT_ID = PRESENT.OBJECT_ID (+) AND (NEU_PROP.ATTRIBUTE_ID = 49) AND (CAN_FORM.ATTRIBUTE_ID = 47) AND (NEU_ASSOC.OBJECT_CLASS =25) AND (NEURON.VALUE_ = 258) AND (NEURON.ATTRIBUTE_ID = 60) AND (PRESENT.ATTRIBUTE_ID (+) = 108)
|