|
|
|
Data
|
unique made public date, accession # for models
|
old version that mysteriously stopped working: select distinct datemodelpublic.object_description, models.object_id, 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 application.object_id=model_application.value_ order by datemodelpublic.object_description
|
select distinct datemodelpublic.object_description, models.object_id, models.object_name from objects datemodelpublic, objects models, eav_objects model_application, objects application where datemodelpublic.object_class=127 and datemodelpublic.object_name= cast(models.object_id as varchar(100)) and models.object_id = model_application.object_id and model_application.attribute_id = 114 and application.object_id=model_application.value_ order by datemodelpublic.object_description
|
|
|
|
|