Mercurial > hg > tema

view dist/biotopes/class.sql @ 1:548a93c24e55 release_0_1jk

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Tema 0.1jk - Javakonkurs edition (imported from CVS).
author Mikhail Kryshen <mikhail@kryshen.net>
date Thu, 14 Dec 2006 23:22:05 +0300
parents 1d2fe61a3a62
children
line wrap: on
line source

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')