select distinct model.object_id, model.object_name, paper.object_id, paper.object_name, journal.value_, volume.value_ as "volume" from objects model, objects paper, objects paper1, eav_objects model_paper_link, eav_objects model_paper1_link, eav_string year, eav_memo t, 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 t.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=t.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 and model.private=0 order by model.object_name, paper.object_name
|