select target.object_id, target.object_name, serialno.value_ from
objects target, objects edge, eav_objects tree, eav_string sourceparent,
eav_objects relation, eav_string targetchild, eav_int serialno where
edge.object_class=125 and edge.object_id=tree.object_id and
edge.object_id=targetchild.object_id and
edge.object_id=sourceparent.object_id and edge.object_id=relation.object_id and
edge.object_id=serialno.object_id(+) and
tree.attribute_id=424 and sourceparent.attribute_id=421 and targetchild.attribute_id=422 and serialno.attribute_id(+)=425 and target.object_id=targetchild.value_ and
sourceparent.value_=88226
and relation.attribute_id=423 and relation.value_=88222 order by serialno.value_(+), target.object_name
|