SELECT NEURON.OBJECT_ID AS NEURON_ID, NEURON.OBJECT_NAME AS NEURON_NAME, ORGANISM.OBJECT_NAME AS ORGANISM_NAME,
NEURON_NEURON_CATEGORY.VALUE_ AS NEURON_CATEGORY_ID,
INTERNEURONS.VALUE_ AS INTERNEURON_ID
FROM EAV_OBJECTS PRINCIPAL, EAV_OBJECTS INTERNEURONS,
OBJECTS NEURON, EAV_OBJECTS NEURON_ORGANISM, OBJECTS ORGANISM,
EAV_OBJECTS NEURON_NEURON_CATEGORY
WHERE PRINCIPAL.OBJECT_ID = INTERNEURONS.OBJECT_ID (+) AND
PRINCIPAL.VALUE_ (+) = NEURON.OBJECT_ID AND
NEURON.OBJECT_ID = NEURON_ORGANISM.OBJECT_ID (+)
AND ORGANISM.OBJECT_ID (+) = NEURON_ORGANISM.VALUE_ AND
NEURON.OBJECT_ID = NEURON_NEURON_CATEGORY.OBJECT_ID
AND (NEURON_ORGANISM.ATTRIBUTE_ID (+) = 111) AND
(NEURON_NEURON_CATEGORY.ATTRIBUTE_ID (+) = 142)
AND (NEURON.OBJECT_CLASS = 18) AND (PRINCIPAL.ATTRIBUTE_ID (+) = 317) AND
(INTERNEURONS.ATTRIBUTE_ID (+) = 316)
ORDER BY ORGANISM_NAME DESC, NEURON_NAME
|