+----+---------+------+
| ID |  NAME   | KIND |
+----+---------+------+
|  1 |Fruits   |   2  |
|  2 |Vegetable |   2  |
|  3 |Eatable  |   1  |
|  4 |Poison   |   1  |
|  5 |Delicious|   1  |
+----+---------+------+

+----+--------+
| ID |  NAME  |
+----+--------+
|  1 |Apple   |
|  2 |Orange  |
|  3 |Potato  |
|  4 |Poganka |
|  5 |Eggs    |
+----+--------+

+-----+-----+
| OID | СID |  Комментарии за кадром
+-----+-----+
|  1  |  1  |  Apple -> Fruits
|  1  |  3  |  Apple -> Eatable
|  2  |  1  |  Orange -> Fruits
|  2  |  3  |  Orange -> Eatable
|  2  |  5  |  Orange -> Delicios (повторение в классификаторе KIND 1)
|  3  |  2  |  Potato -> Vegetable
|  3  |  3  |  Potato -> Eatable
|  4  |  4  |  Poganka -> Poison
|  5  |  3  |  Eggs -> Eatable
+-----+-----+

+----+-----------+----------+----------+
| ID |  OBJNAME  | CLASS_1  | CLASS_2  |
+----+-----------+----------+----------+
|  1 | Apple     | Eatable  | Fruits   |
|  2 | Orange    | Delicious| Fruits   | Delicios или Eatable - несущественно
|  3 | Potato    | Eatable  | Vegetable|
|  4 | Poganka   | Poison   | <NULL>   |
|  5 | Eggs      | Eatable  | <NULL>   |
+----+-----------+----------+----------+

SELECT  H.ID, H.NAME OBJNAME, MAX(C1.NAME) CLASS_1, MAX(C2.NAME) CLASS_2
FROM GET_CLASSIDS( 1 ) GCC
  INNER JOIN CLASSLINK CL1 ON (CL1.CLASS_ID = GCC.ID)
  INNER JOIN CLASSTREE C1 ON (C1.ID = CL1.CLASS_ID) AND (C1.KIND_ID =  1 )
  INNER JOIN H ON (H.ID = CL1.HTML_ID)
  LEFT JOIN CLASSLINK CL2 ON (H.ID = CL2.HTML_ID)
  LEFT JOIN CLASSTREE C2 ON (C2.ID = CL2.CLASS_ID) AND (C2.KIND_ID =  2 )
GROUP BY  1 ,  2