SELECT EDGES.OBJECT_NAME,TARGET.VALUE_ FROM
OBJECTS EDGES, EAV_STRING SOURCE, EAV_STRING TARGET, EAV_OBJECTS, EAV_INT SERIALNO WHERE
EDGES.OBJECT_ID=SOURCE.OBJECT_ID AND EDGES.OBJECT_ID=TARGET.OBJECT_ID AND
EDGES.OBJECT_ID=EAV_OBJECTS.OBJECT_ID AND EDGES.OBJECT_ID=SERIALNO.OBJECT_ID AND
EDGES.OBJECT_CLASS=125 AND SOURCE.ATTRIBUTE_ID=421 AND
TARGET.ATTRIBUTE_ID=422 AND
EAV_OBJECTS.ATTRIBUTE_ID=424 AND EAV_OBJECTS.VALUE_=88224 AND
SOURCE.VALUE_=0 AND
SERIALNO.ATTRIBUTE_ID=425 ORDER BY SERIALNO.VALUE_
|