Mercurial > hg > tema
view misc/biotopes/class.sql @ 13:ac5f1bc82b13
Fix the demo console initialization.
author | Mikhail Kryshen <mikhail@kryshen.net> |
---|---|
date | Tue, 24 Mar 2009 16:00:55 +0300 |
parents | 6c41a0b43e58 |
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')