select model.object_id, model.object_name, year.value_ from objects model, eav_objects modelpaper, eav_string journal, eav_string year where
model.object_class = 19 and
model.private=0 and
model.object_id = modelpaper.object_id and
modelpaper.attribute_id = 155 and
modelpaper.value_ = journal.object_id and
journal.attribute_id = 158 and
journal.value_ = 'J Neurophysiol' and
modelpaper.value_ = year.object_id and
year.attribute_id = 154 order by
year.value_
|