select doi.value_, models.object_id, models.object_name, models.created ,papers.object_name, paperyear.value_ from objects models, objects papers, eav_objects model_paper, eav_string paperyear, eav_string doi where models.object_class=19 and models.private=0 and model_paper.attribute_id=155 and model_paper.object_id=models.object_id and model_paper.value_=papers.object_id and papers.object_class=42 and paperyear.attribute_id=154 and paperyear.object_id= papers.object_id and doi.object_id=papers.object_id and doi.attribute_id=339 and lower(doi.value_)=lower('10.1371/journal.pcbi.1000089') order by paperyear.value_ desc, papers.object_name
|