SQL programs

Data

Name count of Non-NEURON models added last year

Description

SQL Program select distinct models.object_name from objects datemodelpublic, objects models, eav_objects model_application, objects application where datemodelpublic.object_class=127 and datemodelpublic.object_name=models.object_id and models.object_id = model_application.object_id and model_application.attribute_id = 114 and model_application.value_ <> 1882 and model_application.value_ <> 7841 and application.object_id=model_application.value_ and datemodelpublic.object_description < '20070501' and datemodelpublic.object_description > '20060431'

Maximum Rows

Maximum Columns