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, OBJECTS NRNS 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 in ('49','53','57')) AND (CAN_FORM.ATTRIBUTE_ID in ('47','52','56')) AND (NEU_ASSOC.OBJECT_CLASS IN ('25','26','27')) AND NRNS.OBJECT_CLASS=18 AND(NEURON.value = NRNS.OBJECT_ID) AND (NEURON.ATTRIBUTE_ID IN ('60','61','62'))
|