select datemodelpublic.object_description as day, serialno.value_ as serialno , model.object_id as accession, model.object_name, paper.object_name as authors_year,journal.value_ as journal from objects datemodelpublic, objects model, objects becausewas, eav_objects note, eav_int serialno, objects paper, eav_objects model_paper, eav_string journal where journal.attribute_id=158 and journal.object_id=paper.object_id and paper.object_class=42 and model_paper.attribute_id=155 and model_paper.object_id=model.object_id and model_paper.value_=paper.object_id and 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 serialno.object_id= datemodelpublic.object_id and serialno.attribute_id=427 order by datemodelpublic.object_description
|