SELECT t1.*
FROM biotopelist AS t1
WHERE rusname AND Right(t1.rangcode, 8)  = '00000000'
  AND EXISTS
    (SELECT NULL FROM biotopelist AS t2
     WHERE Left(t2.rangcode, 1) = Left(t1.rangcode, 1)
     AND Right(t2.rangcode, 8) <> '00000000')