ModelDB
: Model Database
User:
Public
SenseLab
Home
Data
Search
Schema
Login
[
Data
]
SQL programs
Name
network models before 20080501 with cell counts
Description
SQL Program
select model.object_name, count(model_neurons.value_) as neurontypes, count(model_other_neurons.value_) as otherneurontypes from objects model, eav_objects type, eav_objects model_neurons, eav_objects model_other_neurons where model.object_class=19 and model.created < '01-MAY-2008' and model.private=0 and model.object_id=type.object_id and type.attribute_id=112 and type.value_=3536 and model_neurons.object_id(+)=model.object_id and model_neurons.attribute_id=25 and model_other_neurons.attribute_id(+)=301 and model_other_neurons.object_id(+)=model.object_id group by model.object_name
Maximum Rows
Maximum Columns
Other categories referring to "
network models before 20080501 with cell counts
"
Revisions:
8
Last time:
5/9/2008 1:54:07 PM
Reviewer:
Tom Morse - MoldelDB admin
Owner:
Tom Morse - MoldelDB admin
Questions, comments, problems? Email the
Database Administrator
This site is Copyright 2010, Yale Center for Medical Informatics