select datemodelpublic.object_description as day, model.object_id as accession, model.object_name as model, becausewas.object_name as provenance, journal.value_ as Journal from objects datemodelpublic, objects model, objects becausewas, eav_objects note, eav_objects modelpaper, eav_string journal where datemodelpublic.object_class=127 and datemodelpublic.object_name=model.object_id and model.object_class=19 and note.attribute_id=426 and note.object_id=datemodelpublic.object_id and note.value_=becausewas.object_id and becausewas.object_class=128 and model.object_id=modelpaper.object_id and modelpaper.attribute_id=155 and modelpaper.value_=journal.object_id and journal.attribute_id=158 order by datemodelpublic.object_description desc
|