SELECT count(NRNS.object_name), NRNS.object_name 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')) group by NRNS.object_name order by count(NRNS.object_name)
|