ModelDB: Model Database User: Public
SenseLab  Home Data Search Schema Login	[Data] SQL programs Name find models whose papers have doi`s Description SQL Program 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 Maximum Rows Maximum Columns Other categories referring to "find models whose papers have doi`s"   Revisions: 1 Last time: 7/18/2012 4:25:24 PM Reviewer: Tom Morse - MoldelDB admin Owner: Tom Morse - MoldelDB admin
	Questions, comments, problems? Email the Database Administrator This site is Copyright 2010, Yale Center for Medical Informatics