select model.object_id as "model_obj_id", model.object_name as "model_name", paper.object_name as "authorsYear", title.value_ as "title", journal.value_ as "journal", volume.value_ as "volume", first.value_ as "first", last.value_ as "last", pmid.value_ as "pmid" from objects model, objects paper, objects paper1, eav_objects model_paper_link, eav_objects model_paper1_link, eav_string year, eav_memo title, eav_string journal, eav_string volume, eav_string first, eav_string last, eav_string pmid where model.object_class=19 and paper.object_class=42 and paper1.object_class=42 and model_paper_link.attribute_id=155 and model_paper1_link.attribute_id=155 and title.attribute_id=139 and journal.attribute_id=158 and volume.attribute_id=149 and first.attribute_id=150 and last.attribute_id=151 and pmid.attribute_id(+)=153 and paper.object_id=title.object_id and paper.object_id=journal.object_id and paper.object_id=journal.object_id and paper.object_id=volume.object_id and paper.object_id=first.object_id and paper.object_id=last.object_id and paper.object_id=pmid.object_id(+) and lower(paper1.object_name) like '%dest%' and paper1.object_id=model_paper1_link.value_ and model.object_id=model_paper1_link.object_id and model.object_id=model_paper_link.object_id and paper.object_id=model_paper_link.value_ and year.attribute_id(+)=154 and year.object_id(+)=paper.object_id
order by year.value_(+) desc, model.object_name asc
|