select pubmed_id.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 pubmed_id 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 pubmed_id.object_id=papers.object_id and pubmed_id.attribute_id=153 order by paperyear.value_ desc, papers.object_name
|