select doi.value_, models.object_id, models.object_name,
models.created ,papers.object_name, paperyear.value_, row_number()
over (order by doi.value_) as [serial]
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 order by
serial
|