select paper.object_id, paper.object_name, paper_title.value_ as paperTitle, count(models.object_id) as PublicModels
from objects models, eav_objects model_paper, objects paper, eav_objects citations, eav_memo paper_title
where models.object_class=19 and models.private=0 and model_paper.value_=citations.object_id and paper.object_id=paper_title.object_id and paper_title.attribute_id=139 and model_paper.object_id=models.object_id and model_paper.attribute_id=155 and citations.attribute_id=140 and paper.object_id = citations.value_ group by paper.object_id,paper.object_name, paper_title.value_ order by COUNT(models.OBJECT_ID) DESC, paper.object_name
|