select models.object_name, models.object_id, models.created ,papers.object_name, paperyear.value_ from objects models, objects papers, eav_objects model_paper, eav_string paperyear 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 order by paperyear.value_ desc, papers.object_name
|